MINDPRIDE Computer Services

 
Home | About Us | Our Services | Contact Information | Tutorials, Articles & Dictionaries | Site Map

HOME 

 

About Us

WhyUS

Services

Virus Alerts

 

Contact

Estimates

Refer A Friend

Site Map

 

Links

Privacy Policy

Disclaimer

MakePayment

 

EXCEL SHORTCUT KEYS

 

 

EXCEL ADVANCED SHORTCUT KEYS

Command Keystroke

Absolute/relative/mixed reference

F4

Alternate between displaying cell

values and displaying cell formulas

CTRL+` (single left quotation mark)

AutoSum

Alt =

Bold

Ctrl-B

Border lines off

Ctrl-Shift _

Border lines on

Ctrl-Shift &

Bring up search box.

Shift + F5

Calculate active sheet

Shift-F9

Calculate all worksheets

F9

Close

Ctrl-W

Collapse selection to active cell

Shift-Backspace

Comment insert/edit

Shift-F2

Copy

Ctrl-C

Copy formula from cell above

Ctrl '

Copy value from cell above

Ctrl-Shift "

Create a chart that uses

the current range

F11 or ALT+F1

Cut

Ctrl-X

Date

Ctrl + ;

Delete range

Ctrl -

Delete to end of line

Ctrl-Del

Display the Format Cells dialog box

CTRL+1

Display the Go To dialog box

F5

Show values/formulas

Ctrl `

Edit cell

F2

Enter formula as array

Ctrl-Shift-Enter

Fill down

Ctrl-D

Fill right

Ctrl-R

Fill the selected cell range with the current entry

CTRL+ENTER

Find

Ctrl-F

Format commas (2 decimal places)

Ctrl-Shift !

Format currency (2 decimal places)

Ctrl-Shift $

Format date (day, month, year)

Ctrl-Shift #

Format exponential number (2 decimal places)

Ctrl-Shift ^

Format general number

Ctrl-Shift ~

Format percentage (0 decimal places)

Ctrl-Shift %

Format time (hour and minute)

Ctrl-Shift @

Formula

=

Function Wizard

Shift-F3

GoTo

Ctrl-G

Group row/column

Alt-Shift-Right

Hard return in cell

Alt-Enter

Hide column(s)

Ctrl-0 (zero)

Hide row(s)

Ctrl-9

Insert chart sheet

F11

Insert Function components

Ctrl-Shift-A

Insert range

Ctrl-Shift-Plus

Insert the current time

CTRL+:

Insert today's date

CTRL+;

Insert worksheet

Shift-F11or Alt + Shift + F1

Italics

Ctrl-I

Menu bar

F10

Maximize currently selected window.

Ctrl + F10

Minimize current window.

Ctrl + F9

Move between noncontiguous selections

Ctrl-Alt-Left/Right

Move left/right one screen

Alt-PgUp/PgDn

Move to beginning of worksheet

Ctrl-Home

Move to edge of region

Ctrl-Arrow

Move to end of row

End, Enter

Move to end of worksheet

Ctrl-End

Move to next corner of selection

Ctrl .

Move up through a selection

Shift-Enter

Name a range (Insert/Name/Create)

Ctrl-Shift-F3

Name a range (Insert/Name/Define)

Ctrl-F3

New

Ctrl-N

Next window

Ctrl-F6

Next worksheet

Ctrl-PgUp

Open

Ctrl-O

Outline symbols display/hide

Ctrl-8

Paste

Ctrl-V

Paste a function into a formula

SHIFT+F3

Paste named ranged (Insert/Name/Paste)

F3

Previous window

Ctrl-Shift-F6

Previous worksheet

Ctrl-PgDn

Print

Ctrl-P

Repeat Find

Shift-F4

Repeat/Redo

Ctrl-Y

Replace

Ctrl-H

Save

Ctrl-S

Save As

F12

Scroll to display active cell

Ctrl-Backspace

Select all (when you are not

entering or editing a formula)

CTRL+A

Select array to which active cell belongs

Ctrl /

Select cells directly referred to by selected formula

Ctrl [

Select cells referred to by selected formula

Ctrl-Shift {

Select cells with comments

Ctrl-Shift ?

Select column

Ctrl-spacebar

Select current region

Ctrl-Shift *

Select formulas that directly refer to active cell

Ctrl ]

Select formulas that refer to active cell

Ctrl-Shift }

Select objects on worksheet

Ctrl-Shift-spacebar

Select row

Shift-spacebar

Select to beginning of row

Shift-Home

Select to beginning of worksheet

Ctrl-Shift-Home

Select to edge of region

Ctrl-Shift-Arrow

Select to end of row

End, Shift-Enter

Select to end of worksheet

Ctrl-Shift-End

Select visible cells in selection

Alt ;

Select worksheet

Ctrl-A

Shortcut menu

Shift-F10

Spelling and Grammar check

F7

Strikethrough on/off

Ctrl-5

Style box

Alt '

Switch between open workbooks / windows.

Ctrl + F6

Tab inserted

Ctrl-Alt-Tab

Time

Ctrl + Shift + ;

Underline

Ctrl-U

Undo

Ctrl-Z

Ungroup row/column

Alt-Shift-Left

Unhide column(s)

Ctrl-Shift )

Unhide row(s)

Ctrl-Shift (

When you enter a formula, display the

Formula Palette after you type a function name

CTRL+A

  Services What We Offer Areas Covered Rates & Discounts
Estimates Maintenance Plans Links Phone Tech Support
About Us Refer A Friend Why Us? Reference Dictionaries Tutorials
Privacy Policy Service Protocol Disclaimer Contact Us

Web Page Designed By  ADAM
Copyright 1981 - 2008
MINDPRIDE CONSULTING All rights reserved.
Revised: November 21, 2007