November 10, 2015
Hi fellow Excel Addict,
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 -20°C 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)
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.
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.
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.
You can also find the options for printing row and column headings and gridlines on the Sheet tab of the Page Setup dialog.
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.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630