Get Adobe Flash player

Here are some of our favorite keyboard shortcuts. We think you’ll find them pretty handy. The symbol ^ means hold down the Ctrl  key while hitting the other keys.

^ Page Down – moves to the next worksheet in the file

^ Page Up – moves to the previous worksheet in the file

Alt Enter – start a new line in the same cell

 ^ ;  – enter the current date

^Shift ; – enter the current time

^Shift ! – applies the number format with 2 decimals, commas to separate thousands and minus signs to indicate negative numbers

^Shift $ – applies the currency format with 2 decimals

^ 1 – opens the Format Cells dialog box

^ D — fills down from cell above

Give them a try. If you’ve got a favorite keyboard shortcut let us know. E-mail us at tips-tricks@datadesignspublishing.com.

Leave a Reply

Your email address will not be published.