PDA

View Full Version : Selecting Cells



John Davis
2011-10-03, 04: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!

Bob Phillips
2011-10-03, 04:25 PM
Put tmp in B1.

In B2 add this formula

=ISNUMBER(MATCH(MOD(ROW(),19),{1,2,3},0))

copy down as far as you want, then filter column B for FALSE and clear column A.

John Davis
2011-10-03, 04: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.

Bob Phillips
2011-10-03, 05:30 PM
Just hit the delete key when they are selected.

John Davis
2011-10-03, 05: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?

Bob Phillips
2011-10-03, 06:22 PM
No, it just hides them. Look at the row numbers.

John Davis
2011-10-03, 07:03 PM
Ah Ha! Figured it out, thank you for your help.