Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |