| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel deleting rows last cell does not change. How to change?
I Delete rows in excell and save the file. I bring the file back up but the
last cell is still where it was (several rows below the last row with data). I do I get excel to change the last cell value? -Mark |
|
#2
|
|||
|
|||
|
Sounds like you're deleting cell contents instead of deleting entire rows.
See: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "mrubey" wrote in message ... I Delete rows in excell and save the file. I bring the file back up but the last cell is still where it was (several rows below the last row with data). I do I get excel to change the last cell value? -Mark |
|
#3
|
|||
|
|||
|
more likely missing the last step described on your webpage -- saving the file.
"Anne Troy" wrote in message ... Sounds like you're deleting cell contents instead of deleting entire rows. See: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "mrubey" wrote in message ... I Delete rows in excell and save the file. I bring the file back up but the last cell is still where it was (several rows below the last row with data). I do I get excel to change the last cell value? -Mark |
|
#4
|
|||
|
|||
|
Dave,
Thanks. The solution was to turn off the auto filter and freeze pane, save the file, close the file, then open the file again and reset the auto filter and freeze pane. -Mark "David McRitchie" wrote: more likely missing the last step described on your webpage -- saving the file. "Anne Troy" wrote in message ... Sounds like you're deleting cell contents instead of deleting entire rows. See: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "mrubey" wrote in message ... I Delete rows in excell and save the file. I bring the file back up but the last cell is still where it was (several rows below the last row with data). I do I get excel to change the last cell value? -Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Rows in MS Excel | Excel Discussion (Misc queries) | |||
| How do i change the height and width of a single cell in Excel? | Charts and Charting in Excel | |||
| How to protect a cell or rows with MS excel 2000 | New Users to Excel | |||
| change excel row height without showing hidden rows | Excel Worksheet Functions | |||
| How Do I change the background color of a cell in microsoft excel. | Excel Discussion (Misc queries) | |||
Linear Mode
