Hello.
I want to add a few thousand columns to my sheet. How do I do it?
-- Gnarlie
Hello.
I want to add a few thousand columns to my sheet. How do I do it?
-- Gnarlie
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.
In article <BE0DE396.65004%[email protected]>,
Gnarlodious <[email protected]> wrote:
> I want to add a few thousand columns to my sheet. How do I do it?
Entity JE McGimpsey spoke thus:
> reorient your sheet to use thousands of rows
That will work, since I only need 36 rows. How to?
-- Gnarlie
Transpose the data
A1 -> A1
B1 -> A2
etc.
A2 -> B1
A3 -> C1
etc.
--
HTH
Bob Phillips
"Gnarlodious" <[email protected]> wrote in message
news:BE0E03E9.65032%[email protected]...
> Entity JE McGimpsey spoke thus:
>
> > reorient your sheet to use thousands of rows
> That will work, since I only need 36 rows. How to?
>
> -- Gnarlie
>
Entity Bob Phillips spoke thus:
> Transpose the data
>
> A1 -> A1
> B1 -> A2
> etc.
That won't work in this case. Ideally, I need to rotate the sheet format so
the rows are lettered and columns are numbered. This would give me 2^8 rows
and 2^16 columns.
Is it possible?
-- Gnarlie
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.
In article <BE0E7ACF.65079%[email protected]>,
Gnarlodious <[email protected]> wrote:
> Entity Bob Phillips spoke thus:
>
> > Transpose the data
> >
> > A1 -> A1
> > B1 -> A2
> > etc.
> That won't work in this case. Ideally, I need to rotate the sheet format so
> the rows are lettered and columns are numbered. This would give me 2^8 rows
> and 2^16 columns.
>
> Is it possible?
>
> -- Gnarlie
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
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
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.
In article <BE0E7ACF.65079%[email protected]>,
Gnarlodious <[email protected]> wrote:
> Entity Bob Phillips spoke thus:
>
> > Transpose the data
> >
> > A1 -> A1
> > B1 -> A2
> > etc.
> That won't work in this case. Ideally, I need to rotate the sheet
> format so
> the rows are lettered and columns are numbered. This would give me 2^8
> rows
> and 2^16 columns.
>
> Is it possible?
>
> -- Gnarlie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks