after selecting 50 rows of a column i can't reference the cells in the rows

B

Bob Salzer

I have a workbook that contains energy information about every floor of
a building. In column 'Z' there could be a message called 'no savings'.
What i want to do is delete these
rows. I have started by selecting a range within column 'z' from 10 to
175.
now comes the problem. As i read through each cell how do i check the
field for 'no savings'
and then how do i delete the row? i have tried almost everything except
for the one that works. If anyone out there can help me i would sure
appreciate it. thanks, bob
 
M

Marcelo

Hi Bob,

use Autofilter to select the rows that you want to delete,

press F5 special - select visivable cells only

hth
regards from Brazil
Marcelo


"Bob Salzer" escreveu:
 
G

Gord Dibben

Bob

Select column Z and Data>Filter>Autofilter.

Click on the drop-down arrow and select "no savings" from the list.

Click OK and then F5>Special>Visible cells>OK

Edit>Delete Row.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Need excel copy a row and automatically insert new rows based on a cell contents 0
How can I refer to a row 2
Shifting rows to sheet2 using Macro 5
Deleting A COLUMN BY MACRO 6
Highlight rows if column A matches but B is different 0
Copy rows to new sheet based on value in column A 0

Top