Excel has a drop down list that is automatic. Check the image below Things to note: Cell A1 is bold - that tells Excel its a column heading. I have entered two names, Fred and Mary In cell A4 when you use Alt + down arrow Excel automatically displays the list of the entries from above. You can use your arrow keys to select from the list and press Enter. This feature is similar to another feature of typing f…
As well as the normal instructions and notes, there is another way you can use a cell comment. Cell comments can be used to capture cell formulas. (more…)
The only time I edit in the cell is when I run a training session because I can zoom in and make the formula larger on the screen. In practice I only edit in the Formula Bar. When editing in the Formula Bar you can use the Home and End keys to move to either end of the Formula Bar.
Comments are like post it notes for cells. They are a great documentation feature because you can add cell-specific notes to help you and other users understand the spreadsheet better. There are also a few “outside the box” uses for cell comments. (more…)
The keyboard shortcut to remove all formats from the selected range, pressed in sequence, not held down. Alt H E F
When you become more advanced with macros and VBA programming (Visual Basic for Applications), you realise that you can create re-useable macros. (more…)
The keyboard shortcut to change the current sheet name, pressed in sequence, not held down. Alt H O R