Stupid Excel Question

Discussion in 'Windows Desktop Systems' started by saeltmarae2k, Mar 27, 2007.

  1. saeltmarae2k

    saeltmarae2k OSNN Addict

    Messages:
    73
    Hey guys,

    I just upgraded to Office07, and like it so far. I can't seem to find (and I'm sure it's right under my nose) a function that I used quite a bit on Excel03. I have a huge spreadsheet and need to be able to compare data in Column A with data in colums DD-FF...I used to be able to insert a "break"...essentially, I could put it right next to column A and scroll over to the columns that I needed to compare...make sense? How do I do this in excel07? Also, how can I print ONLY what I see (example: [Column A - break - Columns AA, AB) when I get it set up?

    Thanks!
     
  2. hansrijf

    hansrijf sh! it stinks Folding Team

    Messages:
    277
    Location:
    Amsterdam, The Netherlands
    There is no "hide" option to hide the columns anymore?
     
  3. sboulema

    sboulema Moderator

    Messages:
    2,846
    Location:
    Amstelveen, The Netherlands
    The hide/unhide option still exists...
     
  4. Mooz

    Mooz Moozically Con~foozed

    Messages:
    126
    Location:
    UK
    the option you are looking for is called split and its on one of the view ribbons/

    D
     
  5. rushm001

    rushm001 In the beginning...... Political User

    Messages:
    3,480
    Location:
    Norfolk, UK
    Freeze panes? Tis the same as in Excel 2003, click the little break thing in the scrollbar and then view and freeze panes. :)
     
  6. hansrijf

    hansrijf sh! it stinks Folding Team

    Messages:
    277
    Location:
    Amsterdam, The Netherlands
    I would say: select the columns you don't need, right click and select "hide"

    You can have the two columns you want to compare side-by-side.
     
  7. Sazar

    Sazar F@H - Is it in you? Staff Member Political User Folding Team

    Messages:
    14,905
    Location:
    Between Austin and Tampa
    Yah, I would think the freeze panes option is what you're looking for as well.
     
  8. albybum

    albybum Penguin Rancher

    Messages:
    280
    Location:
    Elizabethton, TN