FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
October 15, 2015

Greetings from The Excel Addict
Hi fellow Excel Addict,

sun Here in eastern Newfoundland, all this week we have been spoiled by unseasonably warm weather. Several record-breaking temps (20C+) for October were awesome. It's hard to stay inside and work when each day could be possibly the last warm day we'll see around here for 6 or 7 months :(


Escaping the corporate world and getting control of my own time has turned out to be a double-edged sword. Yes, it's great not having someone else dictating what I do, but developing the entrepreneurial self discipline to do the things that I need to do rather than the things I feel like doing at any one moment has turned out to be much harder than I was expecting.

 That's one skill I'll just have to keep working on.

Keep on Excelling,

Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (The Excel Addict)


If you missed my last newsletter, you can click here to view it online.



The Excel Addict Quote of the Week
"YOU CAN'T ESCAPE THE RESPONSIBILITY
OF TOMORROW BY EVADING IT TODAY."
-- Abraham Lincoln --
If you have a favourite quote, send it to me and I may post it in my newsletter.


Today's Microsoft Excel Tip

A Super-Quick Trick to Convert Formulas to Values

Convert Formulas To Values Trick in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365Here's a super-quick way to convert your formulas to values that very few Excel users are aware of.

1) Select the cells containing formulas (must be one contiguous range);

2) Move your mouse to the edge of the selected range until the mouse pointer changes to a 4-headed arrow;

3) Using the right mouse button, click and drag the cells to the next column, BUT DON'T RELEASE THE MOUSE BUTTON YET. Keeping the mouse button pressed, drag back to the original location and release the mouse button.

4) Click the 'Copy Here as Values Only' option from the menu that pops up.

5) Voila!




FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630