Tuesday, July 5, 2011

Change The Position Of Worksheets

When we are working with Excel sometimes we may need to move the sheets or we may need to refer the sheet 3 first and then sheet 2 or sheet one later at that time we can easily change the positions of the sheet by simple dragging.

To position sheet 3 infront of sheet 1: 

1) Click and hold the sheet three which will give a small black arrow  to the left of heading of the sheet and a sheet icon on the sheet name. 

2) Drag it infront of sheet 1 and release the left mouse click to drop sheet 3.

This works with 2007 and 2010 versions of Microsoft Excel.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More