Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2017, 06:09 PM
SKEETER SKEETER is offline How to delete unused cell remaining at end of a block of deleted data Windows 7 64bit How to delete unused cell remaining at end of a block of deleted data Office 2016
Novice
How to delete unused cell remaining at end of a block of deleted data
 
Join Date: Oct 2017
Posts: 2
SKEETER is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 10-24-2017, 06:16 AM
gebobs gebobs is offline How to delete unused cell remaining at end of a block of deleted data Windows 7 64bit How to delete unused cell remaining at end of a block of deleted data Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 10-24-2017, 07:06 AM
SKEETER SKEETER is offline How to delete unused cell remaining at end of a block of deleted data Windows 7 64bit How to delete unused cell remaining at end of a block of deleted data Office 2016
Novice
How to delete unused cell remaining at end of a block of deleted data
 
Join Date: Oct 2017
Posts: 2
SKEETER is on a distinguished road
Default

Thanks gebobs--it worked.
Reply With Quote
Reply



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
How to delete unused cell remaining at end of a block of deleted data Delete table if cell has data So New2 This Word VBA 1 05-06-2013 09:00 PM
How to delete unused cell remaining at end of a block of deleted data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft