Hide Cell with specific value/keyword

Discuss the spreadsheet application
Post Reply
Azshara
Posts: 11
Joined: Mon Mar 04, 2019 3:40 pm

Hide Cell with specific value/keyword

Post by Azshara »

Hi again guys :). I am struggling right now about worksheet. Is there any way wherein when I type a word in a cell (or a keyword) the whole row will automatically hide
In my worksheet e.g. when I type OFF the whole row should be hidden and when I type ACTIVE then there's no action to be done. Looking forward to your help :) Thanks...

Image
OpenOffice 4.1.1
Windows 10 Pro 1803
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Hide Cell with specific value/keyword

Post by Villeroy »

meu:Data>FilteAutoFilter
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply