Keyboard shortcut of the week: help!

Just about every Windows application has a help file, or at least connects you to a webpage that provides help. Nevertheless, users with problems frequently forget about the help file. Often - as with the Microsoft Office products - these help files are searchable and sometimes even include tutorials.

You can access the help file for any program (or indeed for Windows itself) by pressing the F1 key.

So, before you seek the advice of a techie or search the web for help, hit F1.

Read More

Print the web and save the world

Web browsers such as Internet Explorer and Firefox are notoriously bad at printing. You can end up with many disparate pages with sidebars and parts of images on, you have no idea how many pages are going to come out, and you use more paper than you need; which, can't be good for the environment - let alone your finances.

This is not the fault of the browser programmers, but rather, it is 'the nature of the beast.' One of the advantages of web pages is that they are not subject to the limitations of the printed page. Many web programmers are kind enough to supply a printable version of their pages. [I must find a way of adding them to this blog... maybe using the RSS feed...] Anyway, if there is no link to a 'printer friendly version,' then the best thing to do is to copy what you want and paste it into a word processor, which will then bypass all the problems mentioned above.

You can select the information you want by clicking and dragging with the mouse, although, this can be an irritating process, as your selection often randomly includes images that you don't want. When pasting into your word processor, you can make your life easier by using 'Paste special;' which, you should find in the 'Edit' menu. This will give you a selection of text formats.

If you just want the plain text from the web page and not the images, then select 'Unformatted text.'

If you wish to print both images and the formatted text, that is, keeping the same font used on the web page as well as any text that is bold or italic, then select 'Rich text format' (unfortunately this option is not available for text copied from Firefox.)

Avoid 'HTML format' as this will attempt to reconstruct the web page as a word processed document, often recreating the problems that you were trying to avoid. This option often takes a while to complete too.

You are then free to edit the text to your heart's content. You can change font sizes and remove 'white space' to save paper. You also have the option of adding your own notes to the text. So, reduce your printer output and save the world today.

Read More

"Can you hear it?" Three Freeware Audio Applications

Winamp has long been a popular mp3 player developing a large user community. Members of this community submit a plethora of skins, plug-ins and other add-ons to the Winamp website. Winamp also offers support for iPods and other mp3 players, and functions as an adequate video player.

If you have ever made an audio mix CD from mp3 files, you have probably been annoyed to find that all the tracks play at different volume levels, spoiling that overall ambiance you wished to create with your selection of top tunes. If this problem is a source of vexation for you, try mp3gain. With this program you can quickly balance the levels of a selection of mp3 files, so as to further impress that prospective partner, work colleague, or friend with your eminently good taste.

The best freeware audio editor available is Audacity. It provides support for mp3 files - as well as a number of other formats - and offers enough editing features and effects to meet most user's needs. Unfortunately, Audacity does not support proprietary formats such as wma, but there are plenty of audio file converters available like dBpoweramp.

Read More

Keyboard shortcut of the week: Excel

Following on from the megapost of word-processing keyboard shortcuts from earlier this month, here is a selection of keyboard shortcuts for Microsoft Excel.

• You can navigate around the grid of cells by using the cursor keys.
• Hold down Ctrl and press Home to jump to the top right cell (A1).
• Hold down Ctrl and End to jump to the last cell on the spreadsheet with any information in
  
• If you wish to edit the contents of a cell press F2
  

As with word processing, you can hold down the Shift key to select: if you hold down Shift and press the right cursor key then you will select the current cell and the one to the right of it. If you continue to hold down the Shift key and press the down cursor key you will also select the two cells below the ones you already had selected. You can thus hold down the Shift key and press different cursor keys to select different rectangles of cells.

Many of the keyboard shortcuts that work for word processing also work in Excel: holding down Ctrl and pressing B selects bold text; Ctrl and C will copy text, etc.

Read More

Word to the wise: webmail woes

This is an issue that has cropped up a couple of times at the university where I work.

If you send yourself a document that you are working on, to continue working on it on another PC, remember to save the attached document onto that machine before you start to make changes to it. It is easy to forget this, open the document and start making changes. If you then hit the save icon it will not always save and when you then close whatever program you are editing the document in, your changes will be lost. This is particularly the case for documents accessed via webmail. If you remember to 'Save as' rather than just 'Save' you will be OK, because it will prompt you for a name and location where you wish to save it. Nevertheless, it is better to get into the good habit of copying the document you attached to the email onto the PC before you expend effort making alterations.

Read More

Weekend website: What is this file?

So here is the scenario: you have been sent a file attached to an email. You double click on it - after making sure that it is not a virus or some other malicious file - and you are told that it is an 'unknown file type'. You need to find out what type of file it is, and what programs will open it.

To do this you look at the last few letters after the last '.', e.g. word documents will end with '.doc' (you may not see these extensions for file types that your installation of Windows recognises - to see them: double click on 'My Computer'; select 'Options' from the 'Tools' menu; select the 'View' tab and deselect 'Hide extensions for known file types'.)

So you know what extension the file has, but still don't know how to open it. There are a number of web sites that provide lists of know file extensions. All offer a search tool, so you can just type in a file's extension and find out what programs you need to open it. So here are a few such sites:

• Wotsit.org (my personal favourite)
• FILExt
• file-extensions.org

Check out this post for details of a website that will convert files to a type that you may be able to open with your existing software.

Read More

Keyboard shortcut of the week: Firefox

This week's keyboard shortcuts are all for Firefox - some of them may work in Internet Explorer. Recently, Microsoft have started copying features previously implemented by Mozilla in Firefox, possibly including the keyboard shortcuts. Please let me know which ones work in IE.

To cycle through your tabs rightwards: hold down Ctrl and press the Tab key.

To cycle through tabs leftwards: hold down Ctrl and Shift and press the Tab key.

To open a new tab: hold down Ctrl and press T.

To close the current tab: hold down Ctrl and press W.

To jump to the address bar - where you type in a web address: Press F6 (thanks to glytch for this one).

To open and close the Bookmarks tab: hold down Ctrl and press B (Note: if you are in a rich-text editor on a webpage this will select bold text instead.)

Read More