adding more columns/rows
 

each worksheet has 256columns and 65536 rows can i add extra columns or rows
to this?

adding more columns/rows
 

You can't that is the limit in Excel at present (2007 will have 1M rows 16K
columns)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jo Davis" wrote in message
...
each worksheet has 256columns and 65536 rows can i add extra columns or
rows
to this?

adding more columns/rows
 

Upgrade to xl2007 (still in beta test mode, though).

Jo Davis wrote:

each worksheet has 256columns and 65536 rows can i add extra columns or rows
to this?

--

Dave Peterson

adding more columns/rows
 

I upgraded to Office 2007 and my report did not add colums to the end of the
worksheet. I nned more colums to finish my report and upgrading did not add
the columns I needed.

"Dave Peterson" wrote:

Upgrade to xl2007 (still in beta test mode, though).

Jo Davis wrote:

each worksheet has 256columns and 65536 rows can i add extra columns or rows
to this?

--

Dave Peterson

adding more columns/rows
 

Open the file in xl2007.
Save the file as a normal workbook in xl2007 (*.xlsx or *.xlsm)
Close the file.
Reopen that file.

You should see more columns and rows.

ANbferry wrote:

I upgraded to Office 2007 and my report did not add colums to the end of the
worksheet. I nned more colums to finish my report and upgrading did not add
the columns I needed.

"Dave Peterson" wrote:

Upgrade to xl2007 (still in beta test mode, though).

Jo Davis wrote:

each worksheet has 256columns and 65536 rows can i add extra columns or rows
to this?

--

Dave Peterson


--

Dave Peterson