![excel hotkey for save as excel hotkey for save as](https://static.javatpoint.com/ms/excel/images/excel-save-as-shortcut2.png)
![excel hotkey for save as excel hotkey for save as](https://i.ytimg.com/vi/sSd0-t6_NCE/maxresdefault.jpg)
We can write Macros using VBA code in the visual basic editor.ĪLT + ENTER:: Enter a new row in a single cell. Very helpful running macro.ĪLT +F11:: Open Visual Basic editor. If we want to close the only active workbook, we should use CTRL+F4.ĪLT +F8:: Populated the macro window. It will prompt if contains any unsaved data. Very helpful in saving excel files with any other name/ format (same feature as F12).ĪLT+F4:: This will close all the workbooks. SHIFT + TAB:: The data entered is stored to the current cell and selection moves to the next cell Left to it.ĪLT+F2:: Display the “Save As” dialog box. SHIFT + ENTER:: The data entered is stored in the current cell and selection moves to the next cell Above it. Shift +F11:: Inserts a new worksheet into the active workbook.
![excel hotkey for save as excel hotkey for save as](https://excel-hack.com/wp-content/uploads/close-sheet-shortcut6.png)
Shift + F9:: Recalculation of excel formulas only on the active sheet of excel. Provides the same feature as the “CONTROL” key while doing multiple selections. Just click the cells you want to select and all the selection is preserved. Shift + F8:: Once Pressed “Add to selection” is enabled. Shift +F4:: Helps to repeat the last find without opening the find window. “shift+F2” will help to edit the comment easily. It is difficult to edit comments if “show comment” is disabled in an excel sheet. Very helpful in saving excel files with any other name/ format ( same feature as ALT+F2). Especially useful if we are using a UDF in an excel sheet.į12:: Gives the “Save As” dialog box. Provides the same features as “SHIFT” is pressed while selecting using the arrow key.į9:: Recalculate all the formulas in all workbooks. Just by pressing the arrow key, we can select a required area. Enter the cell address ( B23, HH1234.) you want to enter and that particular cell will be highlighted.į7:: Spell-checker – can be used to verify spellings of the text in an excel workbook.į8:: Once pressed “extended selection” is enabled. Microsoft Office : Shortcut Keys for Excel FUNCTION SHORTCUT KEYS FOR EXCELį5:: This will populate the “Go-To” box. Today, in this article I am covering all the Shortcut Keys for Excel 2013. So, to use all the cool features of Microsoft Office 2013 you must know the shortcut keys, and also Shortcut keys are necessary for fast work. The past few months back, after a long time, Microsoft released Microsoft Office 2013, which is totally a new interface for any user with cool features. Microsoft Office comprises many applications like MS Word, MS PowerPoint, MS Access, MS Excel, and many more. Microsoft Office is required by people’s, i.e.
EXCEL HOTKEY FOR SAVE AS SOFTWARE
Microsoft Office is one type of software or we can also say database software because it allows users to store data in different ways and formats. Not a single computer in the world exists without Microsoft Office.