|
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.
If I’m searching for files on the internet, I can restrict my search to specific files, such as Word documents, Excel spreadsheets, and PDFs.
To do this, we use the Google search keyword ‘filetype’.
For example, say I’m looking for one of those football quizzes on an Excel sheet.
In Google, I’d type
football quiz filetype:xls
What about a list of Oscar winners in PDF?
oscar winners filetype:pdf
I (and many others) use the Reading Pane in Outlook for a preview of emails. I also use the fact that a message is 'unread' as a sign that I need to perform some sort of action on/to it.
I know that I and others find it very annoying that Outlook automatically marks any message displayed in the Reading Pane as read.
Fortunately, we can stop this behaviour.
In Outlook, from the menu, choose Tools, Options, and then go to the 'Other' tab. Then click the button marked 'Preview Pane' or 'Reading Pane' (depending upon your version of Outlook).
Remove the tick from the 'Mark items as read when viewed in the Reading/Preview Pane' option, and click OK, then OK again.
Now, you can preview a message while still leaving it 'unread'
| 
Blog
