Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |