#1
|
|||
|
|||
How to delete unused cell remaining at end of a block of deleted data
I can't get rid of a highlighted cell (empty) left after deleting an extensive block of data. So, when I key in Ctrl-end it takes me way beyond the remaining data.
|
#2
|
|||
|
|||
You probably have some garbage data somewhere, maybe just a single space, that you can't see. Go to the row immediately after your existing data. Select it and all the other rows (either to the problem cell or to the end of the sheet) and delete.
|
#3
|
|||
|
|||
Thanks gebobs--it worked.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to create a block text and when click on the title of block hide and unhide the block | labasritas@free.fr | Word | 4 | 09-17-2017 01:17 PM |
Detecting last cell within a block | Funk | Excel | 12 | 10-01-2013 04:26 AM |
Delete table if cell has data | So New2 This | Word VBA | 1 | 05-06-2013 09:00 PM |
How to delete certain mail from Deleted Items | Andoheb | Outlook | 8 | 03-25-2012 01:25 PM |
Problem Delete Block? No (Yes) | BooBear | Word | 0 | 05-08-2009 11:44 AM |