DocHub is an all-in-one PDF editor that allows you to conceal verse in xls, and much more. You can underline, blackout, or erase document fragments, add text and pictures where you need them, and collect information and signatures. And since it works on any web browser, you won’t need to update your software to access its robust capabilities, saving you money. With DocHub, a web browser is all it takes to manage your xls.
Sign in to our website and adhere to these steps:
It couldn't be easier! Simplify your document processing today with DocHub!
hello everyone welcome to excel 10 tutorial in this Advanced Excel tutorial Iamp;#39;m going to show you how you can hide column based on text in Microsoft Excel Iamp;#39;m going to show you two different ways to do it Iamp;#39;m going to do it using conditional formatting and Iamp;#39;m going to do it using VBA letamp;#39;s get started so take a look at this workbook here we have actual cells here and we have forecast here okay now I want to hide forecast whenever I write actual here okay so to do that Iamp;#39;m going to select the forecast Iamp;#39;m going to click on conditional formatting and click on new rules okay use formula to determine which cell to format and then Iamp;#39;m going to write equal to and within parenthesis Iamp;#39;m going to write B3 and then Iamp;#39;m going to write actual within double quotation now close parenthesis and Iamp;#39;m going to click on format and then from the font section Iamp;#39;m going to change the font color to white