Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

November 10, 2015

TheExcelAddict.com Quote of the Day
"In learning you will teach
And in teaching you will learn"
-- Phil Colins (Son of Man)

Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)I have seen that some parts of North America have already had some early snow and a few of my subscribers have asked me for some snow pictures.

Fortunately (for me) winter hasn't set in here in my area of Newfoundland yet. Because Newfoundland is an island on the east coast of Canada, the ocean effects tend to give us a more moderate climate than other parts of Canada. Although, when it's -20C in the middle of February and I'm digging my car out of a snow drift, you won't hear me calling the weather moderate then. Typically, we do not get any significant accumulation of snow on the east coast of Newfoundland until after Christmas. So you may have to wait a while for pictures
... I hope.

Since I am not having to spend my time shoveling snow, I will continue to provide you with tips and shortcuts that will help you 'excel in seconds'.

In the spirit of todays quote, "In learning you will teach And in teaching you will learn", I am asking that you share these tips with others you know who may benefit from them.


I hope you're having a great week too.

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

Print Column (A,B,C,etc...) and Row (1,2,3,etc...) Headings and Gridlines

There may be times when you'd like to print the column headings (A,B,C...), row headings (1,2,3...) and gridlines with your reports. For one thing, it's a great trouble-shooting technique when you need to quickly trace a value from a printed report back to your worksheet.

Print Row And Column Headings And Gridlines in Microsoft Excel 2003, 2007, 2010, 2013, 365
To have the column and row headings print on your report follow these steps:

1) Select the Page Layout tab;

2) In the 'Sheet options' group, check the Print option under Headings. If you want to print the gridlines as well, check the Print option under Gridlines. Then click OK.

Page Layout Print Headings in Microsoft Excel 2003, 2007, 2010, 2013, 365

You can also find the options for printing row and column headings and gridlines on the Sheet tab of the Page Setup dialog.

Page Setup Print Gridlines And Row And Column Headings in Microsoft Excel 2003, 2007, 2010, 2013, 365
Note that these settings apply only to the active worksheet, so you will need to repeat this for other worksheets. Also, Gridlines will not print where cells have a Fill/Background color applied.

Gridlines Won't Print For Cells With Fill Color in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365



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.

Earnings 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