Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 on one page - even in landscape, please help. -- Thanks Bob |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 on one page - even in landscape, please help. -- Thanks Bob |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting and pasting from rows into columns and visa versa. | New Users to Excel | |||
Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
Selecting different multiple columns | Excel Worksheet Functions | |||
adding three consecutive columns | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |