GupShup, Pakistan Discussion Forum, Urdu Poetry, Send Free SMS to Pakistan, Free Urdu Courses, IT News, Pakistan Politics
 
HomeSend Free SMSCalendarFAQSearchRegisterMemberlistLog inContact Us

Share | 
 

 Microsoft Excel 2003 Shortcut Keys

View previous topic View next topic Go down 
AuthorMessage
Guest
Guest



PostSubject: Microsoft Excel 2003 Shortcut Keys   Mon 06 Jul 2009, 8:59 am

Microsoft Excel 2003 Shortcut Keys

General Shortcuts
New Workbook....................................................... CTRL N
Open Existing Workbook .......................................CTRL O
Save Workbook....................................................... CTRL S
Save Workbook as ........................................................F12
Print Workbook.......................................................CTRL P
Print Preview ........................................................CTRL F2
Spell Check Workbook ......................................................F7
Excel Help menu ...............................................................F1
What’s This Help Tool.........................................SHIFT F1

Moving Around Shortcuts
Move to next cell down & accept data entry............ENTER
Move to previous cell up & accept data entry ...SHIFT ENTER
Move one cell right & accept data entry....................... TAB
Move one cell left & accepts data entry ............SHIFT TAB
Move one cell up, down, left, or right..........................
Move to edge of current data region.........................CTRL
Beginning of row ......................................................HOME
Beginning of worksheet.................................CTRL HOME
Last used cell on worksheet ..............................CTRL END
Down one screen.......................................................PG DN
Up one screen ............................................................PG UP
One screen to right ..........................................ALT PG DN
One screen to left............................................. ALT PG UP
Next sheet in workbook................................. CTRL PG DN
Previous sheet in workbook.......................... CTRL PG UP
Move to next unlocked cell............................................ TAB
Go To ................................................................................F5
Find...................................................................... SHIFT F5
Find Next.............................................................. SHIFT F4

Data Entry Shortcuts
Start a new line in the same cell..................... ALT ENTER
Enter Array Formula...................... CTRL SHIFT ENTER
Display the Formula Palette................................. CTRL A
Insert Function arguments....................... CTRL SHIFT A
Insert a hyperlink....................................................CTRL K
Edit the active cell ............................................................F2
Paste Function......................................................SHIFT F3
Calculate all workbooks....................................................F9
Calculate active workbook.......................... CTRL ALT F9
Calculate active worksheet..................................SHIFT F9
Start a formula ............................................................=
Insert AutoSum formula.........................................ALT =
Enter date .................................................................CTRL;
Enter time ....................................................CTRL SHIFT:
Cancel Data Entry.................................................... ESC
Fill down.......................................................... CTRL D
Fill to the right................................................. CTRL R
Fill range with current entry....................... CTRL ENTER
Copy...................................................................... CTRL C
Copy formatting........................................ CTRL SHIFT C
Copy value from cell above ........................CTRL SHIFT”
Paste Once.............................................................. ENTER
Paste Multiple Times.............................................. CTRL V
Paste formatting only................................ CTRL SHIFT V
Cut.......................................................................... CTRL X
Clear cell Contents................................................DELETE
Delete Selection........................................CTRL HYPHEN
Insert Blank Cells.......................................CTRL SHIFT +
Edit a cell comment ..............................................SHIFT F2
Paste Range Names...........................................................F3
Create Range Names................................CTRL SHIFT F3
Define Range Name...............................................CTRL F3
Delete selection .......................BACKSPACE or DELETE
Delete text to the end of the line ................CTRL DELETE
Redo....................................... ALT SHIFT BACKSPACE
Repeat Last Command ......................................................F4
Insert a new worksheet .......................................SHIFT F11
Create a chart using selected range................................F11
Group sheets................... SHIFT CTRL PG DN or PG UP
Undo....................................................................... CTRL Z

Formatting Shortcuts
Style dialog box ...................................ALT ' (apostrophe)
Format Cells dialog box.........................................CTRL
General number format ............................CTRL SHIFT
Currency Format ......................................CTRL SHIFT
Percentage Format .................................CTRL SHIFT
Date Format..............................................CTRL SHIFT
Time Format ...........................................CTRL SHIFT
Comma Format......................................... CTRL SHIFT
Apply the outline border......................... CTRL SHIFT
Remove outline borders ............................CTRL SHIFT
Bold........................................................................CTRL
Italics...................................................................... CTRL
Underlining............................................................CTRL
Strikethrough ..........................................................CTRL
Hide rows................................................................CTRL
Unhide rows.............................................. CTRL SHIFT
Hide columns ...............................................CTRL 0 (zero)
Unhide columns........................................ CTRL SHIFT
Toggle displaying values or formulas.....................CTRL
Display the AutoComplete list ...................................ALT•

Selecting Ranges
Select current region..................................CTRL SHIFT
Extend selection one cell........................... SHIFT......
Extend selection to last use cell......... CTRL SHIFT END
Select the entire column....................... CTRL SPACEBAR
Select the entire row............................ SHIFT SPACEBAR
Select the entire worksheet......................................CTRL
Select all objects on sheet....... CTRL SHIFT SPACEBAR
Select the current array........................................... CTRL
Select all cells with comments....................CTRL SHIFT
Select un-matching values........................................ CTRL
Select Direct Successors.......................................... CTRL
Select all Successors................................... CTRL SHIFT
Select Direct Predecessors....................................... CTRL
Select all Predecessors............................... CTRL SHIFT
Select visible cells in current selection....................... ALT +TAB
Outline and Slides pane in normal view Create and edit presentations
CTRL+SHIFT+C Copy formats
CTRL+SHIFT+V Paste formats
ALT+SHIFT+1 Show heading level 1
ALT+SHIFT+PLUS SIGN Expand text below a heading
ALT+SHIFT+MINUS SIGN Collapse text below a heading
ALT+SHIFT+A Show all or collapse all text or CTRL+SHIFT+C Copy formats
CTRL+SHIFT+V Paste formats
ALT+SHIFT+1 Show heading level 1
ALT+SHIFT+PLUS SIGN Expand text below a heading
ALT+SHIFT+MINUS SIGN Collapse text below a heading
ALT+SHIFT+A Show all or collapse all text or
Move around in and work on tables
TAB Move to the next cell
SHIFT+TAB Move to the preceding cell
CTRL+Z undo the last action
PowerPoint 2003 Shortcut Keys
Common Tasks Apply character formats Work in an outline
CTRL+S Save a presentation
F5 Run a presentation
ALT+F4 Quit PowerPoint
CTRL+F Find text
CTRL+H Replace text
CTRL+L Left align a paragraph
CTRL+R Right align a paragraph
Delete and copy text and objects
Select text and objects
SHIFT+RIGHT ARROW One character to the right
SHIFT+LEFT ARROW One character to the left
CTRL+SHIFT+RIGHT ARROW To the end of a word
F6 Move clockwise among panes of normal view CTRL+T Change the formatting of characters SHIFT+TAB Promote a paragraph
SHIFT+F6 Move counter clockwise among panes of normal SHIFT+F3 Change the case of letters TAB Demote a paragraph
view CTRL+SPACEBAR Remove manual character formatting ALT+SHIFT+UP ARROW Move selected paragraphs up
CTRL+SHIFT Switch between Slides and Outline tabs of the ALT+SHIFT+DOWN ARROW Move selected paragraphs down
Copy text formats headings
CTRL+N create a new presentation

Align paragraphs
SLASH (/) on the keypad Turn character formatting on or off
CTRL+M insert a new slide
Show or hide a grid or guides SHIFT+F9
CTRL+D make a copy of the selected slide
Show or hide the entire grid ALT+F9
CTRL+O open a presentation
CTRL+E Center a paragraph Show or hide guides CTRL+G
CTRL+W close a presentation
CTRL+J justify a paragraph
CTRL+P
Print a presentation CTRL+K Insert a hyperlink CTRL+BACKSPACE Delete
one word to the left CTRL+SHIFT+LEFT ARROW To the beginning of a word
F7 Check spelling CTRL+DELETE deletes one word to the right SHIFT+UP ARROW One line up
ESC Cancel a menu or dialog box action CTRL+D Duplicate object SHIFT+DOWN ARROW One line down
CTRL+Z Undo an action CTRL+X Cut selected object ESC an object (with text selected inside the
CTRL+Y Redo or repeat an action CTRL+C Copy selected object)
CTRL+V Paste cut or copied object TAB or SHIFT+TAB an object
ENTER Text within an object (with an object selected)
CTRL+A (on the Slides tab) All objects







Move around in text
CTRL+A (in slide sorter view) All slides
CTRL+A (on the Outline tab) All text
DOWN ARROW Move to the next row LEFT ARROW One character to the left
UP ARROW Move to the preceding row RIGHT ARROW One character to the right
CTRL+TAB Insert a tab in a cell UP ARROW One line up
ENTER Start a new paragraph DOWN ARROW One line down
TAB in last row Add a new row at the bottom of the table CTRL+LEFT ARROW One word to the left number +ENTER Go to slide number

Working in Presentation Mode
CTRL+RIGHT ARROW One word to the right B or PERIOD Display a black screen
END To the end of a line W or COMMA Display a white screen
HOME To the beginning of a line ESC End a slide show
CTRL+UP ARROW Up one paragraph CTRL+P Pointer becomes a pen CTRL+SHIFT+F Change the font
Change or resize the font
CTRL+DOWN ARROW Down one paragraph CTRL+A Pointer becomes an arrow
CTRL+SHIFT+P Change the font size
CTRL+END To the end of a text box E Erase on-screen annotations
CTRL+SHIFT+> Increase the font size
CTRL+HOME To the beginning of a text box H Go to the next hidden slide
CTRL+SHIFT+< Decrease the font size
CTRL+ENTER To the next title or body text placeholder or insert new slide.
SHIFT+F4 to repeat the last Find action
Back to top Go down
 
Microsoft Excel 2003 Shortcut Keys
View previous topic View next topic Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
pagesPK.com :: 
Tech Zone
 :: Tips/Tricks
-
Jump to:  

View My Stats
Powered by © phpBB Version 2.0

Copyright © 2011 - 2013 pagespk.com All Rights Reserved

Copying of any contents of pagespk.com is strictly prohibited
Please send an email to administrator "pagespk@live.com" from your official email address if you believe that any content should not be on this site, Thanks.
| Contact Us | Advertise With Us | Privacy Policy | Terms & Conditions | Disclaimer | Send Free SMS to Pakistan - Send Fast SMS to Pakistan | new year sms |

| Canon Lenses Pakistan |