When you want to apply a minor tweak to the document, it must not require much time to Dispose highlight document. Such a basic activity does not have to require additional training or running through guides to learn it. Using the right document modifying tool, you will not spend more time than is necessary for such a swift change. Use DocHub to streamline your modifying process regardless if you are a skilled user or if it’s your first time using a web-based editor service. This tool will require minutes or so to learn how to Dispose highlight document. The sole thing required to get more productive with editing is a DocHub profile.
A plain document editor like DocHub will help you optimize the time you need to spend on document modifying regardless of your prior knowledge about such tools. Create an account now and improve your efficiency immediately with DocHub!
hello this is Aldo from Excel ninja calm in this video well 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 its been given to you there are some missing rows so the blank rows theres 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 Ive 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 theres 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 minus sign and as you can see Excel says