ACCTG 6400 Shortcut Quiz 2 Flashcards
Show hotkeys
[Alt]
Auto sum - sum all the cells above
[Alt][=]
Open a combo box or filter list
[Alt][down]
Wrap text - when inside a cell this will start a new line in that cell
[Alt][Enter]
Cycle backward through open applications
[Alt][Shift][Tab]
Cycle forward through open applications
[Alt][Tab]
Move to next cell
[Arrow Key]
Enter the current date
[Ctrl][;]
Open format dialog
[Ctrl][1]
Select all
[Ctrl][A]
Move to next section of text.
[Ctrl][Arrow key]
Bold highlighted selection
[Ctrl][B]
Copy
[Ctrl][C]
Move to the end of line of text (or region)
[Ctrl][End]
Enter the same data or formula into all cells selected
[Ctrl][Enter]
Move to beginning of line of text (or last nonblank row/column)
[Ctrl][Home]
Bring up the print dialog box to begin printing
[Ctrl][P]
Switches between worksheet tabs, from left-to-right
[Ctrl][Page Down]
Switches between worksheet tabs, from right-to-left
[Ctrl][Page Up]
Save
[Ctrl][S]
Selecting a range
[Ctrl][Shift][ Arrows]
Enter the current time
[Ctrl][Shift][;]
Select to end of line of text (or region)
[Ctrl][Shift][End]
Select to beginning of line of text (or cell a1)
[Ctrl][Shift][Home]
Select entire column
[Ctrl][Space]
Move between open excel files
[Ctrl][Tab]
Underline highlighted selection
[Ctrl][U]
Paste
[Ctrl][V]
Cut
[Ctrl][X]
Redo last action (can be used multiple times)
[Ctrl][Y]
Undo last action (can be used multiple times)
[Ctrl][Z]
Help
[F1]
Cycle through absolute and relative (in formula)
[F4]
Selecting cells
[Shift][ Arrows]
Open context menu
[Shift][F10]
Select entire row
[Shift][Space]
Group using hot keys
[Alt],[A],[G],[G]
Sort in ascending order using hot keys
[Alt],[A],[S],[A]
Sort in descending order using hot keys
[Alt],[A],[S],[D]
Open sort dialog box using hot keys
[Alt],[A],[S],[S]
Filter a table or range using hot keys
[Alt],[A],[T]
Ungroup using hot keys
[Alt],[A],[U],[U]
Format using hot keys
[Alt],[H],[0]
Increase decimal using hot keys
[Alt],[H],[0]
Decrease indent using hot keys
[Alt],[H],[5]
Indent using hot keys
[Alt],[H],[6]
Decrease decimal using hot keys
[Alt],[H],[9]
Apply all borders using hot keys
[Alt],[H],[B],[A]
Remove the outline border from the selected cells using hot keys
[Alt],[H],[B],[N]
Apply a bottom border using hot keys
[Alt],[H],[B],[O]
Apply a top border using hot keys
[Alt],[H],[B],[P]
Apply outline border to the selected cells using hot keys
[Alt],[H],[B],[S]
Top and double bottom border using hot keys
[Alt],[H],[B],[U]
Delete cells using hot keys
[Alt],[H],[D]
Clear all using hot keys
[Alt],[H],[E],[A]
Insert cells using hot keys
[Alt],[H],[I]
Format accounting using hot keys
[Alt],[H],[K]
Conditional formatting using hot keys
[Alt],[H],[L]
Format percentage using hot keys
[Alt],[H],[P]
Paste values using hot keys
[Alt],[H],[V],[V]
Name a cell using hot keys
[Alt],[M],[M],[D]
Open name dialog box using hot keys
[Alt],[M],[N]
Insert pivot table using hot keys
[Alt],[N],[V]
Freeze and unfreeze panes using hot keys
[Alt],[W],[F],[F]
Select visible cells
[Alt][;]
Insert new worksheet
[Alt][Shift][F1]
Copy the value from the cell above the active cell into the cell or the formula bar
[Ctrl][’]
Alternate between displaying cell values and displaying formulas in the worksheet
[Ctrl][~]
Hide columns
[Ctrl][0]
Hide rows
[Ctrl][9]
Fill down command to copy the contents and format of the topmost cell of a selected range into the cells below.
[Ctrl][D]
Find
[Ctrl][F]
Minimize / maximize currently selected window
[Ctrl][F10]
Print preview
[Ctrl][F2]
Minimize current window
[Ctrl][F9]
Find & replace
[Ctrl][H]
Italic highlighted selection
[Ctrl][I]
New workbook
[Ctrl][N]
Displays the quick analysis options for your data when you have cells that contain that data selected
[Ctrl][Q]
Applies the general number format
[Ctrl][Shift][ ~]
Apply comma format
[Ctrl][Shift][!]
Applies the currency format with two decimal places (negative numbers in parentheses).
[Ctrl][Shift][$]
Applies the percentage format with no decimal places
[Ctrl][Shift][%]
Unhide rows
[Ctrl][Shift][(]
Unhide columns
[Ctrl][Shift][)]
Create a table
[Ctrl][T]
Delete cell content
[Del]
Create chart
[F11]
Save as
[F12]
Edit the selected cell
[F2]
Show names
[F3]
Display the go to dialog box
[F5]
Switch between the ribbon and task pane
[F6]
Spell check selected text and/or document
[F7]
Toggle extend selection
[F8]
Calculate the workbook
[F9]
Insert a new worksheet
[Shift][F11]
Adds or edit a cell comment
[Shift][F2]
Open the excel formula window
[Shift][F3]
Calculate the worksheet
[Shift][F9]