Wednesday, 26 March 2014
Monday, 17 March 2014
Viewing the previous entries of the same column
Viewing
the previous entries of the same column
If
you find yourself making repetitive entries into an Excel spreadsheet, press Alt-Down
to view a drop-down list of previous entries in the current column. Arrow down
the list and press Enter to make a selection.
Keep
in mind that this technique works with text only, not numbers, and your cursor
must be in or adjacent to a contiguous block of non-blank cells.
Subscribe to:
Comments (Atom)