Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patti
 
Posts: n/a
Default Can the default size of an excel 2000 worksheet be changed?

I'm working on a pretty big worksheet and actually need more columns. Right
now it stops at IV. Any help would be greatly appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Trevor Shuttleworth
 
Posts: n/a
Default Can the default size of an excel 2000 worksheet be changed?

Sorry, that's the way it is, 256 columns and 65536 rows.

It's not just the default, it's the maximum ... and, I guess, the minimum.
Every worksheet always has those dimensions, you can't make it bigger, you
can't make it smaller, though you can hide rows and columns.

Have you thought about restructuring your data or using a database ?

Regards

Trevor


"Patti" wrote in message
...
I'm working on a pretty big worksheet and actually need more columns.
Right
now it stops at IV. Any help would be greatly appreciated.



  #3   Report Post  
Posted to microsoft.public.excel.misc
Wes at CCC
 
Posts: n/a
Default Can the default size of an excel 2000 worksheet be changed?

Have you thought about using multiple sheets instead of a single sheet? Also,
you can link Excel workbooks; i.e. multiple files linked together.

Another thought is to orient your worksheet vertically - over 65,000 rows!

I understand that the new Excel (with Vista) will have a huge number of
columns and rows. But for now we have what we have.
"Patti" wrote:

I'm working on a pretty big worksheet and actually need more columns. Right
now it stops at IV. Any help would be greatly appreciated.

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
Change the default size of comments in Excel? Gloria Lopez Excel Discussion (Misc queries) 1 December 6th 05 10:50 PM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
How to change default page size in Excel proshail Excel Worksheet Functions 2 July 4th 05 08:38 PM
Is there a way to make Excel 2000 open a new worksheet in a new w. gdub Excel Discussion (Misc queries) 1 December 22nd 04 03:56 PM
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! Marie J-son Charts and Charting in Excel 2 December 6th 04 04:11 AM


All times are GMT +1. The time now is 07:08 AM.

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

About Us

"It's about Microsoft Excel"