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)?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies