Save yourself hours with these tips for Microsoft Excel 2003, 2007, 2010, 2013, 365

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

Hi fellow Excel Addict,


Based on the feedback I received over the past few weeks I will now be publishing my newsletter twice per week with one tip in each rather than once per week with three tips.

After 10 years of publishing my weekly tips newsletter, this is my first week of publishing two separate newsletters.

My plan is to publish on Tuesday and Thursday.

My Tuesday newsletter will be called 'Excel in Seconds' and will feature a quick tip or shortcut that you can read in less than a minute. This is something that a lot of my readers have been requesting as many of you were finding that reading and practicing 3 of my regular tips in one day were too much.

I realize how valuable your time is and I know what it is like to be swamped with so many other things needing your time and attention, so I think you are going to like my 'Excel in Seconds' tips.

On Thursday I will be publishing a longer tip similar to the ones I have been sending all along.

None of this is cast in stone, so I welcome any comments you have or ideas you would like to share.


Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


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



Excel in Seconds with TheExcelAddict.com

Draw Shapes and Text Boxes to Fit Within Cell Borders

When using multiple Shapes, Text Boxes or other objects in a worksheet, you will often want to them to be the same size or line up along one side. In Excel, cell gridlines make a nice guide for doing this but do you know there is an easy way to do this that takes away all the guesswork?

Using this trick, you can easily 'snap to fit' your shape to the cell borders as you are drawing or resizing it.

Here's how...

Eis Alt Drag Size Objects To Cell Borders in Microsoft Excel 2003, 2007, 2010, 2013, 3651) From the Insert tab, click Shapes and choose an object you want to draw;

2) Hold down the ALT key;

3) Point to the top left corner of the cell where you want to begin drawing the object and press the left mouse button;

4) Drag to the bottom-right cell;

5) Release the mouse button;

6) Release the ALT key.

Once you have drawn the object, you can resize it by first selecting the object and then dragging one of its 8 sizing handles as you hold down the ALT key
 


Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and 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' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630