Learn and use other important keyboard shortcuts.Press ESC while you are editing the text or formula in a cell to exit the cell and cancel any changes that you may have made.Insert a Line Break inside a cell by pressing Alt+ Enter.Press F2 to edit the currently selected cell (will place the cursor at the end of the text/formula).Learn to use the combination of CTRL, ALT, and SHIFT along with the Arrow Keys to navigate and select text.However, because of the changes to the user interface in newer versions of Excel, explanations that say how to get to something via a menu (such as how to get to print and page setup options) may be different for different versions of Excel.įor 140+ detailed tips and tutorials that provide the equivalent of taking an intermediate level Excel training course, see the Spreadsheet Tips Workbook. Most of these tips apply to nearly any version of Excel. I've compiled some of these Excel tips below so that you can soak in a bunch all at once. A few years ago, I started publishing occasional Excel tips via Twitter.
0 kommentar(er)
