ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How many worksheets in Professional version of Office (https://www.excelbanter.com/charts-charting-excel/38562-how-many-worksheets-professional-version-office.html)

Realprofoto

How many worksheets in Professional version of Office
 
I updated to Office Porfesional and wondered if there should bel more than 3
sheets in each workbook. A friend has the same program and they have lots
more pages in their workbook.

Jon Peltier

This is merely the *default* number of sheets in a new workbook. Go to
Tools menu Options General tab, and change the number beside 'Sheets
in New Workbook'.

I have mine set to 1, because more isn't always better. Why lug around
two empty sheets? They don't add to the disk space needed for the file,
but they add to the clutter. And when I need a new sheet, I click Shift+F11.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Realprofoto wrote:
I updated to Office Porfesional and wondered if there should bel more than 3
sheets in each workbook. A friend has the same program and they have lots
more pages in their workbook.


Amedee Van Gasse

In , Jon Peltier told us an
interesting story. My reply to this story is at the bottom of this
message.

This is merely the default number of sheets in a new workbook. Go to
Tools menu Options General tab, and change the number beside
'Sheets in New Workbook'.

I have mine set to 1, because more isn't always better. Why lug
around two empty sheets? They don't add to the disk space needed for
the file, but they add to the clutter. And when I need a new sheet, I
click Shift+F11.


Jon,

You are me. ;-)

--
Amedee Van Gasse


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com