Learn IT

Filter out unwanted Excel records

Question: We have a spreadsheet that is a several thousand lines made up of three types of rows: User:, Patient:, and those that start with a plus sign.  Do you know a way to remove (delete) all of the rows that start with a plus sign without changing the order of the rows?

Answer: You may select the sort/filter icon from the Home tab in the ribbon (or from Data tab). Then click the filter down arrow on the heading of that column and unselect the plus sign on the + entries and keep checks in the User and Patient fields. This filters out the plus signs and only the User and Patient rows will display. You can then copy and paste those records to a new file, just in case you need to refer back to the original data.

Leave a Reply