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.

Excel shortcut keys display formula