Shortcut Quiz #2

¡Supera tus tareas y exámenes ahora con Quizwiz!

Show Hotkeys

Alt

Select visible cells

Alt ;

Auto sum- Sum all the cells above

Alt =

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

Open a combo box or filter list

Alt Down

Wrap Text

Alt Enter

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 using hot keys

Alt H O

Format percentage using hot keys

Alt H P

Past 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

Insert new worksheet

Alt Shift F1

Cycle backward through open applications

Alt Shift Tab

Cycle forward through open applications

Alt Tab

Freeze and unfreeze panes using hot keys

Alt W F F

Move to next cell

Arrow keys

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 Current Date

Ctrl ;

Select All

Ctrl A

Move to next section of text

Ctrl ArrowKey

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

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

Ctrl End

Enter the same data or formula into all cells selected

Ctrl Enter

Find

Ctrl F

Minimize / maximize currently selected window

Ctrl F10

Print Preview

Ctrl F2

Minimize current window

Ctrl F9

Find and replace

Ctrl H

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

Ctrl Home

Italic highlighted selection

Ctrl I

New workbook

Ctrl N

Bring up the print dialog box to begin printing

Ctrl P

Switches between worksheet tabs, left to right

Ctrl PageDown

Switches between worksheet tabs, from right to left

Ctrl PageUp

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

Ctrl Q

Save

Ctrl S

Select entire column

Ctrl SPACE

Apply comma format

Ctrl Shift !

Applies the currency format with 2 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 ;

Selecting a range

Ctrl Shift Arrows

Select to end of line of text (or region)

Ctrl Shift End

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

Ctrl Shift Home

Applies the general number format

Ctrl Shift ~

Create Table

Ctrl T

Move between open excel files

Ctrl Tab

Underline highlighted section

Ctrl U

Past

Ctrl V

Cut

Ctrl X

Redo last action

Ctrl Y

Undo last action

Ctrl Z

Alternate between displaying cell values and displaying formulas in the worksheet

Ctrl ~

Delete Cell content

Del

Help

F1

Create chart

F11

Save as

F12

Edit the selected cell

F2

Show names

F3

Cycle through absolute and relative

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

Selecting cells

Shift ArrowKeys

Open context menu

Shift F10

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

Select entire row

Shift Space


Conjuntos de estudio relacionados

Perfusion EAQ, Cardiovascular EAQ

View Set

Series 66 - Unit 4 (Session 14, 15, 16, 17, 18, 19, 20) Next 200

View Set

Northwestern Mutual - Life and Health Insurance

View Set

The 25th amendment and the 4 key sections

View Set

TTMIK Q&A Book: Chapter 1 Question 1: Sample Sentences

View Set

Homework 4: Formation of the Solar System

View Set

Relativity — Admin Essentials I

View Set