I am very new to Excel . I created this sheet for works. I read a very long cont

Question

I am very new to Excel. I created this sheet for works. I read a very long contract and just type items needed for each descriptions. As I do that it will tally in column E next to it's identification. This is working fine. But I do not want to see the inventorys list in column D & E unless its more than zero so that I don't print a giant list.

I applied the filter to Column E as shown below:!

I get this result:

It does filter the column but I now cant see what I have typed on the left. The cell count on the left is skipping numbers and all that I have typed in column A and B is missing. Why? ?

Explanation / Answer

It sounds like you want the content of Columns A & B to not be a part of the same List range as what is in Columns D & E. However, Excel's Filtering works on a complete row basis. Each List having content in the same Rows will be affected by the use of Filters, so if that's the case...

What you want recognized as separate Lists should not occupys the same rows. I.e., if the list in A & B runs to row 13, the content of D & E should beginn no farther up on the sheet than Row 14, preferably several rows lower... In fact, it's generallys recommended that separate lists be maintained on separate worksheets in ordesr to avoid just this type of confusion as well as other potential problems.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.