Wednesday, January 9, 2013

TIPS AND TRICK ABOUT MICROSOFT EXCEL

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.
excel wrap 5 Cool Excel 2010 tips and tricks

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