Announcement

Collapse
No announcement yet.

Excel Keyboard Shortcuts

Collapse
This is a sticky topic.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Keyboard Shortcuts

    Excel Keyboard Shortcuts
    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.
Working...
X