100 MS Excel Shortcuts you must know

Hi Guyzz.........!!!!

When it comes to MS Excel, We all know its importance. Here today in this post we will see 100 Keyboard Shortcuts of MS Excel which are very very useful. After knowing these shortcuts we will inch closer to become an MS Excel expert. So without wasting any more time here are the 100 Keyboard Shortcuts of MS Excel:

1.     Ctrl + N: To create a new workbook.
2.     Ctrl + O: To open a saved workbook.
3.     Ctrl + S: To save a workbook.
4.     Ctrl + A: To select all the contents in a workbook.
5.     Ctrl + B: To turn highlighted cells bold.
6.     Ctrl + C: To copy cells that are highlighted.
7.     Ctrl + D: To fill the selected cell with the content of the cell right above.
8.     Ctrl + F: To search for anything in a workbook.
9.     Ctrl + G: To jump to a certain area with a single command.
10.   Ctrl + H: To find and replace cell contents.
11.   Ctrl + I: To italicise cell contents.
12.   Ctrl + K: To insert a hyperlink in a cell.
13.   Ctrl + L: To open the create table dialog box.
14.   Ctrl + P: To print a workbook.
15.   Ctrl + R: To fill the selected cell with the content of the cell on the left.
16.   Ctrl + U: To underline highlighted cells.
17.   Ctrl + V: To paste anything that was copied.
18.   Ctrl + W: To close your current workbook.
19.   Ctrl + Z: To undo the last action.
20.   Ctrl + 1: To format the cell contents.
21.   Ctrl + 5: To put a strike through in a cell.
22.   Ctrl + 8: To show the outline symbols.
23.   Ctrl + 9: To hide a row.
24.   Ctrl + 0: To hide a column.
25.   Ctrl + Shift + :: To enter the current time in a cell.
26.   Ctrl + ;: To enter the current date in a cell.
27.   Ctrl + `: To change the view from displaying cell values to formulas.
28.   Ctrl + ‘: To copy the formula from the cell above.
29.   Ctrl + -: To delete columns or rows.
30.   Ctrl + Shift + =: To insert columns and rows.
31.   Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
32.   Ctrl + Shift + @: To apply time formatting.
33.   Ctrl + Shift + !: To apply comma formatting.
34.   Ctrl + Shift + $: To apply currency formatting.
35.   Ctrl + Shift + #: To apply date formatting.
36.   Ctrl + Shift + %: To apply percentage formatting.
37.   Ctrl + Shift + &: To place borders around the selected cells.
38.   Ctrl + Shift + _: To remove a border.
39.   Ctrl + -: To delete a selected row or column.
40.   Ctrl + Spacebar: To select an entire column.
41.   Ctrl + Shift + Spacebar: To select an entire workbook.
42.   Ctrl + Home: To redirect to cell A1.
43.   Ctrl + Shift + Tab: To switch to the previous workbook.
44.   Ctrl + Shift + F: To open the fonts menu under format cells.
45.   Ctrl + Shift + O: To select the cells containing comments.
46.   Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
47.   Ctrl + Shift + Drag: To drag and insert copy.
48.   Ctrl + Up arrow: To go to the top most cell in a current column.
49.   Ctrl + Down arrow: To jump to the last cell in a current column.
50.   Ctrl + Right arrow: To go to the last cell in a selected row.
51.   Ctrl + Left arrow: To jump back to the first cell in a selected row.
52.   Ctrl + End: To go to the last cell in a workbook.
53.   Alt + Page down: To move the screen towards the right.
54.   Alt + Page Up: To move the screen towards the left.
55.   Ctrl + F2: To open the print preview window.
56.   Ctrl + F1: To expand or collapse the ribbon.
57.   Alt: To open the access keys.
58.   Tab: Move to the next cell.
59.   Alt + F + T: To open the options.
60.   Alt + Down arrow: To activate filters for cells.
61.   F2: To edit a cell.
62.   F3: To paste a cell name if the cells have been named.
63.   Shift + F2: To add or edit a cell comment.
64.   Alt + H + H: To select a fill colour.
65.   Alt + H + B: To add a border.
66.   Ctrl + 9: To hide the selected rows.
67.   Ctrl + 0: To hide the selected columns.
68.   Esc: To cancel an entry.
69.   Enter: To complete the entry in a cell and move to the next one.
70.   Shift + Right arrow: To extend the cell selection to the right.
71.   Shift + Left arrow: To extend the cell selection to the left.
72.   Shift + Space: To select the entire row.
73.   Page up/ down: To move the screen up or down.
74.   Alt + H: To go to the Home tab in Ribbon.
75.   Alt + N: To go to the Insert tab in Ribbon.
76.   Alt + P: To go to the Page Layout tab in Ribbon.
77.   Alt + M: To go to the Formulas tab in Ribbon.
78.   Alt + A: To go to the Data tab in Ribbon.
79.   Alt + R: To go to the Review tab in Ribbon.
80.   Alt + W: To go to the View tab in Ribbon.
81.   Alt + Y: To open the Help tab in Ribbon.
82.   Alt + Q: To quickly jump to search.
83.   Alt + Enter: To start a new line in a current cell.
84.   Shift + F3: To open the Insert function dialog box.
85.   F9: To calculate workbooks.
86.   Shift + F9: To calculate an active workbook.
87.   Ctrl + Alt + F9: To force calculate all workbooks.
88.   Ctrl + F3: To open the name manager.
89.   Ctrl + Shift + F3: To create names from values in rows and columns.
90.   Ctrl + Alt + +: To zoom in inside a workbook.
91.   Ctrl + Alt +: To zoom out inside a workbook.
92.   Alt + 1: To turn on Autosave.
93.   Alt + 2: To save a workbook.
94.   Alt + F + E: To export your workbook.
95.   Alt + F + Z: To share your workbook.
96.   Alt + F + C: To close and save your workbook.
97.   Alt or F11: To turn key tips on or off.
98.   Alt + Y + W: To know what's new in Microsoft Excel.
99.   F1: To open Microsoft Excel help.
100. Ctrl + F4: To close Microsoft Excel.

HAPPY LEARNING........>>>

Read More »

How to disable BitLocker encryption

BitLocker is a good option to lock any of our hard disk drives on our computer, but sometimes it causes inconvienience and we need to disable the BitLocker. though it is easy to disable the BitLocker encryption, but users find it difficult to locate this option.
BitLocker can be disabled using the following Steps-


Step1: Click Start button. (See Fig1)

Fig1

Step2: Cick Control Panel. (See Fig2)

Fig2

Step3: Click System and Security. (See Fig3)

Fig3

Step4: Now click BitLocker Drive Encryption.(See Fig4)

Fig4

Step5: Look for the drive on which you want BitLocker Drive Encryption turned off, and click Turn Off BitLocker. (See Fig5)

Fig5

Step6: A message will be displayed, stating that the drive will be decrypted and that decryption may take some time. Click Turn off Bitlocker / Decrypt the drive. (See Fig6)

Fig6

Take a cup of tea and wait as this might take some time to decrypt the drive and remove BitLocker protection.

Done....!!!
Happy Learning....!!

Read More »

How to Install Microsoft office Picture Manager

Microsoft Office Picture Manager is a raster graphics editor introduced in Microsoft Office 2003 and included up to Office 2010. It is the replacement to Microsoft Photo Editor, which itself was introduced in Office 97 and included up to Office XP. 

Microsoft Office Picture Manager is a must have tool for windows. If this tool is not included in your MS Office package, you can still install it.

To Install Microsoft Office Picture Manager Follow the steps below:-

Step1: Download SharePoint Designer 2007.

Step2: In the Choose the download you want page, select SharePointDesigner.exe and click Next.

Step3: In the message (at the bottom of your screen) that asks if you want to Run or Save the .exe file, click Run.

Step4: Accept the license terms and click Continue.

Step5: On the Choose the installation you want page, click Customize.

Step6: Expand Microsoft Office SharePoint Designer and select Microsoft Office Picture Manager.

Step7: Click the drop-down arrow next to Microsoft Office Picture Manager and click Run from my computer.

Step8: Click Install Now.

All Done......!! You have successfully added MS Office Picture manager to your Computer.

Any Questions? Leave a comment.

Happy Learning.....!!!

Read More »