Excel formula Help

Not applicable

Hi, I need hide the column D7; to D37 In window 10 which the data no entry from B7 to B37. I can hide whole column but I cant hide the which I need not shown when no entry at column B. How do I can make it hide?

5 Replies
You cannot hide just a square set of cells within one column or row. Why do you want to do this?

@Deleted , as workaround you may apply conditional formatting - if nothing in B apply same font and cell color (e.g. grey one) in D, otherwise no such formatting.


Thank you sir, I already apply the conditional formatting. Thanks for you advise.

Original worksheet I will keep, but for manual record I need to pass to the production line. they will write the record. The day they record, balance will calculate by their self. that why I need hide the D records.

@Deleted , you are welcome

Related Conversations
Removing unnecesary characters
Ocasio27 in Excel on
2 Replies
Excell spread sheet
CDeyzel1600 in Excel on
1 Replies
unable to open an excel file
keithsmarathon in Excel on
0 Replies