Alt+F8: Display the Macro Window
The shortcut Alt+F8 is to display the Macro window to create, run, edit, or delete a macro. Step 1: Click any cell in the worksheet; Step 2: Press and …
Category: Excel Shortcuts
F3: Paste Name Dialog Box
The F3 key is to display the Paste Name dialog box (check define a reference). Step 1: Click anywhere in the worksheet; Step 2: Press the F3 key from …
Alt+M, M, D: Define a Name
Alt+M, M, D is to define a name to use in references. Step 1: Click anywhere in the worksheet; Step 2: Click the Alt key from the keyboard, and …
F11: Creates a Chart
The F11 key is to create a chart in a separate chart sheet. Step 1: Select the data range; Step 2: A chart will be created in the new …
Alt+F1: Create a Chart
The shortcut Alt+F1 is to create an embedded chart with the selected data. Step 1: Select the data you want to make the chart; Step 2: Press and hold …
Ctrl+Shift+": Copy Cell Above
Ctrl+Shift+ "(Straight Quotation Mark) will copy the value from the cell above into the active cell. Step 1: Click any cell in the worksheet; Step 2: Press and hold …