adding more columns/rows

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

Guest

each worksheet has 256columns and 65536 rows can i add extra columns or rows
to this?
 
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)
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last row on spreadsheet is row # 65536. How can I add more rows? 3
How to limit number of rows and column in worksheet? 1
Consolidate data from worksheet (more then 65536 rows) 1
Find last row with data 3
Data | filter 1
how do i change the column name "A","B","C" 2
Excel Help to copy information from one row at a time to another sheet 1
lookup row number 3

Back
Top