100 Hot keys Flashcards by Deleted Deleted

Show hotkeys

[Alt]

How well did you know this?

Not at all

Perfectly

Auto sum - sum all the cells above

[Alt][=]

How well did you know this?

Not at all

Perfectly

Open a combo box or filter list

[Alt][down]

How well did you know this?

Not at all

Perfectly

New Line - when inside a cell this will start a new line in that cell

[Alt][Enter]

How well did you know this?

Not at all

Perfectly

Cycle backward through open applications

[Alt][Shift][Tab]

How well did you know this?

Not at all

Perfectly

Cycle forward through open applications

[Alt][Tab]

How well did you know this?

Not at all

Perfectly

Move to next cell

[Arrow Key]

How well did you know this?

Not at all

Perfectly

Enter the current date

[Ctrl][;]

How well did you know this?

Not at all

Perfectly

Open format dialog

[Ctrl][1]

How well did you know this?

Not at all

Perfectly

Select all

[Ctrl][A]

How well did you know this?

Not at all

Perfectly

Move to next section of text.

[Ctrl][Arrow key]

How well did you know this?

Not at all

Perfectly

Bold highlighted selection

[Ctrl][B]

How well did you know this?

Not at all

Perfectly

Copy

[Ctrl][C]

How well did you know this?

Not at all

Perfectly

Move to the end of line of text (or region)

[Ctrl][End]

How well did you know this?

Not at all

Perfectly

Enter the same data or formula into all cells selected

[Ctrl][Enter]

How well did you know this?

Not at all

Perfectly

Move to beginning of line of text (or last nonblank row/column)

[Ctrl][Home]

How well did you know this?

Not at all

Perfectly

Bring up the print dialog box to begin printing

[Ctrl][P]

How well did you know this?

Not at all

Perfectly

Switches between worksheet tabs, from left-to-right

[Ctrl][Page Down]

How well did you know this?

Not at all

Perfectly

Switches between worksheet tabs, from right-to-left

[Ctrl][Page Up]

How well did you know this?

Not at all

Perfectly

Save

[Ctrl][S]

How well did you know this?

Not at all

Perfectly

Selecting a region

[Ctrl][Shift][ Arrows]

How well did you know this?

Not at all

Perfectly

Enter the current time

[Ctrl][Shift][;]

How well did you know this?

Not at all

Perfectly

Select to end of line of text (or region)

[Ctrl][Shift][End]

How well did you know this?

Not at all

Perfectly

Select to beginning of line of text (or cell a1)

[Ctrl][Shift][Home]

How well did you know this?

Not at all

Perfectly

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 or Shortcut keys for Mac

[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],[O]

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

[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

[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

[Alt],[H],[K]

Applies the currency format with two decimal places (negative numbers in parentheses).

[Ctrl][Shift][$]

Applies the percentage format with no decimal places

[Alt],[H],[P]

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]

100 Hot keys Flashcards

(100 cards)