Blog

Outlook Reading Pane

Disabling the Word 2007 Mini-Toolbar

Excel Sheet Navigation

4Networking in Leeds East

Twitter - ReTweets

Twitter - Lists

Twitter - Mobile

Excel Paste Column Widths

PowerPoint Slide Master

Windows 'God Mode'

Excel Functions

Filling Alternate Cells

Microsoft Office Shortcut keys

Excel Negative Times

Word Reading Layout

Windows Shortcuts

Excel dropdowns

Quick sheet selection

Search files on Google

A - Z of Excel

Word 2003 to 2007

   Astradyne Blog/Tips and Tricks - Excel Dropdowns/Quick sheet selection

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.

 


Copyright ©2006-2013 Astradyne.com

vb training leeds, vba training leeds, excel vba, access vba, pc training in leeds, computer training in yorkshire, pc training in yorkshire, computer training in leeds, microsoft access vb, microsoft excel vb training, microsoft powerpoint training, microsoft training, microsoft word, office 2000, excel training leeds, access training leeds, office training leeds, office 2007, leeds vba, leeds visual basic, leeds training