Friday, January 4, 2019

10 Excel Data Entry Tips Everyone Should Know


There are 10 Excel data entry tips for everyone should know.


Alt + Function



Alt + F1 Creates a chart (on a chart sheet) using the highlighted range


Alt + F2 Displays the (File > Save As) dialog box


Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)


Alt + F8 Displays the (Tools > Macro > Macros) dialog box


Alt + F11 Toggles between the Visual Basic Editor window and the Excel window


Alt + Ctrl + Function


Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbook




Alt + Shift + Function



Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)


Alt + Shift + F2 Displays the (File > Save As) dialog box


Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)


Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag


Alt + Shift + F11 Activates the Microsoft Script Editor window