Category: Uncategorized

If you want to delete one or several rows or columns in Excel, you can select the row(s) or column(s) you want to delete, right-click and choose delete, or you can use this shortcut:

Ctrl + Minus (-)

FULL POST

If you want to hide or display Objects in Excel, such as diagrams, pictures and shapes, you can go to Home > Find & Select > Selection pane > Hide All/Show All, or you can use this shortcut:

Ctrl+6

FULL POST

If you want to add or edit a cell comment in Excel, you can go to Review > New Comment/Edit Comment, or you can use this shortcut:

Shift+F2

FULL POST

If you want to open an existing workbook in Excel, you can display the Open dialog box by going to File > Open, or you can use this shortcut:

Ctrl+O

FULL POST

If you want to open the name manager in Excel, you can go to Formulas > Name Manager, or you can use this shortcut:

Ctrl+F3

FULL POST

If you want to create a named range in Excel, you can select the range and type the name you choose in the name box on the top left side of the worksheet, next to the formula bar, or you can use this shortcut:

Ctrl+Shift+F3

If you want to undo your last undo commant, ie. redo what you’ve undone, you can click on the Redo icon in the top left corner, or you can use this shortcut:

Ctrl+Y

FULL POST

If you want to undo your last action or command in Excel, you can click on the Undo icon in the top left corner, or you can use this shortcut:

Ctrl+Z

FULL POST

If you want to save a new copy of your active Excel file, you can go to File > Save as, or you can use this shortcut:

F12

If you want to save your work in Excel, you can go to File > Save, or you can use this shortcut:

Ctrl+S

FULL POST