Hide Cell with specific value/keyword

Discuss the spreadsheet application

Hide Cell with specific value/keyword

Postby Azshara » Fri Apr 12, 2019 2:16 pm

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
Azshara
 
Posts: 11
Joined: Mon Mar 04, 2019 3:40 pm

Re: Hide Cell with specific value/keyword

Postby Villeroy » Fri Apr 12, 2019 3:53 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27105
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests