Skip to main content

MICROSOFT EXCEL SHORTCUT KEYS

Image
By
MICROSOFT EXCEL SHORTCUT KEYS :

1. F2 Edit the selected cell
2. F3 After a name has been created F3 will paste
names
3. F5 Go to a specific cell. For example, C6
4. F7 Spell check selected text or document
5. F11 Create chart from selected data
6. Ctrl + Shift + ; Enter the current time
7. Ctrl + ; Enter the current date
8. Alt + Shift + F1 Insert new worksheet
9. Shift + F3 Open the Excel formula window
10. Shift + F5 Bring up search box
11. Ctrl + A Select all contents of the worksheet
12. Ctrl + B Bold highlighted section
13. Ctrl + I Italic highlighted section
14. Ctrl + K Insert link
15. Ctrl + U Underline highlighted section
16. Ctrl + 1 Change the format of selected cells
17. Ctrl + 5 Strike through highlighted section
18. Ctrl + P Bring up the print dialogue box to begin
printing
19. Ctrl + Z Undo last action
20. Ctrl + F3 Open Excel Name Manager
21. Ctrl + F9 Minimize current window
22. Ctrl + F10 Maximize currently selected window
23. Ctrl + F6 Switch between open work books or
windows
24. Ctrl + Page up Move between Excel work sheets
in the same Excel document
25. Ctrl + page down Move between Excel
worksheets in the same Excel document
26. Ctrl + Tab Move between two or more open
Excel document
27. Alt + = Create a formula to sum all of the above
cells
28. Ctrl + ’ Insert the value of the above cell into cell
currently selected
29. Ctrl + Shift + ! Format number in comma format
30. Ctrl + Shift + $ Format number in currency
format
31. Ctrl + Shift + # Format number in date format
32. Ctrl + Shift + % Format number in percentage
format
33. Ctrl + Shift + ^ Format number in scientific
format
34. Ctrl + Shift + @ Format number in time format
35. Ctrl + Arrow key Move to the next selection on
text
36. Ctrl + Space Select entire column
37. Shift + Space Select entire row
38. Ctrl + - Delete the selected column or row
39. Ctrl + shift + = Insert a new column or row
40. Ctrl + Home Move to cell A1
41. Ctrl + ~ Switch between showing Excel formulas
or their values in
cells..!!

Comments

Post a Comment

Popular posts from this blog

Marvel Studios' Avengers - Official Trailer

By
250 comments
Read more

Microsoft changes 'Outlook Web Access' to 'Outlook on the web'

By
The branding gurus are really earning their wages down Redmond way Outlook for the Web's new weather-enabled calendar app 14 5 Aug 2015 at 02:58,  Simon Sharwood Fresh from showing glimpses of the next-generation Outlook Web Access client in a preview of Exchange Server 2016 , Microsoft has now detailed just how the new version of the browser-bound Outlook will work. There's a new name for starters: “Outlook Web Access” is now “Outlook on the web”. Those marketers sure are earning their wage! Microsoft saying all the usual stuff about the revision making you more productive. The feature touted as making the greatest contribution to that cause is the new “Action toolbar” that “provides quick access to the most common commands, whether you are clearing out your inbox, replying to an email, or adding an event to your calendar.” One of the things you'll see on the toolbar, depicted below, is the “Sweep” command. That's come from Outlook.com and “provides a simple set of act...
400 comments
Read more

Microsoft upgrades its Surface tablets to Windows 10

By
Consumers interested in buying one of Microsoft's Surface tablets will now find it with Windows 10 preinstalled. Microsoft's  online page  for its lower-cost Surface lineup shows that the tablet now comes with Windows 10 Home edition. The page for the pricier and beefier Surface Pro 3  indicates that they're outfitted with Windows 10 Pro edition. Microsoft has been on a tear to push out Windows 10, partly to make up for the poor response to Windows 8 and partly to get as many Windows users as possible all on the same platform. The company has been offering Windows 10 as a free upgrade to Windows 7 and 8.1 users for the first year. Last Thursday, Microsoft announced that the new OS was  running on 14 million devices  since its official launch the previous day. Now the challenge is to get PC and tablet makers to outfit their new devices with Windows 10. Microsoft certainly would want to lead the way, so it's natural for its own Surface tablets to now be sporting W...
106 comments
Read more