Ran out of columns???
 

I need help.
I have this HUGE spreadsheet & I've run out of columns & can't add anymore.
I get this message:
To prevent possible loss of data, MS Excel cannot shirt nonblank cells off
the worksheet.
Try to locat the last nonblank cell by pressing ctrl&end & delete or clear
all in cells between the last cell and the end of your data. Then select cell
A1 and save your workbook to reset the last cell used.
or you can move the data to a new location & try again.
My last cell is IV 222. Is IV as far as it goes???
If so, how can I make a TOTALS columnn on a new sheet but use figures from
this huge sheets???

Thanks for ANY & all help

Trish

Excel is limited to 256 columns, or out to column IV. There is no
way to change this limit.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Trish" wrote in message
...
I need help.
I have this HUGE spreadsheet & I've run out of columns & can't
add anymore.
I get this message:
To prevent possible loss of data, MS Excel cannot shirt
nonblank cells off
the worksheet.
Try to locat the last nonblank cell by pressing ctrl&end &
delete or clear
all in cells between the last cell and the end of your data.
Then select cell
A1 and save your workbook to reset the last cell used.
or you can move the data to a new location & try again.
My last cell is IV 222. Is IV as far as it goes???
If so, how can I make a TOTALS columnn on a new sheet but use
figures from
this huge sheets???

Thanks for ANY & all help

Trish

1. Yes, IV is as far as Excel goes. This is a hard limit and cannot be changed.
2. If you have only 222 rows, one option is to switch your rows for columns. You
can have up to 65,536 rows.
3. To sum cells from another worksheet, use =sum(sheet1!a2:iv2) where "sheet1"
is the name of the worksheet (the one on the tab at the bottom).

--
Regards,
Fred


"Trish" wrote in message
...
I need help.
I have this HUGE spreadsheet & I've run out of columns & can't add anymore.
I get this message:
To prevent possible loss of data, MS Excel cannot shirt nonblank cells off
the worksheet.
Try to locat the last nonblank cell by pressing ctrl&end & delete or clear
all in cells between the last cell and the end of your data. Then select cell
A1 and save your workbook to reset the last cell used.
or you can move the data to a new location & try again.
My last cell is IV 222. Is IV as far as it goes???
If so, how can I make a TOTALS columnn on a new sheet but use figures from
this huge sheets???

Thanks for ANY & all help

Trish