i




 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
shortcut keys of MS excel
11-08-2010, 04:05 PM (This post was last modified: 11-08-2010 04:07 PM by nisar87.)
Post: #1
shortcut keys of MS excel
Following are some shortcut keys of MS excel

F2 -Edit the selected cell.
F5 -Go to a specific cell. For example, C6.
F7 -Spell check selected text and/or document.
F11 -Create chart.
Ctrl + Shift + ; -Enter the current time.
Ctrl + ; -Enter the current date.
Alt + Shift + F1 -Insert New Worksheet.
Shift + F3 -Open the Excel formula window.
Shift + F5 -Bring up search box.
Ctrl + A -Select all contents of the worksheet.
Ctrl + B -Bold highlighted selection.
Ctrl + I -Italic highlighted selection.
Ctrl + K -Insert link.
Ctrl + U -Underline highlighted selection.
Ctrl + 5 -Strikethrough highlighted selection.
Ctrl + P -Bring up the print dialog box to begin printing.
Ctrl + Z -Undo last action.
Ctrl + F9 -Minimize current window.
Ctrl + F10 -Maximize currently selected window.
Ctrl + F6 -Switch between open workbooks / windows.
Ctrl + Page up -Move between Excel work sheets in the same Excel document.
Ctrl + Page -down -Move between Excel work sheets in the same Excel document.
Ctrl + Tab -Move between Two or more open Excel files.
Alt + = -Create a formula to sum all of the above cells
Ctrl + ' -Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! -Format number in comma format.
Ctrl + Shift + $ -Format number in currency format.
Ctrl + Shift + # -Format number in date format.
Ctrl + Shift + % -Format number in percentage format.
Ctrl + Shift + ^ -Format number in scientific format.
Ctrl + Shift + @ -Format number in time format.
Ctrl + Arrow key -Move to next section of text.
Ctrl + Space -Select entire column.
Shift + Space -Select entire row.



[Image: 2604595733.png]
Quote
11-08-2010, 04:11 PM
Post: #2
Thumbs Up RE: shortcut keys of MS excel
hi
its great i was thinking to ask thisAngel
very use full information
Quote
11-08-2010, 08:11 PM (This post was last modified: 11-08-2010 08:32 PM by shazia.)
Post: #3
RE: shortcut keys of MS excel
Thanks for posting this here! its really good information
yes i mean at this forum . i like this post , its very helpful
Quote
11-09-2010, 04:05 AM
Post: #4
Thumbs Up RE: shortcut keys of MS excel
Good Post Nisar.... Smile

Please give reputation if my answer/post is useful for you
Best Regards
Arti Gupta
Quote
11-09-2010, 05:19 AM
Post: #5
RE: shortcut keys of MS excel
Nice time saverWink

Oracle Certified Trainer
[Image: signature.php?uid=40]
Quote
07-12-2011, 11:54 AM
Post: #6
RE: shortcut keys of MS excel
Very good analysis
Quote


Possibly Related Threads...
Thread: Author Replies Views: Last Post
  Office 97-2002 shortcut keys nisar87 3 1,347 11-09-2010 05:21 AM
Last Post: Usman



User(s) browsing this thread: 1 Guest(s)