Quantcast

Excel help: checkered boxes for a data set

Discussion in 'Computers & Technology' started by stoney, May 10, 2016.

  1. stoney

    stoney Part of the unwashed, middle-American horde

    Rep/Likes:
    94 / 678
    Joined:
    Jul 26, 2006
    Messages:
    11,601
    Location:
    Colorado
    As titled, I am trying to checker a data set. Row and column, every other box a color not white. I basically have a 100x100 data set that's all numbers and I need to break it up so that it is easier to look through.
     

    Please register to disable this ad.

  2. rockofullr

    rockofullr confused

    Rep/Likes:
    69 / 289
    Joined:
    Jun 11, 2009
    Messages:
    5,775
    Location:
    East Bay, Cali
    Set up the first few lines and the copy/paste the formatting over the rest.
     
  3. StiHacka

    StiHacka Compensating for something

    Rep/Likes:
    262 / 2,125
    Joined:
    Jan 4, 2013
    Messages:
    7,430
    Location:
    i͓̽t͓̽ i͓̽s͓̽ fu͓̽l͓̽l͓̽ o͓̽f s͓̽t͓̽a͓̽r͓̽s͓̽
    Try it now
     
  4. stoney

    stoney Part of the unwashed, middle-American horde

    Rep/Likes:
    94 / 678
    Joined:
    Jul 26, 2006
    Messages:
    11,601
    Location:
    Colorado
    Data set is already in place. Not going to recreate the wheel here.
     
  5. rockofullr

    rockofullr confused

    Rep/Likes:
    69 / 289
    Joined:
    Jun 11, 2009
    Messages:
    5,775
    Location:
    East Bay, Cali
    Go to "Past Special". Choose "Formats". Or use the "Format Painter" tool and finger paint it on like a big boy.
     
    #5 -   May 10, 2016
    Last edited: May 10, 2016
    • Like Like x 1
    • Funny Funny x 1
  6. Serial Midget

    Serial Midget Al Bundy

    Rep/Likes:
    120 / 1,096
    Joined:
    Jun 25, 2002
    Messages:
    12,321
    Location:
    Fort of Rio Grande
    From my limited experience checkering 10K bits of information will not be any more effective than alternating columns or rows, I review massive spread sheets and seldom see checker boards on anything other than small tables.
     
    • Like Like x 1
  7. stoney

    stoney Part of the unwashed, middle-American horde

    Rep/Likes:
    94 / 678
    Joined:
    Jul 26, 2006
    Messages:
    11,601
    Location:
    Colorado
    The prior solved it.
     
  8. stoney

    stoney Part of the unwashed, middle-American horde

    Rep/Likes:
    94 / 678
    Joined:
    Jul 26, 2006
    Messages:
    11,601
    Location:
    Colorado
    It's a data set that I reference multiple times per day. much easier for me to do that way. Also, I don't feel like writing a macro.
     
  9. rockofullr

    rockofullr confused

    Rep/Likes:
    69 / 289
    Joined:
    Jun 11, 2009
    Messages:
    5,775
    Location:
    East Bay, Cali
    Whatever works for you, but I find that alternating rows or columns makes it easier for your eye to follow from the header to the number. You wouldn't need a macro just do it for the first few cells and then format paste it everywhere else like you did for the checkerboard.

    This can really help you look at lots of data when combined with the "Freeze Panes" option
     
  10. Serial Midget

    Serial Midget Al Bundy

    Rep/Likes:
    120 / 1,096
    Joined:
    Jun 25, 2002
    Messages:
    12,321
    Location:
    Fort of Rio Grande
    • Useful Useful x 1