Ctrl + Shift + F3: To create names from values in rows and columns.Д©0. Ctrl + Alt + F9: To force calculate all workbooks.ДЁ9. Shift + F9: To calculate an active workbook.ДЁ7. Shift + F3: To open the Insert function dialog box.ДЁ6. Alt + Enter: To start a new line in a current cell.ДЁ4. Alt + Y: To open the Help tab in Ribbon.ДЁ3. Alt + W: To go to the View tab in Ribbon.ДЁ1. Alt + R: To go to the Review tab in Ribbon.ДЁ0. Alt + A: To go to the Data tab in Ribbon.Д§9. Alt + M: To go to the Formulas tab in Ribbon.Д§8. Alt + P: To go to the Page Layout tab in Ribbon.Д§7. Alt + N: To go to the Insert tab in Ribbon.Д§6. Alt + H: To go to the Home tab in Ribbon.Д§5. Page up/ down: To move the screen up or down.Д§4. Shift + Space: To select the entire row.Д§3. Shift + Left arrow: To extend the cell selection to the left.Д§2. Shift + Right arrow: To extend the cell selection to the right.Д§1. Enter: To complete the entry in a cell and move to the next one.Д§0. Ctrl + 0: To hide the selected columns.Д¦9. Shift + F2: To add or edit a cell comment.Д¦4. F3: To paste a cell name if the cells have been named.Д¦3. Alt + Down arrow: To activate filters for cells.Д¦2. Ctrl + F1: To expand or collapse the ribbon.Д¦0. Ctrl + F2: To open the print preview window.ДҐ6. Alt + Page Up: To move the screen towards the left.ДҐ5. Alt + Page down: To move the screen towards the right.ДҐ4. Ctrl + End: To go to the last cell in a workbook.ДҐ3. Ctrl + Left arrow: To jump back to the first cell in a selected row.ДҐ2. Ctrl + Right arrow: To go to the last cell in a selected row.ДҐ1. Ctrl + Down arrow: To jump to the last cell in a current column.ДҐ0. Ctrl + Up arrow: To go to the top most cell in a current column.Д¤9. Ctrl + Shift + Drag: To drag and insert copy.Д¤8.

Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.Д¤7.

Ctrl + Shift + O: To select the cells containing comments.Д¤6. Ctrl + Shift + F: To open the fonts menu under format cells.Д¤5. Ctrl + Shift + Tab: To switch to the previous workbook.Д¤4. Ctrl + Shift + Spacebar: To select an entire workbook.Д¤3. Ctrl + Spacebar: To select an entire column.Д¤1. Ctrl + -: To delete a selected row or column.Д¤0. Ctrl + Shift + &: To place borders around the selected cells.ДЈ8. Ctrl + Shift + %: To apply percentage formatting.ДЈ7. Ctrl + Shift + #: To apply date formatting.ДЈ6. Ctrl + Shift + $: To apply currency formatting.ДЈ5. Ctrl + Shift + !: To apply comma formatting.ДЈ4. Ctrl + Shift + To apply time formatting.ДЈ3. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.ДЈ2. Ctrl + Shift + =: To insert columns and rows.ДЈ1. Ctrl + вЂ: To copy the formula from the cell above.ДЈ0. Ctrl + `: To change the view from displaying cell values to formulas.Дў8. Ctrl + : To enter the current date in a cell.Дў7. Ctrl + Shift + :: To enter the current time in a cell.Дў6. Ctrl + 8: To show the outline symbols.Дў5. Ctrl + 5: To put a strikethrough in a cell.Дў2. Ctrl + 1: To format the cell contents.Дў1. Ctrl + W: To close your current workbook.Дў0. Ctrl + V: To paste anything that was copied.ДЎ8. Ctrl + U: To underline highlighted cells.ДЎ7. Ctrl + R: To fill the selected cell with the content of the cell on the left.ДЎ6. Ctrl + L: To open the create table dialog box.ДЎ5. Ctrl + K: To insert a hyperlink in a cell.ДЎ3. Ctrl + H: To find and replace cell contents.ДЎ1. Ctrl + G: To jump to a certain area with a single command.ДЎ0. Ctrl + F: To search for anything in a workbook.Д©. Ctrl + D: To fill the selected cell with the content of the cell right above.ДЁ. Ctrl + C: To copy cells that are highlighted.Д§. Ctrl + B: To turn highlighted cells bold.Д¦. Ctrl + A: To select all the contents in a workbook.ДҐ. However, we have picked out some of the most useful shortcuts, and we hope this would be worth your time.Д¤. Before you proceed, note that the list is pretty long but it is by no means a complete list consisting of all the Excel shortcuts.

Microsoft office 2016 shortcut keys pdf