Wednesday, March 25, 2009

Excel: 01 - Increase default no of worksheets in workbooks

I'll start off with this very basic tip - how to increase the default no of worksheets whenever you open a excel workbook. You're asking why this one, I mean it's so simple right, surely everyone knows.
Well because I was in the office one day (no I'm not Sohoing and have go to office 5 days a week) when someone asked 'Why does your excel have 5 sheets, while others have only 3'. My answer was: I work harder than everyone else.. I mean whatever, you could have as many worksheett you wanted, 10, 20, (actually there's a limit but I'm sure it's more than you'll ever need). So then I realized: everything is something new to someone.

Anyway, here it goes:

First you go to Tools --> Options.

Then at the 'General' tab, you see slightly below the halfway mark something which says 'Sheets in new workbook'. Over there change 3 to the no of worksheets you would like to have as default and click 'Ok'. Then close and and re-open excel and we're done.

No comments:

Post a Comment