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


Greetings from The Excel Addict
Hi fellow Excel Addict,

Francis Hayes (The ExcelAddict) www.TheExcelAddict.com Conception Bay South, Newfoundland, CanadaTypo
As 'many' readers pointed out to me this week, my 'Excel in Seconds' tip on Tuesday contained a typo. In step 4 of the tip it said press CTRL+P to Paste but, as we all know, CTRL+P is the shortcut for Print and CTRL+V is the shortcut for Paste. Sorry about that. I have corrected in the online version of my newsletter.

Tip doesn't work in Gmail, Doh!
Also, I heard from many of you who said when you tried to paste a copied range from Excel into Gmail, only the text was pasted. Maybe I'm one of the few people in the world who doesn't have a Gmail account. Over the years I have used either Lotus Notes or Outlook as my email client. Pasting bits of data from my Excel worksheets is something I've always been able to do, so I didn't test that tip with any web-based email.

I will take a second look at pasting data from Excel into email in the coming weeks and revise that tip. When I do I'll let you know and share the link with you. In the meantime, if you regularly copy Excel data into your emails, tell me how you do it and which email you use.

Halloween
I don't know if you will be celebrating Halloween on Saturday but if you do, I'd love for you to send me a photo and tell me where (which country) you are.And I'll try to get you a better photo than the one above...a real one.

Keep on Excelling and keep on sharing these tips with your friends and colleagues.

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

JUST A FEW HOURS LEFT
to join Mynda's Excel Dashboard Course

(registration closes 8pm PST)
In the past two years, more than 1,000 Excel Addict
subscribers
have taken Mynda's Dashboard course
Here's what one 'Excel Addict' had to say about the webinar and course in July...

"Hi Francis, I just registered for Mynda’s Excel Dashboard class and I am so excited to get started! Thank you so much for recommending her course to your readers. I participated in the two webinars last week and was blown away. I didn’t even know some of those things were possible in Excel! I really can’t wait to dive in and learn more about Power Query and Power Pivot- I think they are going to completely change the way I do my reports." -- Brook H.


EXCELADDICT Bonus E-book
I am super excited to announce that, coming soon, I will be releasing my 'Excel in Seconds' e-book volume 1, containing 100 quick tips and shortcuts that will take you only seconds to learn but will save you hours and hours of work, week after week, month after month, and year after year.

As a bonus for anyone who enrolls in Mynda's Excel Dashboard Course and uses my coupon code EXCELADDICT on the checkout page, you will receive a free copy of my e-book.
Excel Dashboards Webinar by Mynda Treacy
Excel Dashboards Course by Mynda Treacy
Learn to Create Excel Dashboard Reports in this free 1-hour webinar by Mynda TreacyMynda's Excel Dashboard Course 2010, 2013, 2016


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

You can access even more tips on my website by going to my members' page


The Excel Addict Quote of the Week
"Those who surrender freedom for security will not have,
 nor do they deserve, either one.”
-- Benjamin Franklin --
If you have a favourite quote, send it to me and I may post it in my newsletter.


Today's Microsoft Excel Tip

A Thesaurus in Excel?

In business, nothing else comes close to Excel for analyzing, organizing and presenting numbers.

But numbers alone don't tell the whole story. Even in Excel, we need to use the right words to convey our message effectively.

When you are stuck for just the right word in a report and
need to find one with a similar meaning, what do you do? Do you pull the old thesaurus off the shelf?

Maybe you have discovered that Thesaurus.com is a great website for finding synonyms.

But did you know that you can access a thesaurus from within Excel?

Yes. You can and it's easy.

The way the Thesaurus works in Excel is different depending on if the word is a single word in a cell or in a cell with multiple words.

Single word in a cell

1) Select the cell containing the word you want to replace;

2) Click the Review tab;

3) In the Proofing group on the left end of the Ribbon, c
lick Thesaurus . A Thesaurus pane will appear on the right side of the Excel screen with a list of synonyms for the word in the selected cell;

Alternatively use the Keyboard Shortcut SHIFT+F7 instead of steps 2 & 3 above

4) If you don’t see the exact word you want, click a similar word and a list of its synonyms will be shown. When you find the word you want to use, point to it and a small arrow will appear to the right of the word

5) Click the arrow and choose Insert. The word in the selected cell will be replaced with the synonym you chose;

Thesaurus One Word In Cell in Microsoft Excel 2003, 2007, 2010, 2013, 365


A word in a cell with multiple words

1) Click in the Formula Bar and select the word you want to replace (or double-click the cell and select the word within the cell on the worksheet that you want to replace);

Highlight Word In Cell in Microsoft Excel 2003, 2007, 2010, 2013, 365

2) Click the Review tab;

3) In the Proofing group on the left end of the Ribbon, c
lick Thesaurus . A Thesaurus pane will appear on the right side of the Excel screen with a list of synonyms for the word you selected;

Alternatively use the Keyboard Shortcut SHIFT+F7 instead of steps 2 & 3 above

4) If you don’t see the exact word you want in the list, click a similar word and a list of its synonyms will be shown;

5
) Because you are in 'edit mode', you cannot click or select anything in the Thesaurus pane. However, if you see a word you want to use, at this point you can just begin typing and it will replace the word you have highlighted in the cell. If you don't see the exact word you want to use, press the ESC key to exit 'edit mode', then click a similar word in the list to get a list of synonyms for it
.

6) To use a word, click the arrow to the right of it and choose Copy;

7) Now, highlight the word you want to replace in the Formula Bar (or double-click the cell and select the word within the cell on the worksheet that you want to replace);

8) Right-click and Paste.

Find Word Synonym In Thesaurus in Microsoft Excel 2003, 2007, 2010, 2013, 365



Excel Dashboard Course


Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

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