Thanks Geoff. Your "endorsement" is respected and appreciated.
Here are other keyboard shortcut suggestions for everyone to consider...
<Alt> P ...to bring up the "Page Setup" window.
<Alt> \ ...to "Print Preview".
<Alt> + ...to increase Font size.
<Alt> - ...to decrease Font size.
<Alt> R ...to insert a row or rows.
<Alt> <Tab> R ...to delete a row or rows (the <Tab> is required to go to the second "R" icon).
<Alt> B ...to insert or remove a Page Break.
<Alt> Z ...to Freeze Titles, or un-Freeze Titles.
<Alt> ] ...to bring up the "Format Cells" window. I find this preferable to the build-in shortcut of <Control> 1
The following is one of my favorites, and is a good alternative to Merging cells for headings. Merged cells can sometimes be a "bit of a pain" because of the way it forces the cursor to "jump around". With the following option, the "jumping" does NOT happen.
<Alt> A ...to center-align text across the cells you have selected.
Excel does not have an icon for this, so it requires that you create a "Custom" icon. This is under: Customize - Commands - Macros, and is called "Custom Button".
After dragging the icon to your toolbar, and changing the name to "&Align" (so you can activate with <Alt> A), you will then need to attach the following macro which you need to add to your "PERSONAL.xls" file.
Sub AlignAcrossColumns()
With Selection
.HorizontalAlignment = xlCenterAcrossSelection
.WrapText = False
End With
End Sub
I hope these suggestions will serve as "food for thought", and encourage you to increase your efficiency through use of such shortcuts.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca