DocHub is an all-in-one PDF editor that enables you to wipe out arrow in spreadsheet, and much more. You can underline, blackout, or remove document fragments, add text and images where you need them, and collect information and signatures. And since it runs on any web browser, you won’t need to update your hardware to access its powerful tools, saving you money. When you have DocHub, a web browser is all it takes to make changes in your spreadsheet.
Sign in to our service and follow these steps:
It couldn't be simpler! Simplify your document processing today with DocHub!
hello this is Aldo from Excel ninja calm in this video weamp;#39;ll be looking at how to get rid of blank rows say for instance you have received from someone this piece of information a table that has your customer invoices payment due date invoice amount unfortunately the way itamp;#39;s been given to you there are some missing rows so the blank rows thereamp;#39;s no information there and basically they are useless and you just need to get rid of them to be able to manipulate the rest of information the good information so the way to do this you first need to select the whole range of data that you want to manipulate and so here Iamp;#39;ve done it and then you press f5 which presents you with the options of go to and what you want to do you want to click on special and then on to blanks thereamp;#39;s an option here that says blanks so this by clicking ok takes you to state where Excel has selected all the blank rows for you and the next step to delete them is to go control mi