USER'S CHOICE POST

Internet Download Manager free download for life time activated
Top 10 software you must have in your computer/laptop/tab with free download link

Earn upto Rs. 9,000 pm checking Emails. Join now! And get Rs. 99 Instantly!

ALL THE INFORMATION GIVEN IN THIS SITE IS ONLY FOR THE LEARNING PURPOSE. WE SHOULD ALWAYS USE THE GENUINE SOFTWARE! USE OF ANY INFORMATION GIVEN HERE IS SOLELY USERS' RESPONSIBILITY!


Tuesday, 3 July 2012

Important shortcut keys for ms excel must know

Filled under: ,

Do you know we spend more than 45% of time while writing something for pointing some thing through our mouse. You can speed your writing & working speed by using shortcut keys of keyboard! Remember it once & use it always.
PLEASE LIKE US FIRST & CLICK ON DOWNLOAD BUTTON!



F2 Edit the selected cell
F5 Go to a specific cell
F6 For showing the shortcut option
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 worksheet
Ctrl + B = Bold highlighted selection
Ctrl + I = Italicize highlighted selection
Ctrl + C = Copy selected text
Ctrl + V = Paste
Ctrl + D = Fill
Ctrl + K = Insert link
Ctrl + F = Open find and replace options
Ctrl + G = Open go-to options
Ctrl + H = Open find and replace options
Ctrl + U = Underline highlighted selection
Ctrl + Y = Underline selected text
Ctrl + 5 = Strikethrough highlighted selection
Ctrl + O = Open options
Ctrl + N = Open new document
Ctrl + P = Open print dialog box
Ctrl + S = Save
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 & Page Down = Move between Excel® worksheets in the same document
Ctrl + Tab = Move between two or more open Excel® files
Alt + = = Create formula to sum all of above cells
Ctrl + ‘ = Insert value of above cell into current cell
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 + g = Move to next section of text
Ctrl + Space = Select entire column
Shift + Space = Select entire row
Ctrl + W = Close document


GET THIS CODE :


GIVE YOUR FEED BACK..EITHER GOOD OR BAD ALL ARE HELPING FOR US!

DON'T FORGET TO JOIN THIS BLOG.. SHARE IT WITH YOUR FRIEND!

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...


Try New Whatsapp+ latest for free with lots of new Emoticons :) , Latest Version
Download NOW