Editing xls is fast and simple using DocHub. Skip installing software to your computer and make changes with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and email records for completion to other people. All of this, put together with a competitive price, makes DocHub the ideal decision to conceal scuff in xls files effortlessly.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the safety of your records, as we securely keep them in the DocHub cloud.
hello everyone today Iamp;#39;m gonna show you how to solve a more advanced problem thatamp;#39;s derived from one of my popular video how to automatically hide rows based on cell values so I have the code here and Iamp;#39;ve explained to you how to do it so now today Iamp;#39;m gonna take you one step further to show what if the cell that we are deriving the the function from its formula treated so letamp;#39;s come back to this is the original spreadsheet that I have for the previous video so basically this is a drop down so as you select a different job down with value which is not formula driven you can basically show the relevant roles correct so today and actually I have I have this is coming up which is what if the value that we are showing here is formula driven so it can be any formula so as I can see here Iamp;#39;m actually putting one of the most easy formula here which is the battery here is essentially derived from the cell c4 it only has two a force but then if we