how to extend the column limit on a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
NO way, unless you switch to Excel 2007. It has a limit of thousands of
columns.

Perhaps you would be better served if you translated your columns into rows,
and rows into columns
 
I have the same problem with excel 2010. I need a thousand columns but I can only go till column IV. I know there is a way to extend columns. Can someone help me find it please?
 
Original subject: RE: how to extend the column limit on a worksheet
Changed subject: Re: NO way, unless you switch to Excel 2007
I have the same problem with excel 2010. [....]
Can someone help me find it please?
Click to expand...

What problem is that?

Rhetorical question. The point is: it is rude to change the subject
of a thread, especially to something as nondescript as yours ("no
way ...").

You don't deserve an answer because no one will see the subject of
your question.
 
Original subject: RE: how to extend the column limit on a worksheet
Changed subject: Re: NO way, unless you switch to Excel 2007 [....]
 it is rude to change the subject of a thread, especially to something
as nondescript as yours ("no way ...").
You don't deserve an answer because no one will see the subject of
your question.
Click to expand...

Sorry for the overreaction. I will delete the article in Google
Groups; but that will not delete it on mirrored sites.

Arguably, the fault lies with the Egghead Cafe software. Perhaps it
selects the first line/sentence of the article being responded to and
puts it into the subject line by default. And perhaps Egghead Cafe
software does not make the new subject line easily visible to the user
(responder). I thought I had recently that all that had been fixed.
But perhaps not.
 
For Roderick

Save the workbook as a 2007 or 2010 workbook and you will get the 16.384
columns.


Gord Dibben MS Excel MVP

Original subject: RE: how to extend the column limit on a worksheet
Changed subject: Re: NO way, unless you switch to Excel 2007 [....]
 it is rude to change the subject of a thread, especially to something
as nondescript as yours ("no way ...").
You don't deserve an answer because no one will see the subject of
your question.
Click to expand...

Sorry for the overreaction. I will delete the article in Google
Groups; but that will not delete it on mirrored sites.

Arguably, the fault lies with the Egghead Cafe software. Perhaps it
selects the first line/sentence of the article being responded to and
puts it into the subject line by default. And perhaps Egghead Cafe
software does not make the new subject line easily visible to the user
(responder). I thought I had recently that all that had been fixed.
But perhaps not.
Click to expand...
 
Back
Top