How do I hide columns using a button that slides back and forth

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I went to an Excel class once and they showed us a very simple way to hide
and unhide columns or rows using a button that looks like it slides back and
forth (it actually looked like a volume control button that slid back and
forth)to hide and unhide the colums.It was sort of like a zipper...

I can't remember how to create that sliding button...
 
Hi,

I guess you are talking about outlining.

Select the range which you want to outline. On the keyboard, press the
combination of Alt+Shift+Right Arrow key and select rowa or columns. Now you
will get a minus symbol on the row or column columns. Press the minus symbol
to contract the outline.

Regards,
 
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

Hide unused rows based on column info 5
plus-minus buttons in far left column (1) 3
Hiding columns without usimg a macro 3
macro to hide a row when a cell contains a value 1
Code for button to hide/unhide rows 5
hide columns with a "+" 2
Hide Rows or Columns with +/- button above row/column label headin 2
Automatically hide/unhide rows 5

Back
Top