MICROSOFT EXCEL SHORTCUT KEYS

-
Alt + Shift + F1 = Insert New Worksheet
Shift + F3 = Open the Excel formula window
Shift + F5 = Bring up search box
F2 = Edit the selected cell
F5 = Goto 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
Ctrl + F6 = Switch between open workbooks / windows
Ctrl + F9 = Minimize current window
Ctrl + F10 = Maximize currently selected window
Ctrl + P = Bring up the print dialog box to begin printing
Ctrl + Z = Undo last action
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 + 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
Alt + = = Create a formula to sum all of the above cells
Shift + Space = Select entire row
Ctrl + ' = Insert the value of the above cell into cell currently selected
Ctrl + Arrow key = Move to next section of text
Ctrl + Shift + @ = Format number in time format
Ctrl + Space = Select entire column
Ctrl + Shift + $ = Format number in currency format
Ctrl + Shift + ^ = Format number in scientific format
Ctrl + Shift + # = Format number in date format
Ctrl + Shift + % = Format number in percentage format
Ctrl + Shift + ! = Format number in comma format
Ctrl + Tab = Move between Two or more open Excel files

Comments

Post a Comment

Popular posts from this blog

Cheat Codes of Holiday Island Game

-
Image
CASH: While in game play press Ctrl + Shift + Alt + G and you should get lots of cash this cheat works on my machine. Cheat mode: Enter one of the following passwords at the cheats menu to activate the cheat function. Result Codes: Faster gameplay - EXTREMEDAY Faster enemies - EXTREMEENEMY Unlimited money - EXTREMEMONEY Build anywhere - FREETOWN All buildings fully occupied - GREENLINE Buildings constructed in one day - NOWAIT
Read more

Tips to Increase Your Internet Connection Speed

-
Image
Now everybody use internet to connect to your to your friend, download music, videos or software, or just looking for latest information. But, what do you feel if your internet connection is slow to load web page? . I know It's not fun. Now,I want to share some tips to resolve this problem. There many things should we do to increase internet connection speed . First, check your area to make sure there are some internet connection choice that you can use such as Fiber Optic. Perform maintenance on your PC will increase PC performance. Try using latest antivirus software to protect your PC from viruses or malwares infection. Viruses or similars will decrease PC performance. Using RegCleaner to make sure your operating system performance always healthy and no errors. For hardware side, try to reset your home network device. Turn off and then turn on again the router/modem. Sometime this way will repair or increase your internet connection speed significantly . For software ...
Read more