Results 1 to 3 of 3

Thread: Filtered dataset / sort / hidden columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2010
    Posts
    154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Filtered dataset / sort / hidden columns

    If you a have sheet that is filtered, and hide columns, then sort (via any viewable column), does the hidden columns also sort?

    I have a fairly sizable file (12k rows, 37 cols; several columns are for me) that I want to send to a few team members to sort/verify/update their data. I'm concerned if I hide a dozen or so of my columns after they do their thing when I un-hide columns things won't line up; assuming they will sort a couple different ways before returning to me.
    Given answers, although appreciated, are easily forgotten; as those compared to hours of turmoil and frustration. and the hours have grown into weeks

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Filtered dataset / sort / hidden columns

    If the hidden columns are in the range of data being filtered, yes. Or if the range has been converted to a Table, yes.
    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  3. #3
    Board Regular
    Join Date
    Jan 2010
    Posts
    154
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filtered dataset / sort / hidden columns

    Quote Originally Posted by SpillerBD View Post
    If the hidden columns are in the range of data being filtered, yes. Or if the range has been converted to a Table, yes.
    Thanks
    Given answers, although appreciated, are easily forgotten; as those compared to hours of turmoil and frustration. and the hours have grown into weeks

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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