is it possible in excel?

  • Thread starter Thread starter eusenet
  • Start date Start date
E

eusenet

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
 
I would create lines for all possible sub-categories of shopping, and then
group those rows, Data>Group & Outline, Group...

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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.

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top