Stupid Excel Question

saeltmarae2k

OSNN Addict
Joined
2 Jun 2004
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!
 

Mooz

Moozically Con~foozed
Joined
16 Jul 2002
Messages
126
the option you are looking for is called split and its on one of the view ribbons/

D
 

rushm001

In the beginning......
Political Access
Joined
21 Sep 2002
Messages
3,484
Freeze panes? Tis the same as in Excel 2003, click the little break thing in the scrollbar and then view and freeze panes. :)
 

hansrijf

sh! it stinks
Joined
12 Dec 2005
Messages
277
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

Rest In Peace
Joined
12 Apr 2002
Messages
14,905
Yah, I would think the freeze panes option is what you're looking for as well.
 

albybum

Penguin Rancher
Joined
9 Feb 2002
Messages
281
freezepane.jpg
 

Members online

No members online now.

Latest profile posts

Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?

Forum statistics

Threads
62,004
Messages
673,460
Members
5,599
Latest member
Larry Chris