Update multiple cells at once: select two or more cells, type an entry in the first cell, and then press Ctrl-Enter.
Tag: Keyboard shortcut
Dec 05
Copying Cell Contents Down
Double-click fill handle to copy current cell down, stops at the first blank in adjacent column. Or select cells & press Ctrl-D.
Oct 05
Number Formatting Trick
Press Ctrl-Shift-! to apply the Number format, e.g. 1,234.56, to one or more cells that you've selected.
Sep 29
Data Entry Trick
Press Alt-Down Arrow to get an in-cell drop-down list of adjacent entries in the current column
Aug 20
Hiding/Unhiding Columns
Press Ctrl-0 (zero) to hide a column. Use the F5 key to navigate to a hidden column and then press Ctrl-Shift-0 (zero) to unhide.
Jul 30
Workbook/Worksheet Navigation Tricks
Press Ctrl-Tab to switch between open workbooks. Use Ctrl-Page Up/Ctrl-Page Down to switch between worksheets.
Jul 14
Adding/Removing Columns/Rows
Press Ctrl-+ (the plus sign on your keypad) to add rows or columns, use Ctrl-Minus (the – sign on your keypad) to delete.