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.

0 comments:

Post a Comment

Search This Blog

Followers

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