२८ मे, २०११

Excel_Moving a sheet towards the end (Repeat Post)


A number of sheets can be created inside an excel file. By default, there are three sheets. Any new sheet gets inserted to the left hand side of the current sheet.
Check:
1. Right click on the any or first sheet.
2. Verify that a list appears.
3. Click on first option 'Insert'.
4. Verify that a new sheet is inserted on the left hand side of the current sheet.

Many a times, we feel that a particular sheet should be present at a particular place. There is a facility to move the sheet from it original place to the desired place.
Example:
Pre-requisite: Three sheets namely AB and C.
1. Right click on A sheet.
2. Verify that a list appears.
3. Click on the fourth option 'Move or Copy...'.
4. Verify that a square box called 'Move or Copy' appears. Verify that the second section is called 'Before Sheet'.
5. Select the option 'Move to end'.
6.Verify that A sheet is moved towards the end.

कोणत्याही टिप्पण्‍या नाहीत:

टिप्पणी पोस्ट करा