View Full Version : Selecting Cells
2011-10-03, 03:21 PM
How can I select 3 contiguous cells (A1:A3) then not select the next 15 cells (A4:A15) then select the next 3 cells and so forth for about 6,000 lines. Then delete the content from those cells.
But please show me how to modify this so I can delete for example the content for cells (D4:D19) but not delete contents in (D20:D21). Then repeat that.
Thanks in advance!
2011-10-03, 03:25 PM
Put tmp in B1.
In B2 add this formula
copy down as far as you want, then filter column B for FALSE and clear column A.
2011-10-03, 03:33 PM
How can I delete the conents of the "true" cells but not get rid of the cells themselves? I need to retain the empty cells.
2011-10-03, 04:30 PM
Just hit the delete key when they are selected.
2011-10-03, 04:48 PM
When I filter by False in the B column, it automatically deletes the cells. How can I get it to just highlight the cells?
2011-10-03, 05:22 PM
No, it just hides them. Look at the row numbers.
2011-10-03, 06:03 PM
Ah Ha! Figured it out, thank you for your help.
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.