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.

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