|
Hi,
In this section I'll be including more tips and tricks, along with some advice and stories from the world of PCs.
You can set up a drop-down list in Excel using Validation.
Let’s say you want to choose from the values North, South, East, West. Type these values into a range, for example G1:G4, away from the input area for neatness. You can optionally hide the column once Validation has been set up.
Click in the cell where the choice is to be made (e.g. C2), and choose Data, Validation (2003) or Data ribbon, Data Validation in 2007.
In the ‘Allow’ dropdown, choose List. Click in the ‘Source’ box, and select the list, in this case G1:G4. Optionally, set an Input Message and/or an Error Alert in the tabs of the dialogue box. Click OK to finish.
Do you have a big Excel file, one that has lots of sheets?
I find that the little sheet scroll buttons are not easy to use, so I struggle to find the sheet I'm looking for.
Well, there's a very easy way to find a sheet. Simply right-click on the any of the little sheet scroll buttons, and a pop-up list of sheets appears. Click the name of the sheet you'd like, and you're taken there.
| 
Blog
