Categorising expense items

M

mikesmac

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello,
I want to assig/categorise an expense type to all my current account payments. I would like to do this by assigning a standard expense to each item from a drop down menu. How to do this is the problem. I have tried List Manager but I think the standard list needs to be created each month on each worksheet. This seems awkward. Surely there is an easy way of doing this? Your help would really be appreciated.
Thanks
Mike
 
J

John_McGhie_[MVP]

Look up "Autocomplete" in the Help. Particularly the topic "Enter a series
of numbers, dates, or other items"

I think you will find AutoComplete quicker than a drop-down list.

Hope this helps


Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hello,
I want to assig/categorise an expense type to all my current account payments.
I would like to do this by assigning a standard expense to each item from a
drop down menu. How to do this is the problem. I have tried List Manager but I
think the standard list needs to be created each month on each worksheet. This
seems awkward. Surely there is an easy way of doing this? Your help would
really be appreciated.
Thanks
Mike

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
M

mikesmac

Thank you for the reply John but it does not appear to be there. Typing "Autocomplete" in the Help search results in "no results found". I am using Excel 2004 for Mac.
Regards
Mike
 
J

John_McGhie_[MVP]

Oh, trust me, it's there :) The topic I want you to look at is headed
"About storing and inserting frequently used text and graphics" ‹ I just
copied that out of the Excel 2004 Help.

I suspect you have not discovered that the OS 10.6 Help system tries to
click-jack everyone else's help these days, and you are not actually IN the
Excel help yet.

If you open the Apple Help, you then need to explicitly select "Excel help"
or all you get is the OS X help. A shatteringly stupid design, but that's
the way Steve Jobs made it...

Use the Help menu inside Excel...

Hope this helps

Thank you for the reply John but it does not appear to be there. Typing
"Autocomplete" in the Help search results in "no results found". I am using
Excel 2004 for Mac.
Regards
Mike

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top