ACCTG 5150 Short Cut Quiz 2 Flashcards
Calculate
[F9]
Calculate Sheet
[Shift][F9]
Insert Table
[Ctrl][T]
Open the Quick Analysis Tool
[Ctrl][Q]
Enter current date
[Ctrl][;]
Enter the Current Time
[Shift][Ctrl][;]
Delete cell content
[Del]
Enter a Space/ Select item or checkbox
[Space]
Redo / Repeat
[Ctrl][Y]
Undo
[Ctrl][Z]
Copy Formula into Selected Cells
[Ctrl][Enter]
Copy
[Ctrl][C]
Cut
[Ctrl][X]
Paste Values
[Ctrl][Alt][V]
Paste
[Ctrl][V]
Copy Formula from cell above
[Ctrl][’]
Fill Down
[Ctrl][D]
Fill RIght
[Ctrl][R]
Flash Fill
[Ctrl][E]
Replace
[Ctrl][H]
Find
[Ctrl][F]
Enter a new line in the cell
[Alt][Enter]
Repeat Last Action / Absolute and Relative
[F4]
Toggles Edit / Enter Mode
[F2]
Save As
[F12]
Delete the Selected Cells / Rows / Columns
[Ctrl][-]
Close
[Alt][F][S]
Save
[Ctrl][S]
New Workbook
[Ctrl][N]
[Ctrl][P]
Opens the Format Dialogue Box
[Ctrl][1]
Hide Columns
[Ctrl][0]
Show and Hide objects
[Ctrl][6]
Wrap Text
[Shift][Ctrl][W]
Hide Rows
[Ctrl][9]
Bold
[Ctrl][B]
Italics
[Ctrl][I]
Underline
[Ctrl][U]
Increase Decimals
[Ctrl][,]
Apply Comma Format
[Alt],[H],[K]
Paste Name
[F3]
Auto Sum
[Alt][=]
Select All
[Ctrl][A]
Open Name manager
[Alt],[M],[N]
Insert New worksheet
[Shift][F11]
Open the context menu
[Shift],[F10]
Switch between worksheets (right to left)
[Ctrl][Page Up]
Switch between worksheets (Left to right)
[Ctrl][Page Down]
Switch between workbooks
[Ctrl][Tab]
Tab to next cell, tool, tab stop or object
[Tab]
Switch between applications
[Alt][Tab]
Moves between open windows
[Alt][Esc]
Tab to previous cell, tool, tab stop or object
[Shift][Tab]
Open GoTo Dialogue box
[F5]
Move up one cell or item
[up]
Enter and move up
[Shift][Enter]
Jumps one page down
[Pg Dn]
Jumps one page up
[Pg Up]
Move down one cell
[Down]
Move to the previous worksheet in the workbook
[Ctrl][Pg Up]
Move to the next worksheet in the workbook
[Ctrl][Pg Dn]
Move left one cell
[Left]
Moves left to the next blank cell
[Shift][Ctrl][F4]
Move right one cell
[Right]
Moves to the bottom of an active area
[Ctrl][End]
Moves to the bottom of the region or next region
[Ctrl][Down]
Moves one screen to the left in a worksheet
[Alt][Pg Up]
Moves one screen to the right in a worksheet
[Alt][Pg Dn]
Moves right to the next blank cell
[Shift][F4]
Hide Ribbons
[Ctrl][F1]
Moves to the top of the spreadsheet
[Ctrl][Home]
Select Cells to the next page
[Shift][Pg Dn]
Moves to the front of the row
[Home]
Moves to the top of the current region or next region
[Ctrl][up]
Moves to the left of the region or next region
[Ctrl][Left]
Select Cells while moving up
[Shift][up]
Puts Excel in end mode
[End]
Moves to the right of the region or next region
[Ctrl][Right]
Select cells while moving left
[Shift][Left]
Select the menu bar
[F10]
Open a Menu or list
[Alt][Down]
Select Visible cells
[Alt][;]
Extended Selection mode
[F8]
Add to selection
[Shift][F8]
Select Cells to the previous page
[Shift][Pg Up]
Select the active columns
[Shift][Space]
Select Cells while moving down
[Shift][Down]
Select the cells to the beginning of the row
[Shift][Home]
Select cells while moving right
[Shift][Right]
Select in end mode
[Shift][End]
Select the current region
[Shift][Ctrl][8]
Select the current and next sheet in a workbook
[Shift][Ctrl][Pg Dn]
Select the current and previous sheet in a workbook
[Shift][Ctrl][Pg Up]
Select the current Column
[Ctrl][Space]
Select to the bottom of the region or next region
[Shift][Ctrl][Down]
Select to the left of the region or next region
[Shift][Ctrl][Left]
Select to the right of the region or next region
[Shift][Ctrl][Right]
Next Pane or area
[F6]
Minimize / Maximize Window
[Ctrl][F10]
Select to the top of the current region or next region
[Shift][Ctrl][up]
Hide Ribbons, tabs, and status bar
[Shift][Ctrl][F1]
Opens the Selection pane
[Alt][F10]
Expands and collapse the formula bar
[Shift][Ctrl][U]
Previous Pane or area
[Shift][F6]
Help
[F1]
Escape out of edit mode
[Esc]
Enter a formula into a cell or moves to the next cell
[Enter]
Open Thesaurus
[Shift][F7]
Spell Check
[F7]
Minimize workbook
[Ctrl][F9]
Open Context Menu
[Shift][F10]