Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change the default size of comments in Excel? | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
How to change default page size in Excel | Excel Worksheet Functions | |||
Is there a way to make Excel 2000 open a new worksheet in a new w. | Excel Discussion (Misc queries) | |||
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! | Charts and Charting in Excel |