Entering & Editing

 

Entering Comments

Shortcut

Description

SHIFT+F2

Add new comment, edit cell comment

CTRL+SHIFT+O

Select all cells with comments

 

Entering Hyperlinks

Shortcut

Description

CTRL+K

Add a hyperlink

 

Entering Current Date / Time

Shortcut

Description

CTRL+;

Enter current date

CTRL+SHIFT+:

Enter current time

 

Entering Accept Entry

Shortcut

Description

ENTER

Accept entry and move active cell down one row

 CTRL+ENTER

Accept entry and keep active cell in place

SHIFT+ENTER

Accept entry and move active cell up one row

TAB

Accept entry and move active cell one column to the right

SHIFT+TAB

Accept entry and move active cell one column to the left

 

Entering Entry   

Shortcut

Description

Selection, CTRL+ENTER

Select cells, enter data, hit CTRL+ENTER to have data entered in every cell selected

ALT+ENTER

Create line break inside cell

ESC

Cancel cell entry

 

 

Editing

Shortcut

Description

F2

Begin editing active cell, insertion point is at end of cell contents, then use following commands while in edit mode:

 

HOME = move insertion point to beginning of cell

END = move insertion point to end of cell

CTRL+ARROW RIGHT = move insertion point one word to the right

CTRL+ARROW LEFT = move insertion point one word to the left

BACKSPACE = delete character to left of insertion point

DEL = delete character to right of insertion point

CTRL+DEL = delete all characters from insertion point to end of cell contents

'

As 1st character in cell, format entry as text

F7

Begin spell check

CTRL+D

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

CTRL+E

Adds more values to the active column by using data surrounding that column

 

Formulas and Functions

Shortcut

Description

=

Start a formula

CTRL+SHIFT+ENTER

Enter a formula as an array formula

SHIFT+F3

Open Insert Function dialog box

 CTRL+A

Open Function argument dialog box when insertion point is to right of function and (

CTRL+SHIFT+A

Insert parentheses() and function argument names - when insertion point is to right of function name

F2

Edit formula in cell, insertion point is at end of cell contents

ALT+=

Insert auto-sum formula

CTRL+'

Copies a formula from the cell above the active cell into the cell or the Formula Bar

CTRL+`

Display the formula

CTRL+SHIFT+U

Expand or collapse formula bar

ALT+ARROW DOWN

Display Auto-Complete list

CTRL+8

Toggle outline symbols

 

Formula Auditing

Shortcut

Description

Highlight portion of formula + F9

Evaluates selected portion of formula, press ESC to editing

CTRL+`

Toggle between showing formula and formula result

CTRL+[

Select direct precedent cells

SHIFT+CTRL+[

Select all precedent cells

CTRL+]

Select direct dependent cells

SHIFT+CTRL+]

Select all dependent cells

SHIFT+CTRL+{

Select all cells directly or indirectly referenced by formulas in selection

SHIFT+CTRL+}

Select cells with formulas that directly or indirectly reference active cell

 

Named Ranges

Shortcut

Description

CTRL+SHIFT+F3

Open Create Names from Selection dialog box - select cells and labels first!

F3

Displays the Paste Name dialog box. Available only if names have been defined in the workbook (Formula Tab, Defined Names group, define Name)

CTRL+F3, ALT+M N

Define name, open Name Manager dialog box

 

Entering Data Validation

Shortcut

Description

ALT+A VV

Open Data Validation dialog box

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017