It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window It Selects the current region (associated by blank rows and columns) It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. Ctrl + F4: To close Microsoft Excel.It is also used to switch between absolute/relative refs
Alt + Y + W: To know what's new in Microsoft Excel.ġ00. Alt or F11: To turn key tips on or off.ĩ8. Alt + F + C: To close and save your workbook.ĩ7. Ctrl + Alt +: To zoom out inside a workbook.ĩ4. Ctrl + Alt + +: To zoom in inside a workbook.ĩ1. 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.
0 kommentar(er)
