| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update End of Col or End of Row Reference
Thanks Sean.
"Sean Timmons" wrote: start at the first blank row. Highlight to bottom of workbook (Shift/CTRL/Down Arrow) Edit/Delete Go back to cell A1 Save "Brent E" wrote: I have a spreadsheet that is very long. Most of the data has been filtered and deleted; however, the file still seems to have numerous blank lines associated w/ it in the rows below the last data line. Is there a way to reset or update the End of Col value so that the spreadsheet no longer thinks these deleted rows still contain data? For example if there are 4000 rows of data in a sheet, and 3000 are deleted, is there a way to get the file to recognize that the data ends after row 1000 now instead of 4000? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update reference in multiple formulas | Excel Worksheet Functions | |||
| Worksheet Reference Doesn't Update After Sort | Excel Worksheet Functions | |||
| HowTo disable cell reference update | Charts and Charting in Excel | |||
| Update cell reference within a formula | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
Threaded Mode
