Useful Microsoft Excel 2003 Tips

January 15, 2007

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

Comments


Got something to say?





Your Ad Here
. . . . . . . . . . . . .