Great works are not performed by strength but by perseverance.
Samuel Johnson (1709-1784)
Monthly Archives: June 2014
Add or Edit Comment
To insert or edit a cell comment in Excel use
Shift + F2
Hold Shift key down and press the F2 function key.
A cell comment is like a sticky note for a cell. It can contain extra information on the cell to help you or the user.
Nothing great was ever achieved without enthusiasm.
Ralph Waldo Emerson (1803-1882)
Dollar Format
To apply the dollar format $9,999,99 in Excel use
Ctrl + Shift + $
Hold Ctrl and Shift down and then press 4 on the keyboard (not the numeric keypad).
Experience is one thing you can’t get for nothing.
Oscar Wilde (1854-1900)
Save As
The shortcut key in Excel for Save As is function key F12.
This works in all MS Office Applications.
I use this all the time.
One knows from daily life that one exists for other people.
Albert Einstein
Wrap Text
The keyboard shortcut combination to add or remove the Wrap Text format, where you can have multiple lines in a cell is
Alt h w
Press keys in sequence, no need to hold them down.
Handling sheet passwords with Excel VBA
Protect and Unprotect quickly
When you are using sheet passwords in Excel it can be handy to have a macro to unprotect all the sheets in one step. This can make maintenance easier.
Protecting Your Excel VBA Macro Code
Applying a password to VBA
The more you use macros the more important they become and the more you want to make sure the VBA* code doesn’t get changed by someone who shouldn’t change it. You may also want to stop people viewing your code.