Adding columns past the 256 limit

M

melvin

Hi folks,

Is there any way of extending the number of columns past the 256 limi
(MS Excel 97 version)??

many thanks for any input

Best regards
 
A

Andy Wiggins

No. Nor in 2000, XP or 2003.

If you really need more than 256 columns take a look at Quattro Pro.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
F

Frank Kabel

Hi
this is the maximum (also for Excel 2003). If you need more columns you
may:
- split your data on separate worksheets
- use a different spreadsheet application (e.g. Quatro Pro)
- move to a database application
 
A

Arvi Laanemets

Hi

There is one option more:
-redesign the workbook so, that there aren't so many worksheets needed at
all
(p.e. all entries are made into single table, and to get any needed
printouts/views , special report sheets with dropdowns to determine the
selection are used)
 
Top