Editing OSHEET is fast and simple using DocHub. Skip downloading software to your laptop or computer and make alterations with our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send documents for completion to other people. All of this, put together with a competitive price, makes DocHub the perfect option to clear up symbol in OSHEET files effortlessly.
Make your next tasks even easier by turning your documents into reusable web templates. Don't worry about the protection of your records, as we securely keep them in the DocHub cloud.
how to create a button to clear only value keeping the cell format hello everyone welcome to excel 10 tutorial in this advanced excel tutorial iamp;#39;m going to show you how you can create a clear button here and when you press that button this data range will be cleared that means all the values inside the data range will be removed but this formatting will be still here okay now letamp;#39;s get started iamp;#39;m going to use a vbr code to solve this click on the developer tab click on visual basic click insert and click motion now write the code i have already written the code and you can see here range b9 to f20 this is the data range here b9 to f1g you can see f20 i want to remove values from this data range but i want to keep the cell formatting okay now every time i create an invoice here letamp;#39;s say this is my invoice item number and letamp;#39;s say this is the example quantity unit price discount letamp;#39;s leave it empty letamp;#39;s copy it again le