Start a new line
When you need to add a line break to a cell to start a new line of text press Alt + Enter in the cell. If you just want to wrap a long piece of text in a cell right click the cell and choose Format > Alignment tab > Wrap Text.Copy the contents of the cell above
To copy the contents of the cell above into the current cell press Control + ‘.Moving around super fast and super smart
To move from one sheet in a workbook to the next (or in reverse), press Control + PgDn and Control + PgUp. To move to the next open workbook press Control + Tab or Control + Shift + Tab.Super quick mouse free SUM formula
Skip taking the mouse to your Ribbon to add a SUM function and do it with a simple keystroke instead. Type Alt + = and Excel adds the SUM function automatically to the current cell. Doesn’t get much easier than that!http://projectwoman.com/2012/07/5-cool-excel-2010-tips-and-tricks.html
No comments:
Post a Comment