ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   extending columns (https://www.excelbanter.com/new-users-excel/123687-extending-columns.html)

Bob

extending columns
 
I have more than 255 columns of info is it possible to extend the
spreadsheet? I need to be able to sort so that sometimes they are in date
order, sometimes in surname order so continuing on the next set down is not
an answer. I have 37 rows of more than 255 columns of info so turning through
90 degrees is not an answer either because this would not allow me to print
on one page - even in landscape, please help.
--
Thanks Bob

JoAnn Paules [MVP]

extending columns
 
If you use Excel 2007 you can go up to 16000. But if you do, I'm not sure if
someone with an older version of Excel would be able to see anything over
256.
--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Bob" wrote in message
...
I have more than 255 columns of info is it possible to extend the
spreadsheet? I need to be able to sort so that sometimes they are in date
order, sometimes in surname order so continuing on the next set down is
not
an answer. I have 37 rows of more than 255 columns of info so turning
through
90 degrees is not an answer either because this would not allow me to
print
on one page - even in landscape, please help.
--
Thanks Bob




Bob

extending columns
 
Thanks for that I'm not really bothered if anyone else can read it so that
solves my problem. Can I get a copy from the net?

--
Thanks Bob


"JoAnn Paules [MVP]" wrote:

If you use Excel 2007 you can go up to 16000. But if you do, I'm not sure if
someone with an older version of Excel would be able to see anything over
256.
--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Bob" wrote in message
...
I have more than 255 columns of info is it possible to extend the
spreadsheet? I need to be able to sort so that sometimes they are in date
order, sometimes in surname order so continuing on the next set down is
not
an answer. I have 37 rows of more than 255 columns of info so turning
through
90 degrees is not an answer either because this would not allow me to
print
on one page - even in landscape, please help.
--
Thanks Bob





Gord Dibben

extending columns
 
Bob

No downloads for 2007

See here for how to buy.

http://office.microsoft.com/en-us/su...678741033.aspx


Gord Dibben MS Excel MVP

On Sun, 24 Dec 2006 14:55:01 -0800, Bob wrote:

Thanks for that I'm not really bothered if anyone else can read it so that
solves my problem. Can I get a copy from the net?




All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com