Microsoft Excel shortcut keys:

By -




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

LAVA 3G 402+

By -
Image
Lava has introduced the 3G 402+, successor to the 3G 402 budget smartphone in India. The Lava 3G 402+ is now up for pre-order at an e-commerce website at Rs. 5,499, with an estimated release in the fourth week of December. The  Lava 3G 402+  is a dual-SIM (GSM+GSM) device, much like its predecessor and runs Android 4.2.2 Jelly Bean out-of-the-box. It sports a 4.0-inch WVGA display with a resolution of 480x800 pixels. The 3G 402+ is powered by a 1.2GHz dual-core processor (unspecified chipset) with 256MB of RAM. It sports a 3-megapixel rear camera with flash, while also houses a 1.3-megapixel front-facing camera. It comes with 4GB inbuilt storage which is further expandable up to 32GB via microSD card. The device also includes a 1500mAh battery that can deliver up to 4 hours of talk time and 200 hours of standby time. Connectivity options include Wi-Fi, Bluetooth, GPS/AGPS, GPRS, EDGE and 3G. The Lava 3G 402  was  launched in August this year  alongside  3G 356 . E
Read more

19 Awesome Tricks Every Iphone and Ipad Use Should Know:

By -
Image
1.  On the iPad: Make typing more comfortable by switching your keyboard to thumb mode. Simply swipe two fingers across the keyboard.  This displays a different keyboard, which allows you to type with your thumbs the same way you type on your iPhone. ***Alternatively,  you can press the “dock and merge” button in the bottom righthand corner of the keyboard and drag up.  The keyboard will turn into thumb mode, and you can also drag it wherever you want. 2.  If you put your phone on airplane mode, it will charge twice as fast. lifehacker.com 3.  Make use of offline Google Maps when traveling abroad. Peggy Wang While you’ve still got internet access, go to the area you want to save.  In the search bar, type “ok maps” and the map will be cached for offline use. This is also super useful for iPads that are only Wi-Fi enabled. 4.  In the Calculator app, remove an accidental extra zero by swiping left to right. quora.com If you’re, say, cal
Read more