Home

Excel 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-731553%22%20slang%3D%22en-US%22%3EExcel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731553%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20of%20inventory%20items%20categorized%20by%20status%2C%20i.e.%20in-use%2C%20available%2C%20new%2C%20disposed%2C%20etc.%20I%20sort%20and%20filter%20on%20the%20status%20codes%20and%20both%20a%20location%20(building)%20and%20room%20%23%20depending%20upon%20the%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomehow%20I've%20lost%20every%20item%20aside%20from%20those%20categorized%20as%20%22in-use%22....%2C%20and%20not%20sure%20why.%26nbsp%3B%20The%20first%20row%20of%20my%20spreadsheet%20begins%20on%20line%20156%20after%20the%20column%20headings.%20I%20think%20all%20the%20rows%20are%20there%2C%20and%20I've%20tried%20un-filtering%2C%20un-hiding%2C%20resorting%2C%20etc.%20No%20matter%20what%20I'm%20only%20able%20to%20see%20the%20%22in-use%22%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20what%20I%20did%20to%20mess%20this%20up%2C%20or%20how%20to%20get%20all%20the%20rows%20to%20view%20again.%20Any%20advice%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EWalt%20N%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-731553%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-731591%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-731591%22%20slang%3D%22en-US%22%3ECan%20you%20post%20a%20screen-shot%20of%20your%20worksheet%20please%20(blur%20any%20sensitive%20data)%3F%3C%2FLINGO-BODY%3E
tech_asst60
Occasional Visitor

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)?