ExcelZone Compendium – worksheets and ranges. By Simon Hurst

Kashflow logo
Share this content

In this edition of the Excel Compendium we are going to look at some of the issues surrounding worksheets and ranges.

Working with worksheets

New workbooks and worksheets

When you create a new Excel workbook the initial number of sheets is defined by the Sheets in new workbook option which can be found in the General tab of the Tools-Options screen. (Excel 2007: Excel Options-Popular, When creating new workbooks, Include this many sheets). You can set this option to a number between 1 and 255, the default is three. This setting is overridden by the number of sheets in a default blank Excel workbook template named book.xlt - if one is present - in the XLSTART folder.

You can also create a default template for an individual sheet. This must be n...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.


Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.