Find solution
how can I check when the last list item has been deleted?

Gaps in excel list after deleting an item from list?

  • I created a list in excel, and later decided I didn't need an item on one of the columns of that list. So, I filtered the list to show me just that item, then I selected all the rows that had the item and deleted them. Now not only do I have gaps in the list, I can't click on ANYTHING below the row marked by an asterisk (the 10th row). I have about 180 rows... What's going on?!?! I appreciate everyone's help with this!

  • Answer:

    Try resorting your data. Hopefully this will consolidate the table and allow you to add to the end of the list. It sounds as if the table has been designated as a list, it needs the resort to reset the list parameters,

zipzapbo... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.