G Guest Sep 12, 2006 #1 each worksheet has 256columns and 65536 rows can i add extra columns or rows to this?
B Bob Phillips Sep 12, 2006 #2 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)
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)
A ANbferry Sep 24, 2008 #4 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.
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.
D Dave Peterson Sep 24, 2008 #5 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.
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.