We'd like to remind Forumites to please avoid political debate on the Forum. This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

Drop down lists in OO Calc

I've worked out how to do drop down lists now in Calc but can't find anywhere in the help menus that will tell me how someone could find an entry in the drop down list by typing the first initial of the word.

What I want to do is record the vouchers we give out, so have basic coloums with the number of the voucher, who it's for, the value of it and how it was paid for. So my drop down list for payment type would have for example, cash, credit card, debit card, bank transfer, cheque. I want to make it so that if you type the letter 'd' then debit card will come up and so on. Or any other way to avoid having to click on the down arrow on the right first.

The other thing is that in the column of cells that has the drop down list, the actual cell is empty, it's not until you click on the arrow that you see anything. What is supposed to go in that empty cell, and how do I do it? The actual column title is payment type so I don't need to put that. Or do I have to repeat it?

Sorry for all the questions!

Liz
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 348.2K Banking & Borrowing
  • 252.1K Reduce Debt & Boost Income
  • 452.3K Spending & Discounts
  • 240.7K Work, Benefits & Business
  • 617K Mortgages, Homes & Bills
  • 175.6K Life & Family
  • 253.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 15.1K Coronavirus Support Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.