Thread: excel junkies?

I need an excel junkie. I consider myself to be pretty well informed when it comes to excel but I just got a file that I have a question about...

So you have normal columns and rows but then to the left of Column A there are 3 small buttons at the top. 1, 2 & 3...each button brings up different things...then below the buttons and to the left of the row numbers there are places where I can expand the data or show minimal...

I am wondering how this is done and then how I can modify it. It is not done through VB...and there are no macros...

what is this wonderful thing?


edited for horrible grammar

Are you using office 2007 or 2003? I have 2003, but I don't see what your talking about.

it is 2003 and I just figured it out...they had things grouped together.

Data > groups and outlines > group/ungroup.

It makes it so you can see certain information or not.

Thanks

Yeah, the sort of expandable-bullet-outline thing- pretty handy. Note that the default puts the "expander" below the selection, sort of "accounting style" but you can set it to be above the selection, so the group "drops down" when you expand it. I like it better that way- seems more intuitive to me... YMMV.


(Excel junkie... I picture this strung-out looking engineer down on his luck in the gutter... "C-C-Come on, man, just one more pivot table, p-p-please! They sent my job to Bangalore, the least you can do is let me do some bar graphs for you, m-m-mister!"

Originally Posted by RottnJP

(Excel junkie... I picture this strung-out looking engineer down on his luck in the gutter... "C-C-Come on, man, just one more pivot table, p-p-please! They sent my job to Bangalore, the least you can do is let me do some bar graphs for you, m-m-mister!"

that's about what I felt like. I can do pivot tables to know end, but I pretty much never group things so I completely forgot what it looked like...until I posted here

ALERT!

Someone has tried to register using the IP Address 121.207.162.127 which is MATCHED IN THE RBL DATABASE of the proxies.dnsbl.sorbs.net RBL.

This registration attempt has been allowed and the account has been permanently banned.

Registration Details: shcdi4Ggong ( sunglassestom@gmail.com )