Excel vpršanje če celica vsebuje

Ravny

Pripravnik

23. avg 2007

667

3

18

• 23. mar 2020

• #1

Ali mi lahko kdo pomaga pri excel in sicer označil sem celice v polju G z TRU in FALSE kako sedaj najlažje naredim pravilo da skrije "hide rows" če celica G vsebuje text TRUE

Hvala

 

B

Bucko

Fizikalc

28. avg 2007

1.739

53

48

• 23. mar 2020

• #2

"There is no way, unfortunately, to easily hide rows based on the value of a particular cell in a row."

Dve opcije imaš: filter ali macro:

How to Hide Rows Based on a Cell Value in Excel - Free Excel Tutorial

This post will guide you how to hide rows based on cell value in Excel. How do I hide rows based on cell value with VBA Macro code in Excel 2013/2016.

www.excelhow.net

 

Ravny

Pripravnik

23. avg 2007

667

3

18

• 23. mar 2020

• #3

Hvala sicer VBA ne rzumem kako bi naredil bom pa še pregledal

 

M

Mato

Majstr

3. okt 2007

2.083

393

83

• 24. mar 2020

• #4

Samo Filter daj, pa bo delalo.

Filter data in a range or table - Microsoft Support

Training: Watch and learn how to filter data in Excel.

support.office.com