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