Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2007

Tip: Looking for answers? Try searching our database.

is it possible in excel?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
eusenet - 17 Feb 2007 11:44 GMT
Hi,

I'm new to excel, perhaps someone will help me.
What I want to do is to make a monthly expences list. At the moment got sth
like this:

FEBRUARY
---------------------------------------------------------------
days                           1       2       3       4       5       6
....
---------------------------------------------------------------
Shopping                   60$                     20$
Entertainment
Books                                  15$
....

What I want to do is to divide some categories on a subcategories, to make
it look like

FEBRUARY
---------------------------------------------------------------
days                           1       2       3       4       5       6
....
---------------------------------------------------------------
Shopping                   60$                     20$
     food                    20$
     clothing                35$
     others                   5$
Entertainment
Books                                  15$
....

This is simple, BUT I'm not capable to do something like drop down menu,
like when you click on "Shopping" drop list appear, there's possibility to
fill cells
AND hide them when they are not needed at the moment (to look like my first
graph)

What is important for me, there needs to be possibility to edit drop list,
to make
it easy adding news subcategories

Is this possible to do in Excell?

thanks
Peter
Bob Phillips - 17 Feb 2007 12:02 GMT
I would create lines for all possible sub-categories of shopping, and then
group those rows, Data>Group & Outline, Group...

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 42 lines]
> thanks
> Peter
eusenet - 17 Feb 2007 12:13 GMT
>I would create lines for all possible sub-categories of shopping, and then
>group those rows, Data>Group & Outline, Group...

perfect! thanks a lot
Sandy Mann - 17 Feb 2007 13:42 GMT
I don't know if this is what you are looking for but highlight a number of
unused cells under the Shopping label, (insert then if need be) and then
select Data > Group and Outline > Group.

You can then hide/unhide the rows by the + or - buttons that will be
created.

The Shopping Total can be the SUM() of the grouped cells below the Total.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Hi,
>
[quoted text clipped - 42 lines]
> thanks
> Peter
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.