Useful Microsoft Excel 2003 Tips

Here are some of my tips regarding Microsoft Excel in addition in the Tips I have shared before

Should you want to transfer from a sheet to another sheet you have to use the following formula

[Ctrl]+[Page Down] – To Transfer next Sheet to the right

[Ctrl]+[Page Up] – To Transfer next Sheet to the Left

 

Are you tired of pressing F2 and going to the formula bar or editing from the cell itself I suggest You use the below mention shortcut..

[Ctrl]+[~] – It will show all the formulas hidden in a cell.

Do you wanna know what is a value of a certain cell while you are editing in another sheet or even in the other file as long as it is both open. I think your quest is finished you just have to use the below tools

Tool>>Formula Auditing>>Show Watch Windows = [alt]+[t]+[u]+[w] – It will show a certain cell for reference

For the mean time this will be for today. Just keep on visiting if you want more..

Repost from : www.dexfamily.wordpress.com

Disclaimer: PinoyBlogoSphere.com(PBS) claims no credit for any content(posts, articles, texts, images, videos) featured on this site unless otherwise noted. All contents are copyright to their owners/sources. PBS is in no way responsible for or has control of the content of any external web site links. Information on this site may contain errors or inaccuracies; we do not make warranty as to the correctness or reliability of the site’s content. If you own rights to any of the content, and do not wish them to appear on this site, please contact us via e-mail and they will be removed.
Your Ad Here

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

  . .