Monday Microsoft Tip

by Erin Banister

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Here’s your Weekly [tag]Monday Microsoft Tip[/tag]

[tag]Microsoft Excel[/tag] [tag]Keyboard Shortcuts[/tag]

F2: Edit a cell’s contents.

Ctrl-1: Open the Format Cells dialog.
Ctrl-Page Up: Move to the next sheet in the workbook.
Ctrl-Page Down: Move to the previous sheet in the workbook.

Ctrl-Shift-”: Copy the value from the cell above into the current cell.
Ctrl-’: Copy the formula from the cell above into the current cell.
Ctrl-R: Fill contents of active cell into selected cells to the right.
Ctrl-D: Fill contents of active cell into selected cells down.
Ctrl-`: Toggle between showing cell values and formulas in cells.
Ctrl-$: Set selection to currency format with two decimal places.

Until next time…

~E

No tags for this post.