10/30/2022 0 Comments Excel for mac delete table names![]() ![]() ![]() Once you have the text based on which you want to filter, hit the Enter key. In case you have a lot of categories/regions, you can type the name in the field right above the box (that has these region names), and Excel will show you only those records that match entered text (as shown below). In the above example, I had only four distinct regions and I could manually select and deselect it from the Filter list (in steps 5 above). Control + – (hold the control key and press the minus key) to delete the selected cells/rows.Control + Shift + L to apply or remove the filter.Some useful shortcuts to know to speed up the process: Once you have the records, you simply delete these. The above steps first filter the data based on a cell value (or can be other condition such as after/before a date or greater/less than a number). This will remove the filter and you will see all the records except the deleted ones. Click the Data tab and click on the Filter icon.At this point, you will see no records in the dataset. In the dialog box that opens, click on OK.Right-click on any of the selected cells and click on ‘Delete Row’. ![]() This will filter the dataset and only show you records for Mid-West region.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |