G
Gnarlodious
Hello.
I want to add a few thousand columns to my sheet. How do I do it?
-- Gnarlie
I want to add a few thousand columns to my sheet. How do I do it?
-- Gnarlie
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
Switch to Quattro Pro.
XL has a hard limit of 256 columns.
If you want to use XL, either reorient your sheet to use thousands of
rows, or use multiple worksheets.
XL has a hard limit of 256 columns.
If you want to use XL, either reorient your sheet to use thousands of
rows, or use multiple worksheets.
G
Gnarlodious
Entity JE McGimpsey spoke thus:
-- Gnarlie
That will work, since I only need 36 rows. How to?reorient your sheet to use thousands of rows
-- Gnarlie
B
Bob Phillips
Transpose the data
A1 -> A1
B1 -> A2
etc.
A2 -> B1
A3 -> C1
etc.
A1 -> A1
B1 -> A2
etc.
A2 -> B1
A3 -> C1
etc.
G
Gnarlodious
Entity Bob Phillips spoke thus:
the rows are lettered and columns are numbered. This would give me 2^8 rows
and 2^16 columns.
Is it possible?
-- Gnarlie
That won't work in this case. Ideally, I need to rotate the sheet format soTranspose the data
A1 -> A1
B1 -> A2
etc.
the rows are lettered and columns are numbered. This would give me 2^8 rows
and 2^16 columns.
Is it possible?
-- Gnarlie
J
JE McGimpsey
No - you can use R1C1 notation in which both columns and rows are
numbered, but you can't use letters for rows.
You misunderstood what I meant by "reorient", I think. I meant that you
should redesign your sheet to use rows instead of columns for the range
that requires thousands of items.
I'm not sure why that won't work, but if it won't, you'll need to use a
different application.
numbered, but you can't use letters for rows.
You misunderstood what I meant by "reorient", I think. I meant that you
should redesign your sheet to use rows instead of columns for the range
that requires thousands of items.
I'm not sure why that won't work, but if it won't, you'll need to use a
different application.
B
Bill Sharpe
The poster who suggested Quattro Pro is correct. You can have over
18,000 columns and up to 1,000,000 rows in QP. Why you would want to
escapes me. Printing the spreadsheet out will consume a few trees.
Bill
No - you can use R1C1 notation in which both columns and rows are
numbered, but you can't use letters for rows.
You misunderstood what I meant by "reorient", I think. I meant that you
should redesign your sheet to use rows instead of columns for the range
that requires thousands of items.
I'm not sure why that won't work, but if it won't, you'll need to use a
different application.
18,000 columns and up to 1,000,000 rows in QP. Why you would want to
escapes me. Printing the spreadsheet out will consume a few trees.
Bill
No - you can use R1C1 notation in which both columns and rows are
numbered, but you can't use letters for rows.
You misunderstood what I meant by "reorient", I think. I meant that you
should redesign your sheet to use rows instead of columns for the range
that requires thousands of items.
I'm not sure why that won't work, but if it won't, you'll need to use a
different application.