SOLVED
Home

Excel formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-636582%22%20slang%3D%22en-US%22%3EExcel%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636582%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20need%20hide%20the%26nbsp%3Bcolumn%20D7%3B%20to%20D37%20In%20window%2010%20which%20the%20data%20no%20entry%20from%20B7%20to%20B37.%20I%20can%20hide%20whole%20column%20but%20I%20cant%20hide%20the%20which%20I%20need%20not%20shown%20when%20no%20entry%20at%20column%20B.%20How%20do%20I%20can%20make%20it%20hide%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-636582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636688%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636688%22%20slang%3D%22en-US%22%3EYou%20cannot%20hide%20just%20a%20square%20set%20of%20cells%20within%20one%20column%20or%20row.%20Why%20do%20you%20want%20to%20do%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-636884%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-636884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347142%22%20target%3D%22_blank%22%3E%40SIVA7789%3C%2FA%3E%26nbsp%3B%2C%20as%20workaround%20you%20may%20apply%20conditional%20formatting%20-%20if%20nothing%20in%20B%20apply%20same%20font%20and%20cell%20color%20(e.g.%20grey%20one)%20in%20D%2C%20otherwise%20no%20such%20formatting.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-637011%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-637011%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20sir%2C%26nbsp%3BI%20already%20apply%20the%20conditional%20formatting.%20Thanks%20for%20you%20advise.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-637023%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-637023%22%20slang%3D%22en-US%22%3EOriginal%20worksheet%20I%20will%20keep%2C%20but%20for%20manual%20record%20I%20need%20to%20pass%20to%20the%20production%20line.%20they%20will%20write%20the%20record.%20The%20day%20they%20record%2C%20balance%20will%20calculate%20by%20their%20self.%20that%20why%20I%20need%20hide%20the%20D%20records.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-637037%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-637037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F347142%22%20target%3D%22_blank%22%3E%40SIVA7789%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
SIVA7789
New Contributor

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?
Solution

@SIVA7789 , 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.

Highlighted
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.

@SIVA7789 , you are welcome

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies