How to increase the number of columns in spredsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The default number of colums seems to be a to IK. I need to increase this to
import and existing spreadsheet so it spans A to ND on all pages but can't
even get it to increase the colums on a single sheet.

Any help would be appreciated
Thanks
Thomi
 
The latest version of Excel will do what you want, I believe. Other than
that, there is no way to do what you want.

CaroleO
 
Thomi said:
The default number of colums seems to be a to IK. I need to increase this to
import and existing spreadsheet so it spans A to ND on all pages but can't
even get it to increase the colums on a single sheet.

Any help would be appreciated
Thanks
Thomi
Click to expand...

Specications for Excel 2003 65,536 rows by 256 columns

This limitation is virtually eliminated in Excel 2007 Rows: 1048576 and
Columns: 16384

gls858
 
Hi Carole,

I have just purchased Microsoft Office Excel 2007 and done all updates so
it is showing ver 12.0.6017.5000. The specifications say you may have
thousands of columns but I can't find how to make it even increase one at a
time.

Iain
 
Thanks gls . . .


I see that excel 2007 should support many more colums than I need I just
can't find how to set all my sheets in the workbook to 370 or so colums.
Thomi
 
You have 16384 columns per sheet.

You cannot delete them.

Just hide the ones you don't want to use.

If you want that to be the default setup for all new workbooks and
worksheets..............

Instructions Excel 2003 and earlier. I imagine 2007 is basically the same.

Open a new workbook. Customize as you wish.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New

Warning................Do not use File>New...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

Gord Dibben MS Excel MVP
 
Back
Top