Press F12 (Excel opens the Save As dialog box again) to create a copy of this workbook while keeping the original. Simply press CTRL + s to save the changes.ģ. When you enter this shortcut, a new worksheet is inserted into the current workbook. You can also use the Save as Type drop-down box to choose the image. When the Save as Picture window opens, select the location where you want to save the image. Select Save as Picture from the shortcut menu. Saving often can prevent your work from being lost.Ģ. When you want to insert a new worksheet into a workbook, use this keyboard shortcut: Shift+F11. Open your spreadsheet in Excel and right-click the chart you want to save as an image. Note: instead of executing step 1 and step 2, simply use the shortcut F12.Īgain, it’s good practice to periodically save while you are working on your Excel file. Excel Paste Special Shortcuts - Alt ESV Using Right-click Menu: Right Click in. To display the Save As dialog box, execute the following steps. Using Keyboard Shortcut: Use the Excel Paste Special Shortcut Alt + E + S + V. It’s good practice to periodically save while you are working on your Excel file. Press CTRL + s to save an existing workbook. Use the shortcut F12 to display the Save As dialog box in Excel. Our first column contains the Products Name and while scrolling over our dataset we want to view the Products Names.So, to freeze the first column there is a keyboard shortcut Alt + W + F + C (sequentially).Now, let’s go through the procedure of how this shortcut performs. Suppose, we need to lock the first column.

Save as is located in the file tab of the worksheet in excel but there are also some keyboard shortcuts of using it, one being on the quick access tool bar or we can press F12 and display the save as option or we press the keyboard shortcut CTRL + S which opens the save as dialog box for us to save the file in the desired path. Freeze First Column with Keyboard Shortcut.

Excel shortcut to save as