Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Realprofoto
 
Posts: n/a
Default 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.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.

  #3   Report Post  
Amedee Van Gasse
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Worksheets Mark Jackson Excel Discussion (Misc queries) 1 June 9th 05 10:39 AM
Spawning worksheets and a summary per worksheet username Excel Discussion (Misc queries) 0 May 23rd 05 09:57 PM
Protect/unprotect all worksheets Janna Excel Worksheet Functions 2 January 7th 05 01:01 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM
Calculate commissions Pete Petersen Excel Worksheet Functions 6 November 17th 04 10:15 PM


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"