+ Reply to Thread
Results 1 to 2 of 2

Button appeared at top that hides/unhides cells and spreadsheet

  1. #1
    Registered User
    Join Date
    12-22-2014
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    1

    Angry Button appeared at top that hides/unhides cells and spreadsheet

    Hi,

    I am looking for some help regarding the following problem. I don't understand where the buttons "1" and "2" have come from. THey seem to hide/unhide Columns C->H when used. However, this is created problems with the rest of my spreadsheet.

    When I copy + paste into cells, it seems to appear in a different cell, until I highlight all cells, where it appears in the cell it should have pasted into.

    Any help would be much appreciated.

    excelhelp1.PNG

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,694

    Re: Button appeared at top that hides/unhides cells and spreadsheet

    Go to the Data ribbon - you will see the Group and Ungroup icons. Somehow you have grouped these columns.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rationalizing my VBA code (it hides/unhides rows and then autofits them)
    By David M. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2014, 01:06 AM
  2. [SOLVED] Macro code that hides or unhides rows in other worksheets
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2012, 04:10 PM
  3. Macro that hides/unhides sheets depending on cell value
    By amelio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2011, 06:33 AM
  4. Userform that hides/unhides worksheets
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2008, 09:36 AM
  5. Button hides unhides columns, how?
    By JimH in forum Excel General
    Replies: 3
    Last Post: 04-20-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1