Help: I am trying to create buttons in Excel

  • Thread starter Thread starter fenisol
  • Start date Start date
F

fenisol

Hi all,

I am trying to create an expand/collapse button (+/-
button) to group similar cells. For example, if cell A1
has "catch22", cell A2 "catch23", A3 catch24, I am trying
to group them under "catch" and create a button next to
it. How would I do this? Thank you.
 
Look at Data>Group and Outline.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
Excel pivot tables - specific expand/collapse buttons visibility 1
Collapsing all groups 0
Excel grouped data 2
Collapsing rows via command button 2
TRUE/FALSE MACRO using Option Buttons 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
matching cell formula 1

Back
Top