+ Reply to Thread
Results 1 to 4 of 4

Excel auto-groups tabs when I try to paste special

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Toronto, Canada
    MS-Off Ver
    MS Excel 365
    Posts
    49

    Excel auto-groups tabs when I try to paste special

    As it says in the title. When I am trying to focus on only one tab "1" out of 15 other tabs, Excel groups all 15 tabs by itself as soon as I hit paste special. I went and de-selected the tabs and chose only one tab, but it keeps doing this.

    Does anyone know how to stop this?

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Excel auto-groups tabs when I try to paste special

    Can you post your file so we can take a look?

  3. #3
    Registered User
    Join Date
    11-15-2012
    Location
    Toronto, Canada
    MS-Off Ver
    MS Excel 365
    Posts
    49

    Re: Excel auto-groups tabs when I try to paste special

    EDIT: sorry the problem has disappeared after I closed all my files, but it's really odd how earlier Excel was deciding to auto-group tabs which was very annoying..

    I'm trying to create a sample for you but if I condense the file down, that problem goes away, so I don't know what's triggering this.

    This file was originally created from a blank sheet so no VBA, no macros, nothing.

  4. #4
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Excel auto-groups tabs when I try to paste special

    That is the only thing I could think of is that somehow all those tabs were grouped(selected).
    Hope it is ok from now on

+ 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. Replies: 14
    Last Post: 09-05-2017, 11:32 AM
  2. copy tabs, paste special values
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2015, 01:30 PM
  3. Auto run macro from paste or paste special in to specific cell
    By Craig Muir in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2014, 10:00 AM
  4. Replies: 2
    Last Post: 12-25-2013, 03:47 PM
  5. Replies: 1
    Last Post: 12-05-2012, 11:37 AM
  6. Replies: 6
    Last Post: 12-09-2011, 05:22 AM
  7. [SOLVED] excel stack tabs in groups, less scrolling L2R, hovering over gro.
    By Stephen Robb in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 08: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