[PDF] Excel 2016 Shortcuts In Windows this can be

View - Download Excel 2016 Shortcuts

Previous PDF

Next PDF

www.wallstreetprep.com

Find shortcuts for previous Excel versions at

at www.wallstreetprep.com/excel-shortcuts

Excel 2016 Shortcuts

Edit

CopyCtrl + CCtrl + C

PasteCtrl + VCtrl + V

UndoCtrl + ZCtrl + Z

RedoCtrl + YCtrl + Y

File

OpenCtrl + OCtrl + O

NewCtrl + NCtrl + N

PrintCtrl + PCtrl + P

SaveCtrl + SCtrl + S

őCtrl + F4Ctrl + W

FormattingOpen Format Cells dialog

Ctrl

Number formatCtrl + + !Ctrl + + !

Percent formatCtrl + + %Ctrl + + %

Date formatCtrl + + #Ctrl + + #

Insert/edit comment + F2 + F2Increase decimal

Alt H 0

Decrease decimal

Alt H 9

Increase indent

Alt H 6 Ctrl + M

Decrease indent

Alt

Clear cell dataDeleteDelete

Clear cell formatsAlt H E F

Clear cell commentsAlt H E M

Clear allAlt H E A

Borders

Outline borderCtrl + + &Ctrl + + &

Remove borderCtrl + + -Ctrl + + -

Opt + ←

Paste Special

Paste special commentsCtrl + Alt + V CCtrl

Ribbon

Show ribbon accelerator keysAlt

Getting around a worksheet

Move from cell to cellArrowsArrows

Move one screen upPgUpFn + ↑

Move one screen downPgDnFn + ↓

Move one screen leftAlt + PgUpFn + Opt + ↑

Move one screen rightAlt + PgDnFn + Opt + ↓

Go to cell A1Ctrl + HomeFn + Ctrl + ←

Go to beginning of rowHomeFn + ←

Go to last cell in worksheetCtrl + End

Fn + Ctrl + →

Open the Go To dialog boxF5F5

Selecting data in a worksheet

Select a cell range + Arrows + Arrows

Extend selection up a screenPgUpFn + + ↑

Extend selection down a screenPgDnFn + + ↓

Data editingFill down from cell above

Ctrl + D Ctrl + D

Fill right from cell left

Ctrl + R Ctrl + R

Find and replace

Ctrl + F Ctrl + F

Show all constants

F5

Alt + S O

Highlight cells with comments

F5

Alt S C

Data editing when inside cell

Edit the active cell (Edit mode)

F2 F2

While editing cell

, allow use of arrow keys to crea te reference F2 F2

őEnterReturn

Cancel cell entry and leave cellEscEsc

Insert line break within cellAlt + EnterOpt + Enter Highlight within a cell + ← or → + ← or → Highlight contiguous itemsCtrl + + ← or →Ctrl + + ← or →

Jump to beginning of cellHome

Jump to end of cellEnd

Delete character to leftBackspaceDelete

Delete character to rightDeleteFn + Delete

Accept AutoComplete suggestionTabTab

Reference a cell from another

worksheetCtrl + PgUp Arrows Ctrl + PgDn Arrows

Ctrl+Fn+↑ Arrows

Ctrl +Fn+↓ Arrows

WindowsMacWindowsMac

www.wallstreetprep.com

Find shortcuts for previous Excel versions at

at www.wallstreetprep.com/excel-shortcuts

Excel 2016 Shortcuts

Calculations

Start a formula= =

Recalculate all worksheetsF9F9

Anchor cells (A$1$),

toggle anchors (edit mode)F4F4

Open Insert Formula dialog + F3 + F3

Enter array formula (edit mode) + Ctrl + Enter + Ctrl + Enter

Auditing formulas

Inspect cell values (edit mode)F9 F9

Switch to formula viewCtrl + ~Ctrl + ~

Select direct precedentsCtrl + [Ctrl + [

Select direct dependentsCtrl + ]Ctrl + ]

Trace immediate precedents Alt M P

Trace immediate depedentsAlt M D

Remove tracing arrowsAlt M A A

Go to last cellF5 + EnterF5 + Enter

Excel Utilities

Calculate all open workbooksF9 F9

Accessing data validationAlt A V V

Get inside a drop-down listAlt ↑ or ↓Opt + ↑ or ↓

Insert data tableAlt A W T

őAlt A T

Insert a pivot tableAlt N V

Insert a chartAlt N R

ZoomAlt W QCtrl + Mouse scroll

Name a cell or cell rangeCtrl + F3Ctrl + L

Rows and Columns

Select columnCtrl + SpaceCtrl + Space

Select row + Space + Space

Delete row(s)/column(s)Ctrl + -Ctrl + -

Add row(s)/column(s)Ctrl + + +Ctrl + + +

Set column widthAlt H O W

őAlt H O I

őAlt H O H

Group rows/columnsAlt + + →Opt + + →

Ungroup rows/columnsAlt + + ←Opt + + ←

Navigating across worksheets and panes

Jump to next worksheetCtrl + PgDnOpt + →

Jump to previous worksheetCtrl + PgUpOpt + ←

Change worksheet nameAlt H O R

Rearrange tab orderAlt H O M

Freeze paneAlt W F F

Split screenAlt W S

Toggle from tab, ribbon, task

pane, status barF6

Close help (and other panes)Ctrl + Space + C

Moving inside Excel forms (format dialog, page setup, etc.)

Move to next controlTab Tab

Move from tab to tabCtrl + TabCtrl + Tab

Move to previous control + Tab + Tab

Move within a listArrowsArrows

Activate control Alt + Underlined Ltr

Toggle checkboxes Spacebar Spacebar

Close a dialogEsc Esc

Apply changeEnter Enter

Optimal Excel settings (PC and Mac)OE

1. Calculation options

Open Excel settings/preferences (Alt T O on Windows, Ctrl + , on Mac). Under "Calculation options," (under the "Formulas" tab in Windows), chose "Automatic except for data tables" and click on "Enable iterative calculation."

2. Disable Autocomplete

Complete for cell values. In Windows, this can be found under Options > Advanced > Editing Options.

3. Disable Error Checking

error checking." (Found under the "Formulas" tab in

Windows.)Enable Ctrl + Arrows by disabling

Mission Control settings

1. Go to System Preferences > Keyboard.

2. Go to "Keyboard shortcuts" tab.

3. Click "Mission Control" in the left window.

4.

Expand the "Mission Control" tab in the Őspace" and "Move right a space"Enable Ctrl+Spacebar for highlighting

columns by disabling Spotlight Search

1. System Preferences > Keyboard.

2. Go to "Keyboard shortcuts"s" tab.

3. Click "Spotlight" in the left window.

4. Disable "Show Spotlight Search."

By default, Mac function keys control system settings and Mission Control. To use function keys for shortcuts, you'll need to hold down the "fn" key before you press F2, F3, etc. You can change this in by checking "Use all F1, F2, etc. keys as standard function keys." You can now use the function keys without pressing "fn."

WindowsMacWindowsMac

quotesdbs_dbs14.pdfusesText_20

[PDF] excel 2016 pour les nuls pdf gratuit

[PDF] excel erp francais methode

[PDF] excel etudiant

[PDF] exchange rate pdf

[PDF] excursii 2015 paralela 45

[PDF] exemplaire d'un contrat de travail

[PDF] exemplaire de demande d'emploi pdf

[PDF] exemplaire de demande d'emploi word

[PDF] exemplaire de lettre de motivation pour une demande d'emploi

[PDF] exemplaire de lettre de motivation pour une demande d'emploi pdf

[PDF] exemple appréciation bulletin scolaire

[PDF] exemple appréciation copie

[PDF] exemple appreciation prof

[PDF] exemple baze de date access

[PDF] exemple bibliographie