Saturday, 31 March 2012

How to make excel document with only one worksheet - Excel Delete unused worksheets

Since you know if you open any Excel worksheet,3 sheets are default,
sometime we may not require the other two worksheets but we end up
in saving the complete workbook.There is an easy solution for this.

Click the 'Office button', click Excel options button and change the
number listed in the 'Include this many sheets' to 1.

In Excel 2003, just go to Tools>Options>General and
change Sheets in new workbooks to 1
This way next time when you open an Excel worksheet,
you can make sure you have only one worksheet!!!!

I prefer this way ,because whenever you want an additional worksheet
right click sheet1 ,in the pop up click 'insert' then 'worksheet',you can add upto 'n' number of sheets