Monday, March 16, 2009

Microsoft Excel keyboard shortcuts

Microsoft Excel keyboard shortcuts

General

Description

Shortcut Key

New file

Ctrl + N

Open file

Ctrl + O

Save file

Ctrl + S

Move between open workbooks

Ctrl + F6

Close file

Ctrl + F4

Save as

F12

Display the print menu

Ctrl + P

Select whole spreadsheet

Ctrl + A

Select column

Ctrl + Space

Select row

Shift + Space

Undo last action

Ctrl + Z

Redo last action

Ctrl + Y

Start a formula

Equals Sign (eg. SUM(A1+A2)

Exit Excel 97

Alt + F4

Navigating

Description

Shortcut Key

Move to next cell in row

Tab

Move to previous cell in row

Shift + Tab

Up one screen

Page Up

Down one screen

Page Down

Move to next worksheet

Ctrl + Page Down

Move to previous worksheet

Ctrl + Page Up

Go to first cell in data region

Ctrl + Home

Go to last cell in data region

Ctrl + End

Formatting Text In Worksheet

Description

Shortcut Key

Bold toggle for selection

Ctrl + B

Italic toggle for selection

Ctrl + I

Underline toggle for selection

Ctrl + U

Strikethrough for selection

Ctrl + 5

Change the font

Ctrl + Shift + F

Change the font size

Ctrl + Shift + P

Apply outline borders

Ctrl + Shift + 7

Remove all borders

Ctrl + Shift + Underline

Wrap text in same cell

Alt + Enter

Formatting Cells

Description

Shortcut Key

Format cells

Ctrl + 1

Select font

Ctrl + Shift + F

Select point size

Ctrl + Shift + P

Format as currency

Ctrl + Shift + 4

Format as general
(to remove any formatting)

Ctrl + Shift + # (hash sign)

Format as percentage

Ctrl + Shift + 5

Format as number

Ctrl + Shift + 1

Editing/Deleting Text

Description

Shortcut Key

Delete one character to right

Delete

Delete one character to left

Backspace

Edit active cell

F2

Cancel cell entry

Escape Key

Highlighting Cells

Description

Shortcut Key

Select entire worksheet

Ctrl + A

Select entire row

Shift + Spacebar

Select entire column

Ctrl + Spacebar

Manual select

Hold Shift + with Left, Right, Up, Down Arrow Key

Copying and Moving Text

Description

Shortcut Key

Cut

Ctrl + X

Copy

Ctrl + C

Paste

Ctrl + V

Inserting Text Automatically

Description

Shortcut Key

Autosum a range of cells

Alt + Equals Sign

Insert the date

Ctrl + ; (semi-colon)

Insert the time

Ctrl + Shift + ; (semi-colon)

Insert columns/rows

Ctrl + Shift + + (plus sign)

Insert a new worksheet

Shift + F11

Misc

Description

Shortcut Key

Find text

Ctrl + F

Replace text dialog

Ctrl + H

Create a chart automatically on new sheet

F11

Edit a cell comment

Shift + F2

Main Jaws Keystrokes In Excel

Description

Shortcut Key

Say Version of Excel

Ctrl + Shift + V

Move to Next Sheet

Ctrl + Page Down

Move to Prior Sheet

Ctrl + Page Up

Go to a cell command

Ctrl + G

Collapse Selection To Active Cell

Shift + Backspace

Say Active Cell Coordinates

Insert + C

AutoSum

Alt + Equals

Formula Mode

Equals Sign

Insert Date In Current Cell

Ctrl + ; (semicolon)

Insert Time In Current Cell

Ctrl + Shift + ; (semicolon)

Current Column First Cell From Top

Alt + 1

Current Column Second Cell From Top

Alt + 2

Current Column Third Cell From Top

Alt + 3

Current Column Fourth Cell From Top

Alt + 4

Data Region Left

Ctrl + Left Arrow

Data Region Right

Ctrl + Right Arrow

Data Region Down

Ctrl + Down Arrow

Data Region Up

Ctrl + Up Arrow

Select Whole Data Region

Ctrl + Shift + 8

Say Formula

Ctrl + F2

Spell Check

F7

Report Gridline Status

Alt + Shift + g

Read Row Total

Insert + Delete

Read Column Total

Insert + Enter

Say Column Title

Alt + Shift + C

Say Row Title

Alt + Shift + R

Say Visible Range Coordinates

Alt + Shift + V

Cycle Through Controls in Dialog Box

Tab

Tab Backwards

Shift + Tab

List Cells With Comments

Ctrl + Shift + ' (apostrophe)

Row Second Cell From Left

Alt + Ctrl + 2

Row First Cell From Left

Alt + Ctrl + 1

Row Third Cell From Left

Alt + Ctrl + 3

Row Fourth Cell From Left

Alt + Ctrl + 4

Describe Cell Border

Alt + Shift + B

Read Cell Comment

Alt + Shift + ' (apostrophe)

Auto Filter

Ctrl + Shift + A

Read Cell Hyperlink

Alt + Shift + H

Close Office Assistant

Ctrl + Insert + F4

Set Monitor Cell One

Alt + Ctrl + Shift + 1

Set Monitor Cell Two

Alt + Ctrl + Shift + 2

Set Monitor Cell Three

Alt + Ctrl + Shift + 3

Set Monitor Cell Four

Alt + Ctrl + Shift + 4

Set Monitor Cell Five

Alt + Ctrl + Shift + 5

Set Monitor Cell Six

Alt + Ctrl + Shift + 6

Set Monitor Cell Seven

Alt + Ctrl + Shift + 7

Set Monitor Cell Eight

Alt + Ctrl + Shift + 8

Set Monitor Cell Nine

Alt + Ctrl + Shift + 9

Set Monitor Cell 10

Alt + Ctrl + Shift + 0

Read Monitor Cell One

Alt + Shift + 1

Read Monitor Cell Two

Alt + Shift + 2

Read Monitor Cell Three

Alt + Shift + 3

Read Monitor Cell Four

Alt + Shift + 4

Read Monitor Cell Five

Alt + Shift + 5

Read Monitor Cell Six

Alt + Shift + 6

Read Monitor Cell Seven

Alt + Shift + 7

Read Monitor Cell Eight

Alt + Shift + 8

Read Monitor Cell Nine

Alt + Shift + 9

Read Monitor Cell Ten

Alt + Shift + 0

List Visible Cells With Data

Ctrl + Shift + D

Lists Data In Current Column

Ctrl + Shift + C

List Data In Current Row

Ctrl + Shift + R

Select Hyperlink

Ctrl + Shift + H

Move To Worksheet Listbox

Ctrl + Shift + S

Move To Monitor Cell

Ctrl + Shift + M

Select Worksheet Objects

Ctrl + Shift + O

List Cells At Page Breaks

Ctrl + Shift + B

Options Listbox

Insert + V

No comments:

Pushpendra Singh Sisodia Blog - Visitors Log

List of Blog Ping Services

http://1470.net/api/ping
http://api.feedster.com/ping
http://api.feedster.com/ping.php
http://api.moreover.com/ping
http://api.moreover.com/RPC2
http://api.my.yahoo.com/RPC2
http://api.my.yahoo.com/rss/ping
http://bblog.com/ping.php
http://bitacoras.net/ping/
http://blog.goo.ne.jp/XMLRPC
http://blogdb.jp/xmlrpc
http://blogmatcher.com/u.php
http://blogoole.com/ping
http://blogroots.com/tb_populi.blog?id=1
http://blogsearch.google.com/ping/RPC2
http://blogsnow.com/ping
http://bulkfeeds.net/rpc
http://coreblog.org/ping/
http://godesigngroup.com
http://godesigngroup.com/blog/feed
http://imblogs.net/ping
http://lasermemory.com/lsrpc
http://mapufacture.com/georss/ping/api
http://mod-pubsub.org/kn_apps/blogchatt
http://ping.amagle.com
http://ping.bitacoras.com
http://ping.blo.gs/
http://ping.blogg.de/
http://ping.bloggers.jp/rpc/
http://ping.blogmura.jp/rpc/
http://ping.cocolog-nifty.com/xmlrpc
http://ping.exblog.jp/xmlrpc
http://ping.fakapster.com/rpc
http://ping.feedburner.com
http://ping.myblog.jp
http://ping.rootblog.com/rpc.php
http://ping.syndic8.com/xmlrpc.php
http://ping.weblogalot.com/rpc.php
http://ping.weblogs.se/
http://ping.wordblog.de
http://pinger.blogflux.com/rpc/
http://pingoat.com/goat/RPC2
http://pingqueue.com/rpc/
http://popdex.com/addsite.php
http://rcs.datashed.net/RPC2/
http://rpc.blogbuzzmachine.com/RPC2
http://rpc.blogrolling.com/pinger/
http://rpc.britblog.com/
http://rpc.icerocket.com:10080/
http://rpc.newsgator.com/
http://rpc.pingomatic.com/
http://rpc.tailrank.com/feedburner/RPC2
http://rpc.technorati.com/rpc/ping
http://rpc.technorati.com/rpc/ping
http://rpc.weblogs.com/RPC2
http://rpc.wpkeys.com/
http://services.newsgator.com/ngws/xmlrpcping.aspx
http://signup.alerts.msn.com/alerts-PREP/submitPingExtended.doz
http://snipsnap.org/RPC2
http://thingamablog.sourceforge.net/ping.php
http://topicexchange.com/RPC2
http://trackback.bakeinu.jp/bakeping.php
http://weblogues.com/RPC
http://www.a2b.cc/setloc/bp.a2b
http://www.bitacoles.net/ping.php
http://www.blogdigger.com/RPC2
http://www.blogoole.com/ping/
http://www.blogoon.net/ping/
http://www.blogpeople.net/servlet/weblogUpdates
http://www.blogroots.com/tb_populi.blog?id=1
http://www.blogshares.com/rpc.php
http://www.blogsnow.com/ping
http://www.blogstreet.com/xrbin/xmlrpc.cgi
http://www.focuslook.com/ping.php
http://www.godesigngroup.com
http://www.holycowdude.com/rpc/ping
http://www.imblogs.net/ping/
http://www.lasermemory.com/lsrpc/
http://www.mod-pubsub.org/kn_apps/blogchatter/ping.php
http://www.newsisfree.com/RPCCloud
http://www.newsisfree.com/xmlrpctest.php
http://www.popdex.com/addsite.php
http://www.rssfwd.com/xmlrpc/api
http://www.snipsnap.org/RPC2
http://www.weblogues.com/RPC/
http://xmlrpc.blogg.de/
http://xping.pubsub.com/
http://xping.pubsub.com/ping/
https://phobos.apple.com/WebObjects/MZFinance.woa/wa/pingPodcast