| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
More than 250 Columns
I have a spread sheet with more than 2000 columns, is there any way to
view them all or to split the file into subfiles to view them on seperate worksheets? Thanks - ash# |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 250 Columns
Download the beta 2 version of Excel 2007 ?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email wrote in message oups.com... I have a spread sheet with more than 2000 columns, is there any way to view them all or to split the file into subfiles to view them on seperate worksheets? Thanks - ash# |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 250 Columns
I don't think Excel supports more than 256 columns so not sure how you have
2000 - are you sure you don't mean rows? " wrote: I have a spread sheet with more than 2000 columns, is there any way to view them all or to split the file into subfiles to view them on seperate worksheets? Thanks - ash# |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 250 Columns
"Sheila D" wrote in message
... " wrote: I have a spread sheet with more than 2000 columns, is there any way to view them all or to split the file into subfiles to view them on seperate worksheets? I don't think Excel supports more than 256 columns so not sure how you have 2000 - are you sure you don't mean rows? If the OP is using the Excel 2007 beta, that increases the limits from 256 columns to 16,385 columns and from 65,536 rows to 1,048,576 rows. -- David Biddulph |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
More than 250 Columns
OK David - I'll remember that - thanks
Sheila "David Biddulph" wrote: "Sheila D" wrote in message ... " wrote: I have a spread sheet with more than 2000 columns, is there any way to view them all or to split the file into subfiles to view them on seperate worksheets? I don't think Excel supports more than 256 columns so not sure how you have 2000 - are you sure you don't mean rows? If the OP is using the Excel 2007 beta, that increases the limits from 256 columns to 16,385 columns and from 65,536 rows to 1,048,576 rows. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linear Mode
