financial excel course london - Excel

Hello Patrizia,

Hope you enjoyed your Microsoft Excel Introduction training this week.

Thank you for your question regarding eliminating blank rows from a list of dates. There are 2 ways you might consider using to achieve this result:

1 - Sort
This is the most simple, and if it solves your question, no need to go much further. Simply select the whole set of data you want to work with (all data - try putting your cursor in the data table, and then pressing CTRL and * to select all the details. Then, on the menu bar, click on Data, then SORT. You can then choose which column to sort by. Press OK.
Once you have done this, you will notice that all the BLANK details have been grouped together, which you can then delete or edit.


2 - Autofilter
Another way of addressing your question is to use what is known as Autofilter. Simply put your cursor in the data table, and then go to the menu bar - DATA > FILTER > AUTOFILTER.
What this does is adds drop down boxes on each of the columns that allows you to filter the content of the column. One of the options is BLANKS, which will show you only the blank records for that column.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Excel question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer