Accounting Junior Core Excel Shortcuts Needed for Exams (BYU)

CTRL+SHIFT+9

Unhides any hidden rows within the selection.

CTRL+9

Hides the selected rows.

CTRL+0

Hides the selected columns.

CTRL+B

Applies or removes bold formatting.

CTRL+A

Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

CTRL+C

Copies the selected cells.

CTRL+D

Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.

CTRL+F

Displays the Find dialog box.

CTRL+I

Applies or removes italic formatting.

CTRL+N

CTRL+N

CTRL+P

Displays the Print dialog box.

CTRL+S

Saves the active file with its current file name, location, and file format.

CTRL+U

Applies or removes underlining.

CTRL+V

Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.

CTRL+W

Closes the selected workbook window.

CTRL+X

Cuts the selected cells.

CTRL+Y

Repeats the last command or action, if possible (i.e. if you hit CTRL+Z and want to undo the undo, you can hit CTRL+Y)

CTRL+Z

Uses the Undo command to reverse the last command or to delete the last entry you typed.

F2

Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.

CTRL+Arrow Key

Moves to the edge of the current data region in a worksheet.

SHIFT+Arrow Key

Extends the selection of cells by one cell.

CTRL+SHIFT+ArrowKey

Extends the selection of cells to the last nonblank cell in the same column or row as the active cell.

CTRL+END

Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.

CTRL+SHIFT+END

Extends the selection of cells to the last used cell on the worksheet (lower-right corner).

ALT+ENTER

Starts a new line in the same cell.

CTRL+ENTER

Fills the selected cell range with the current entry.

HOME

Moves to the beginning of a row in a worksheet.

CTRL+HOME

Moves to the beginning of a worksheet.

CTRL+SHIFT+HOME

Extends the selection of cells to the beginning of the worksheet.

CTRL+PAGE DOWN

Moves to the next sheet in a workbook.

CTRL+PAGE UP

Moves to the previous sheet in a workbook.

SPACEBAR

In a dialog box, performs the action for the selected button, or selects or clears a check box.

CTRL+SPACEBAR

Selects an entire column in a worksheet.

SHIFT+SPACEBAR

Selects an entire row in a worksheet.

TAB

Moves one cell to the right in a worksheet.

SHIFT+TAB

Moves to the previous cell in a worksheet or the previous option in adialog box.

ALT + W, then F

Freeze Panes

CTRL + "-" then hit C or CTRL+SPACE BAR then CTRL + "-"

Delete Column

CTRL + "-" then hit R or Shift+SPACE BAR then CTRL + "-"

Delete Row