Advanced Excel Shortcut Keys, Quiz 2

show hot keys

ALT

delete cell content

Del

help

F1

create a chart

F11

Save as

F12

edit the selected cell

F2

show names

F3

absolute value

F4

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

adds or edit a cell comment

Shift, F2

open the excel formula window

Shift, F3

calculate the worksheet

Shift, F9

select visible cells

alt, ;

auto sum - sum all the cells above

alt, =

group using hot keys

alt, A, G, G

sort in ascending order

alt, A, S, A

sort in descending order

alt, A, S, D

open sort dialog box

alt, A, S, S

filter a table or range

alt, A, T

ungroup

alt, A, U, U

increase decimal

alt, H, 0

decrease indent

alt, H, 5

indent

alt, H, 6

decrease decimal

alt, H, 9

apply all borders

alt, H, B, A

remove outline border

alt, H, B, N

apply bottom border

alt, H, B, O

apply top border

alt, H, B, P

apply outline border

alt, H, B, S

top and double bottom border

alt, H, B, U

delete cells

alt, H, D

clear all

alt, H, E, A

insert cells

alt, H, I

format accounting

alt, H, K

conditional formating

alt, H, L

format using hot keys

alt, H, O

format percentage

alt, H, P

paste values

alt, H, V, V

name a cell

alt, M, M, D

open name dialog box

alt, M, N

insert pivot table

alt, N, V

freeze and unfreeze panes

alt, W, F, F

open a combo box or filter list

alt, down

wrap text - will start a new line inside cell

alt, enter

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, '

hide columns

ctrl, 0

open format dialog

ctrl, 1

hide rows

ctrl, 9

enter the current date

ctrl, ;

select all

ctrl, A

bold highlighted section

ctrl, B

copy

ctrl, C

fill down command to copy the contents and format 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

bring up print dialog box to begin printing

ctrl, P

displays the quick analysis option for your data when you have cells that contain that data selected

ctrl, Q

save

ctrl, S

create a table

ctrl, T

paste

ctrl, V

cut

ctrl, X

redo last action

ctrl, Y

undo last action

ctrl, Z

move to next section of text

ctrl, arrow key

move to end of line of text

ctrl, end

enter the same date or formula into all cells selected

ctrl, enter

move to beginning of line of text

ctrl, home

switches between worksheet tabs, left-to-right

ctrl, page down

switches between worksheet tabs, right-to-left

ctrl, page up

apply comma format

ctrl, shift, !

applies the currency format with 2 decimal places

ctrl, shift, $

applies percentage format with no decimal places

ctrl, shift, %

unhide rows

ctrl, shift, (

unhide columns

ctrl, shift, )

enter the current time

ctrl, shift, ;

selecting a range

ctrl, shift, arrows

select to end of line of text

ctrl, shift, end

select to beginning of line of text

ctrl, shift, home

applies the general number format

ctrl, shift, ~

select entire column

ctrl, space

move between open excel files

ctrl, tab

underline

ctrl, u

alternate between displaying cell values and displaying formulas in the worksheet

ctrl, ~

open context menu

shift, F10

insert a new worksheet

shift, F11

selecting cells

shift, arrows

select entire row

shift, space