FINAN 4020 - Excel Hotkeys/Shortcut Keys

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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

Show hotkeys

[Alt]

Select visible cells

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

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]

Insert new worksheet

[Alt][Shift][F1]

Cycle backward through open applications

[Alt][Shift][Tab]

Cycle forward through open applications

[Alt][Tab]

Move to next cell

[Arrow Key]

Copy the value from the cell above the active cell into the cell or the formula bar

[Ctrl] [']

Enter the current date

[Ctrl] [;]

Select all

[Ctrl] [A]

Copy

[Ctrl] [C]

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]

Alternate between displaying cell values and displaying formulas in the worksheet

[Ctrl] [~]

Hide columns

[Ctrl][0]

Open format dialog

[Ctrl][1]

Hide rows

[Ctrl][9]

Move to next section of text

[Ctrl][Arrow key]

Bold highlighted selection

[Ctrl][B]

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

[Ctrl][D]

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

[Ctrl][End]

Minimize / maximize currently selected window

[Ctrl][F10]

Print Preview

[Ctrl][F2]

Minimize current window

[Ctrl][F9]

Find

[Ctrl][F]

Find and Replace

[Ctrl][H]

Italic highlighted selection

[Ctrl][I]

New workbook

[Ctrl][N]

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]

Displays the quick analysis options for your data when you have cells that contain that data selected

[Ctrl][Q]

Save

[Ctrl][S]

Selecting a range

[Ctrl][Shift][ Arrows]

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][)]

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]

Applies the general number format

[Ctrl][Shift][~]

Select entire column

[Ctrl][Space]

Create a table

[Ctrl][T]

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]

Delete cell content

[Del]

Create chart

[F11]

Help

[F1]

Cycle through absolute and relative (in formula)

[F4]

Selecting cells

[Shift][ Arrows]

Open context menu

[Shift][F10]

Insert new worksheet

[Shift][F11]

Adds or edits a cell comment

[Shift][F2]

Open the excel formula window

[Shift][F3]

Calculate the worksheet

[Shift][F9]

Select entire row

[Shift][Space]


Set pelajaran terkait

Genetics Chapter 11: Gene Expression in Eukaryotes

View Set

ASTR Chap 15 - Star Formation & the Interstellar Medium

View Set

Nursing: Cultural Diversity Prep-U

View Set

Week 1 and Week 2 study guide for NUR201

View Set

respiratory organ with its function

View Set

Chapter 17. The East Asian World

View Set

Area: Shapes with Fractional Side Lengths

View Set