Excel Help Needed

msaquib

Hi,

I am trying to set-up a spreadsheet for work.

Can anyone advice me please how to set-up:-

1. Drop Down list dp I can choose what I need to enter
2. How to change lower case to upper case

Any help will be much appreciated.

Thanks
M

faz7875_2

msaquib wrote:

1. Drop Down list dp I can choose what I need to enter
2. How to change lower case to upper case

Ok,
1 What exactly are you trying to put in the drop down list? To create a basic drop down list, go to Data then Validate nand create your list. It really depends on how far you want to go though.

2 Use the UPPER command... i.e =UPPER(Cell) where cell is the cell(s) you want in upper case.

HTH:D