Get the free blank info sheet form

Hello this is Aldo from Excel ninja calm in this video we'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 it's been given to you there are some missing rows so the blank rows there'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 I'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 there'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 minus sign and as you can see Excel says okay do you want delete and shift cells up you click OK and there you go all the blank rows have been deleted leaving you with leaving you with a table which is only the information that you need and with that you're able then to do whatever you want to do with it