How to increase the number of columns in spredsheet
 

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

How to increase the number of columns in spredsheet
 

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" wrote:

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

How to increase the number of columns in spredsheet
 

Thomi wrote:
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

Specications for Excel 2003 65,536 rows by 256 columns

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

gls858

How to increase the number of columns in spredsheet
 

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

"Carole O" wrote:

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" wrote:

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

How to increase the number of columns in spredsheet
 

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

"gls858" wrote:

Thomi wrote:
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

Specications for Excel 2003 65,536 rows by 256 columns

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

gls858

How to increase the number of columns in spredsheet
 

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.

FileSave 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 FileNew or the Toolbar button FileNew

Warning................Do not use FileNew...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 InsertSheet.

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


Gord Dibben Excel MVP

Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 15:52:01 -0700, Thomi
wrote:

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

"gls858" wrote:

Thomi wrote:
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

Specications for Excel 2003 65,536 rows by 256 columns

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

gls858

How to increase the number of columns in spredsheet
 

Thanks Gord,

More columns than I could ever use. Much appreciated!
Thomi


"Gord Dibben" wrote:

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.

FileSave 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 FileNew or the Toolbar button FileNew

Warning................Do not use FileNew...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 InsertSheet.

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


Gord Dibben Excel MVP

Gord Dibben MS Excel MVP

On Thu, 5 Jul 2007 15:52:01 -0700, Thomi
wrote:

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

"gls858" wrote:

Thomi wrote:
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

Specications for Excel 2003 65,536 rows by 256 columns

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

gls858