Stupid Excel Question

[saeltmarae2k]

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!

 

[hansrijf]

There is no "hide" option to hide the columns anymore?

 

[sboulema]

The hide/unhide option still exists...

 

[Mooz]

the option you are looking for is called split and its on one of the view ribbons/

D

 

[rushm001]

Freeze panes? Tis the same as in Excel 2003, click the little break thing in the scrollbar and then view and freeze panes. 🙂

 

[hansrijf]

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.

 

[Sazar]

Yah, I would think the freeze panes option is what you're looking for as well.

 

[albybum]