How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard
Richard, Consultant
Category: Programming
Satisfied Customers: 36526
Experience:  Programming and Network consultancy for 15+ years
32989067
Type Your Programming Question Here...
Richard is online now
A new question is answered every 9 seconds

Excel...extreme left side...2 columns labeled 1,2...several

Customer Question

Excel...extreme left side...2 columns labeled 1,2...several rows down a little slider box...it hides, unhides a row...what did I do to activate this...how do I de-activate...and what is the reason for this feature? Thanks.
JA: What programs and versions are you using?
Customer: Downloaded latest version 3wks ago...programs? simply adding data by hand.
JA: What is your ideal outcome? How can we solve this for you?
Customer: how do I de-activate these two unwanted columns
JA: Anything else you want the programmer to know before I connect you?
Customer: no
Submitted: 8 months ago.
Category: Programming
Expert:  Richard replied 8 months ago.

Hi there and welcome

I believe you are referring to the option to groping rows

Select the problem rows, then Try Data > Group > UnGroup

Does this then stop it?

Customer: replied 8 months ago.
the 2 columns still appear...the slider boxes have disapearred
Customer: replied 8 months ago.
no thanks...I'll preceed myself...thanks
Expert:  Richard replied 8 months ago.

Columns will always appear...

Can you attach the file do I can see which columns you are referring to please?

Expert:  Richard replied 8 months ago.

ok, well the columns you either need to delete by right clicking on the label at the top then Delete

The sliders is Grouping and this you did via Data > Group > Group by accident. It is a feature in Excel that allows you to manage the display of data easily.

I am not sure what though you mean with the No Thanks... but if you would like any additional information or assistance, please do not hesitate to let me know.

And please take a second to rate my service by clicking one of the stars at the top of the screen then submit

Thank you