Hiding Rows containing a Column that contains certain word

T

Tracee4172

New Member
Joined
Mar 24, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a spreadsheet that in Column F there is data that could contain the words AV Temp. If it does I want to hide those rows. Report has about 1500 rows and i don't want to manually hide them.

I have tried the macro approach but it either hides every row or none.

Any suggestions?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Sort by date Sort by votes
Welcome to the Board!

This can be done easily with Filters. Just choose the text option "Does not contain", and enter "AV Temp".
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
automatically hiding a row
Replies
7
Views
230
Mattlake
M
R
  • Question Question
Button to hide/unhide rows with specific text
2
Replies
11
Views
415
NoSparks
N
N
  • Question Question
Toggle code to hide and unhide columns based on text in a row
Replies
1
Views
478
Cubist
Cubist
F
  • Solved
PivotTable Fields and VBA
Replies
3
Views
180
Domenic
D
C
  • Solved
Highlight entire rows in used range where any cell contains searched text
Replies
5
Views
469
CorrieAnn
C

Forum statistics

Threads
1,223,723
Messages
6,174,123
Members
452,546
Latest member
Rafafa

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top