Excel - Drag & Drop to Values, Excel Daily Paper, Trending XL - Episode 1754

1,420 views · Published 18 July 2013 · 3:34 · Indexed 10 November 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Daily Newspaper, Book Giveaway, and Trending XL Topics | MrExcel Podcast.

Welcome to the MrExcel podcast! In this episode, we'll be discussing the Excel Daily Newspaper, a book giveaway, and trending XL topics. I'm your host, Bill Jelen, and I have some exciting things to share with you today.

First up, we have The Excel Daily, a newspaper that curates the best articles and videos about Excel from the past day. This is a great resource for staying up-to-date on all things Excel. The link to The Excel Daily will be in the description below, so be sure to check it out and let me know what you think.

Next, I want to mention Mike's new book, which will be released soon. Goodreads is giving away 10 free autographed copies, and the link to enter the giveaway will also be in the description. The giveaway ends on Saturday at midnight, so don't miss your chance to win a copy. And if you're a Goodreads member, you can also help boost Mike's book in the trending topics by clicking the "Want to Read" button.

Now, let's talk about the MrExcel message board. Our community is very active, with over 30,000 questions answered. To make it easier for you to stay updated on the top discussions, I've started a new blog post that rounds up the top 10 topics from the previous day. The link to this blog post will also be in the description, so be sure to check it out.

And of course, no MrExcel podcast would be complete without an Excel trick. In this episode, I'll be showing you how to use the drag and drop method to convert formulas to values. This trick was inspired by a question on Twitter, and I couldn't find a video that demonstrated it, so I decided to share it with you today. The trick is to right-click and drag the selection, then drag it back to the original location while holding the right mouse button, and finally, select "Copy Here as Values Only" from the menu that appears. This will convert your formulas to values in just a few simple steps.

I hope you found these tips and tricks helpful. As always, the links to everything mentioned in this episode will be in the description below. Thank you for tuning in, and I'll see you next time for another netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Trending Excel Topics
(00:20) Goodreads Book Giveaway
(00:51) MrExcel Message Board and Blog
(01:44) Excel Trick: Converting Formulas to Values
(03:19) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Alternate drag and drop menu
Book giveaway
Copy and paste values method
Drag and drop method for converting formulas to values
Excel Daily newspaper
Excel trick - convert formulas to values
Goodreads
MrExcel message board
Netcast from MrExcel
Trending XL topics


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153574/

URLs in the video:
Excel Daily: http://paper.exceldailynews.com/
Top 10 MrExcel Forum Topics: http://hottopicsmrexcelforum.wordpress.com/
The giveaway for Ctrl+Shift+Enter is over.
There is a lot happening in today's podcast. A new Excel Daily newspaper. A giveaway of Mike's new book. A place to browse the top 10 trending Excel topics from the MrExcel Message board. Convert first name last name in two columns to First name and last initial in a new column. Convert formulas to values by dragging.

More from this channel