Excel help

%3CLINGO-SUB%20id%3D%22lingo-sub-1275229%22%20slang%3D%22en-US%22%3EExcel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275229%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20brilliant%20at%20excel%20so%20bare%20with!%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20spreadsheet%20to%20store%20a%20large%20amount%20of%20information%20(suppliers%2C%20addresses%2C%20landlords%2C%20utility%20suppliers%20etc)%20for%20multiple%20buildings.%20The%20trouble%20is%20I%20have%20so%20much%20data%2C%20I%20end%20up%20scrolling%20along%20the%20spreadsheet%20searching%20for%20what%20I%20need.%3C%2FP%3E%3CP%3EIs%20there%20I%20was%20a%20can%20create%20a%20list%20of%20all%20buildings%20and%20then%20if%20I%20click%20on%20one%20of%20the%20cells%20containing%20the%20building%20names%2C%20have%20a%20box%20pop%20up%20that%20contains%20some%20of%20extra%20information%20required%20rather%20than%20having%20to%20scroll%20along%20the%20spreadsheet%3F%3C%2FP%3E%3CP%3EI%20hope%20that%20makes%20sense%3F!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1275229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Not brilliant at excel so bare with!

I'm trying to create a spreadsheet to store a large amount of information (suppliers, addresses, landlords, utility suppliers etc) for multiple buildings. The trouble is I have so much data, I end up scrolling along the spreadsheet searching for what I need.

Is there a way I can create a list of all building names and then if I click on one of the cells containing the building names, have a box pop up that contains some of extra information required rather than having to scroll along the spreadsheet?

I hope that makes sense?!

3 Replies
Highlighted

@Leesme77 Makes perfect sense. You could begin by putting a filter on your table. Select a cell anywhere inside your table and find the icon as shown in the picture below. It will put small triangles in each cell in your header row. Click on the one of your choice to filter out the data for one or multiple selections.

Screenshot 2020-04-02 at 16.06.56.png

 

Highlighted

@Riny_van_Eekelen Thank you. I have got it filtered at the moment, the issue is more on how many columns I have to scroll along. At the moment I have all the building names listed in column A, then the required info for each building going along the columns but this goes all the way along to column BN. Some of the information is not really needed to be seen every day but if I hide the cells, other's using the spreadsheet do not realize and cannot find this info when required.

I was hoping to be able to click on the building name listed in column A and when I click on the name, an extra box to pop up containing the information that is not really important enough to be listed along all the columns. I'm not sure if this is something excel offers / what that option would be called though? Many thanks

Highlighted

@Leesme77 If you have the latest Excel (Office365) and the FILTER function is recognised by it, you can hide the less important columns and show them in what you could call a dynamic filter at the end of your table. That way you can group your most important columns in the beginning. To enable this I added an "*" to every column header. Have a look at the attached file. It has a working example. Hope it works for you.