Delete Rows On Excel Code Be Liable

Now we need to delete the rows with City: Boston As you can see filtered Rows with City:Boston.

Go to Home Find Select Go To Special Go To Special dialog box appears Select Visible cells only OK.

Right click on any selected cell Select Delete Row It shows a warning as shown below Click Ok.

To view other cells, Double click on the red part shown in the left in the snapshot.

You will get your desired output as shown below in the table.

This is a very useful function while editing data in your worksheet.

However, initially I tried it on data that was formatted as a table.

Do you know of a way of doing the same thing when the data is a table Reply.

I have about 50 columns of data so adding back the header row is not an option.

Otherwise, nice feature but only if you have a few columns and can retype the header row.

Delete Rows On Excel Code Be Liable

In no event shall the owner of the copyrights, or the authors of the applicationscode be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applicationscode.

Home About Advertise With Us Excel Tips and Tricks Excel Editing Excel Format Newsletter Get latest updates from exceltip in your mail.

Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

You can adjust all of your cookie settings by navigating the tabs on the left hand side.

Strictly Necessary Cookies Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

This means that every time you visit this website you will need to enable or disable cookies again.

How To Delete Rows On Excel For Mac