Tuesday, August 31, 2010

Some office "how to?" tips

Tips for Microsoft Excel (Any Versions)
Select/Go to all cells with formulas
I am mentioning here only short cut keys keep in mind all versions of Microsoft Excel.
Cntrl+G, Alt+S, Alt+F
To check any cells missing formulas, to format cells containing formulas etc.
Select/Go to all cells with Comments
Use short cut key Cntrl+G, Alt+S, Alt+C
You can use this to delete multiple comments at once
Create/Remove Page Breaks
Manual page breaks are must to look your print out neat
Select Entire Row/Column
Shift+Space Bar - Row
Cntrl+Space Bar - Column
Delete/Insert Selected Row/Column (as above) Immediately
Cntrl+ - to delete
Cntrl+ + to insert
Insert °, © Symbols
Alt+248 for °
Alt+0169 for ©
Use Windows Character Map to insert more symbols and find symbol code
Get Free Updates:
We will send a confirmation mail. Please check your inbox/spam folder to confirm it
Related Posts Plugin for WordPress, Blogger...

Copyright © 2011 All Rights Reserved | Designed by Amith | Post RSS | Home | About | Disclaimer | Privacy Policy | Contact