Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 255 columns in excel 2007
I understand that in excel 2007 I can have more than 255 columns(256). I
can't figure out how to increase my column count. I can't find any reference in the help. Does anyone know how to do this? Thanks, John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 255 columns in excel 2007
Save the workbook as one of the new excel file types (.xlsx??). Then close and
reopen that file. John Tripp wrote: I understand that in excel 2007 I can have more than 255 columns(256). I can't figure out how to increase my column count. I can't find any reference in the help. Does anyone know how to do this? Thanks, John -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 255 columns in excel 2007
I understand that in excel 2007 I can have more than 255 columns(256). I
can't figure out how to increase my column count. I can't find any reference in the help. Aren't the columns simply 'there'? Press the <End key followed by the <RightArrow key... do you not go to Column XFD? Rick |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 255 columns in excel 2007
Hi John
If you load a workbook in Excel, that was created in an earlier version, it loads in compatibility mode and will only have the 256 columns by 65536 rows. If you save that as a 2007 file, with a .xlsx extension, then close the file and open it again, you will be able to access the full dimensions of the worksheet. Any new files created in XL2007, will have the full size. -- Regards Roger Govier "John Tripp" wrote in message ... I understand that in excel 2007 I can have more than 255 columns(256). I can't figure out how to increase my column count. I can't find any reference in the help. Does anyone know how to do this? Thanks, John |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 255 columns in excel 2007
Thanks! It's So Simple! Why didn't I think of that! This was our first time
running with 2007 and I had had him do a save as and that didn't seem to work. Now, I will remember to also have the user do the close/open for the future, since there are probably other features where we need to get the file to the new format for the features to work. John "Dave Peterson" wrote: Save the workbook as one of the new excel file types (.xlsx??). Then close and reopen that file. John Tripp wrote: I understand that in excel 2007 I can have more than 255 columns(256). I can't figure out how to increase my column count. I can't find any reference in the help. Does anyone know how to do this? Thanks, John -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
more than 255 columns in excel 2007
Thanks
"Roger Govier" wrote: Hi John If you load a workbook in Excel, that was created in an earlier version, it loads in compatibility mode and will only have the 256 columns by 65536 rows. If you save that as a 2007 file, with a .xlsx extension, then close the file and open it again, you will be able to access the full dimensions of the worksheet. Any new files created in XL2007, will have the full size. -- Regards Roger Govier "John Tripp" wrote in message ... I understand that in excel 2007 I can have more than 255 columns(256). I can't figure out how to increase my column count. I can't find any reference in the help. Does anyone know how to do this? Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Insert Columns | Excel Worksheet Functions | |||
Freezing multiple rows/columns in Excel 2007 Pro | Excel Worksheet Functions | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
Number of Excel 2007 Columns | Excel Discussion (Misc queries) | |||
Excel columns keep losing their formatting in 2007 Beta upgrade w. | Excel Discussion (Misc queries) |