Excel 2019

Copper Contributor

I have a spreadsheet of inventory items categorized by status, i.e. in-use, available, new, disposed, etc. I sort and filter on the status codes and both a location (building) and room # depending upon the need.

 

Somehow I've lost every item aside from those categorized as "in-use"...., and not sure why.  The first row of my spreadsheet begins on line 156 after the column headings. I think all the rows are there, and I've tried un-filtering, un-hiding, resorting, etc. No matter what I'm only able to see the "in-use" items.

 

Not sure what I did to mess this up, or how to get all the rows to view again. Any advice would be greatly appreciated. 

 

Thanks,

Walt N

1 Reply
Can you post a screen-shot of your worksheet please (blur any sensitive data)?