Topics

Feb 10, 2011

Move worksheets using drag-and-drop in Excel 2007

At times, you may require to move worksheets from its current location to other place within the same workbook. There is more than one way to do this. The drag-and-drop way is the easiest one. You can move the worksheets by clicking the worksheet from the sheet tab area and dragging it to other place in the sheet tab area. While dragging the worksheet tab, you will see that the mouse cursor changes to an arrow with a small book. While you drag, you will see a small black triangle. The small triangle indicates the place where you can drop the worksheet.
In the image below, Sheet5 is being moved to the end.

0 comments:

Post a Comment