WALL STREET PREP EXCEL SHORTCUTS CRASH COURSE EXAM QUESTIONS WITH CORRECT ANSWERS
LATEST UPDATE 2026
Add a worksheet - Answers alt i w
Move back and forth between worksheets - Answers ctrl PgUp or ctrl PgDn
Open new workbook - Answers ctrl n
Open a file - Answers ctrl o
Save a file - Answers ctrl s
Print a file - Answers ctrl p
Access excel settings - Answers alt f t
Key settings to change when starting new excel file - Answers -Make "workbook calculation"
automatic except for data tables
-Enable iterative calculations
Autofit width of column - Answers alt h o i
Change column width arbitrarily - Answers alt h o w
Highlight a column - Answers ctrl spacebar
Highlight a row - Answers shift spacebar
Open a cell's dialogue box - Answers ctrl 1
Paste special - Answers Alt e s
Moving between workbooks - Answers ctrl tab
Freezing panes - Answers alt w f f
Splitting panes - Answers alt w s (f6 and shift f6 to jump back and forth between panes)
Redo - Answers ctrl y
Go to beginning of cell while editing - Answers ctrl home
Go to end of cell while editing - Answers ctrl end
Clear cell dialogue - Answers alt h e (+a = clear all, + f = clear formats, + c = clear contents)
Paste right - Answers ctrl r
Paste down - Answers ctrl d
Insert row - Answers alt i r
Insert column - Answers alt i c
delete row - Answers alt h d r
delete column - Answers alt h d c
Transpose (convert data from horizontal to vertical or vice versa) - Answers alt e s e
cut cells - Answers ctrl x
Number format, 2 decimals - Answers ctrl shift !
Currency format, 2 decimals - Answers ctrl shift $
Percentage, no decimals - Answers ctrl shift %
Remove all borders - Answers ctrl shift _
Name a cell - Answers ctrl f3
Anchoring cells - Answers f4
Naming worksheets - Answers alt h o r
Delete a worksheet - Answers alt e l
Create a group of columns/rows - Answers shift alt right arrow
Hide group of columns/rows - Answers alt a h
Unhide a group of columns/rows - Answers alt a j
Ungroup a group of columns/rows - Answers shift alt left arrow
Grouping worksheets - Answers ctrl shift PgUp/PgDn
Highlight precedent cells - Answers ctrl [
Highlight dependent cells - Answers ctrl ]
Trace precedents with arrows - Answers alt m p
Trace dependents with arrows - Answers alt m d
Remove precedent/dependent trace arrows - Answers alt m a a
Open go to special - Answers f5, then alt s
Conditional formatting - Answers alt h l
Create custom new formatting rules - Answers alt o d
Create breaks in excel - Answers Alt enter
Remove gridlines - Answers alt w v g
LATEST UPDATE 2026
Add a worksheet - Answers alt i w
Move back and forth between worksheets - Answers ctrl PgUp or ctrl PgDn
Open new workbook - Answers ctrl n
Open a file - Answers ctrl o
Save a file - Answers ctrl s
Print a file - Answers ctrl p
Access excel settings - Answers alt f t
Key settings to change when starting new excel file - Answers -Make "workbook calculation"
automatic except for data tables
-Enable iterative calculations
Autofit width of column - Answers alt h o i
Change column width arbitrarily - Answers alt h o w
Highlight a column - Answers ctrl spacebar
Highlight a row - Answers shift spacebar
Open a cell's dialogue box - Answers ctrl 1
Paste special - Answers Alt e s
Moving between workbooks - Answers ctrl tab
Freezing panes - Answers alt w f f
Splitting panes - Answers alt w s (f6 and shift f6 to jump back and forth between panes)
Redo - Answers ctrl y
Go to beginning of cell while editing - Answers ctrl home
Go to end of cell while editing - Answers ctrl end
Clear cell dialogue - Answers alt h e (+a = clear all, + f = clear formats, + c = clear contents)
Paste right - Answers ctrl r
Paste down - Answers ctrl d
Insert row - Answers alt i r
Insert column - Answers alt i c
delete row - Answers alt h d r
delete column - Answers alt h d c
Transpose (convert data from horizontal to vertical or vice versa) - Answers alt e s e
cut cells - Answers ctrl x
Number format, 2 decimals - Answers ctrl shift !
Currency format, 2 decimals - Answers ctrl shift $
Percentage, no decimals - Answers ctrl shift %
Remove all borders - Answers ctrl shift _
Name a cell - Answers ctrl f3
Anchoring cells - Answers f4
Naming worksheets - Answers alt h o r
Delete a worksheet - Answers alt e l
Create a group of columns/rows - Answers shift alt right arrow
Hide group of columns/rows - Answers alt a h
Unhide a group of columns/rows - Answers alt a j
Ungroup a group of columns/rows - Answers shift alt left arrow
Grouping worksheets - Answers ctrl shift PgUp/PgDn
Highlight precedent cells - Answers ctrl [
Highlight dependent cells - Answers ctrl ]
Trace precedents with arrows - Answers alt m p
Trace dependents with arrows - Answers alt m d
Remove precedent/dependent trace arrows - Answers alt m a a
Open go to special - Answers f5, then alt s
Conditional formatting - Answers alt h l
Create custom new formatting rules - Answers alt o d
Create breaks in excel - Answers Alt enter
Remove gridlines - Answers alt w v g
