Unmerged cells: Unmerged Cells

See attached screenshot. I want to show multiple limits/attachments/premiums for a single Insured/broker/industry.

I've tried merging rows (see below) for Insured/broker/industry but then I am unable to filter and get all the data for each limit. (it only takes the first row)

Merged Cells: Merged Cells

Filtered Cells: enter image description here

Having it laid out with all the rows unmerged means I can filter the data, however it makes the page a little hard to read, especially as it gets larger and larger.

Does anyone have any ideas for displaying the data in a different way?

  • you can use VB code to merge based on your logic, Out of box all you have is merge fields etc not the way you want to merge, it would have to be done programmatically – SeanClt Mar 29 '16 at 13:36
  • I don't necessarily need to merge, it just doesn't look that great over 1000s of rows. Was trying to think differently for viewing options. – Kevin Mar 29 '16 at 13:38
  • if merge is not what you want then rephrase your question correctly – SeanClt Mar 29 '16 at 13:39
  • center across selection – Raystafarian Mar 29 '16 at 13:39
  • You could use a pivot. Let user select the Insured/broker/industry and display all the line items related to that. Additionally you could add slicers if you are using Excel 2010 and newer. – Firee Mar 29 '16 at 13:39

You can use the MACRO!

Method : View > Macros > Record Macro

Record Macro

fill all boxes

press OK And filter data now.

Fo: View > Macros > Stop Recording

The next time you need to run the macro to be applied in 1 second filter

Methods run the macro: View > Macros > View Macros

View Macros

You can see all the macros, edit it and run it. For the work that you've saved in this macro simply click on the Run button

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.