Image Credit: N Hope See Next: 6 Cool Cell Selection Tips for Microsoft Excel Users You may not be able to remember and master all of them but I am sure you will recollect the ones you feel will help you lower your efforts. So, did you find the list interesting? If you spend most of your day on Excel, I am betting you must have found it helpful. Switch between the visual basic editor and the active workbook.Ĭool Tip: Did you know that you can just press Esc to expand or collapse the formula bar and Delete Conclusion Maximize or restore the selected workbook window.ĭisplay the shortcut menu for the selected item.ĭisplay the menu or message for a smart tag.Ĭreate a chart of the data in the selected range.Ĭreate new worksheet with name like Macro1, Macro2… Select the menu bar and close an open menu and submenu at the same time. Recheck dependent formulas and then calculates all cells in all open workbooks. Performs calculations on formulas.Ĭalculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Perform spell check in the selected range.Īctivate move window cursor provided window is not maximized.Īctivate resize window cursor provided window is not maximized.Įnable Add to Selection mode – select non-adjacent cells when enabled. Switch to the previous workbook window when more than one workbook window is open. Switch to the previous pane in a worksheet that has been split. Switch to the next workbook window when more than one workbook window is open. Switch to the next pane in a worksheet that has been split. Switch between the Help task pane and the application window. Restore the window size of the open workbook. But movement is left and then to the above row. Selection toggles only until the cell that contains data then goes to the next row. Gives option to save or discard current changes. Repeat last action (for example, create a text box) or toggle among cell references. Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys F1 Shortcut KeyĬreate a chart from data in the current range.Ĭreate names by using row and column labels.
0 kommentar(er)
