Putting new buttons on toolbars in MS Office (before the 2007 version)

A while ago I published an article that suggested that rather than printing directly from web browsers, such as Internet Explorer, it is better to copy the information that you want into a word processor and print it from there. In that article I mentioned the use of the 'Paste Special' in Word, which enables you to remove formatting from the information that you paste. In this article I will explain how to put a button for 'Paste Special' onto the toolbar in Microsoft Word 2003 and other earlier versions. This technique can also be used to add any of the other available buttons onto any toolbar.

Open up Word and right-click on one of the toolbars, which are at the top of the screen below the menu and look something like this:


From the menu, select 'Customize...', which will open a dialog box. Click on the 'Commands' tab.


Select 'Edit' from the left-hand menu, because the 'Paste Special' tool is listed in the 'Edit' menu. Scroll down through the list on the right-hand until you see 'Paste Special' then left-click on it and hold the mouse button down. The mouse pointer should change to an arrow pointing at a rectangle with a square to the bottom right, which will have an X in it initially.

Move the pointer up to the toolbars and release the mouse button when it is in a suitable position: next to the normal paste button for example. You will notice that the mouse pointer changed appearance again when you hovered over the toolbar, with the X being replaced with a + to let you know that the new button can be placed there.

Your toolbar should now look something like this:

If you wish to remove a button from the toolbar, follow the instructions above for opening the 'Customize' dialog, but rather than drag from the dialog box to the toolbar, click on the button you wish to remove from the toolbar and drag it into the dialog box.

This process also works in the other Microsoft Office applications such as Excel and PowerPoint. With Office 2007, Microsoft have replaced the old tried-and-tested menu and toolbar arrangement with something called 'ribbons' (as pictured below) and there is no way to customise these in the same way as detailed above.

This is an edited version of a post that first appeared on Bloody Computer! on 19th November 2007.

Keyboard shortcut of the week: search and find

If you wish to bring up Windows' file search minimise all your windows and press F3. You can also search within a certain folder too: open that folder up in Windows Explorer (the name for the program that opens when you double click on 'My Documents', 'My Computer', etc) and - you guessed it - press F3.

Pressing F3 opens search dialogs in many other programs as well: in Internet Explorer it opens (and closes) the vertical search bar; in MS Outlook it opens up the 'Advanced Find' dialog. Try pressing F3 when using applications that have some sort of search facility.

In a similar vein, you can open up the find facility in many applications by holding down the Control ('Ctrl') key and pressing F. To explain the difference between search and find, consider that you will search for a web page and when you have opened it you can find text within it. In MS Word Ctrl + F opens the 'Find and Replace' dialog. As with F3, try it out in any program that has a find facility.

Of course some programmers use slightly different standards. For example in Firefox both F3 and Ctrl + F open the find word dialog at the bottom of the screen.

Happy hunting.

I can see clearly now...

Eye strain is a hazard to anyone who uses their computers for any extended period. So anything that eases the pressure on the eyes is a bonus. To this end, Microsoft have developed a tool for making text more legible called ClearType Tuner.

The ClearType Tuner only works on Windows Vista and XP, and is available as a web-based tool here. You will be required to choose which is the clearer text from a variety of options a couple of times, and then - hopefully - text should be clearer on your screen. Windows XP users can also download a Control Panel version from the Microsoft XP Power Toys page.

If you are a Vista user and wish to switch off ClearType check out Diana Huggin's instructions on the excellent Lockergnome site.

Keyboard shortcuts of the week: Faster word processing

Do you wish to be able to use your word processor more quickly? Do you want to be able to edit a piece of text without having to reach for the mouse every few minutes? Then this week's mega-selection of keyboard shortcuts are for you. They should work in any text editor on Windows, whether a word processor or a comments box on a web page. I have included a text box as part of this article so you can play around with the various key combinations. For those interested, the text in the box is the opening paragraph of Candide by Voltaire.

We will start with quick navigation links.

• The Home key will move the cursor to the beginning of the line (on most keyboards this key is in a collection of 6 keys located above the cursor keys).
• The End key will, unsurprisingly, move the cursor to the end of the line.
• If you hold down Ctrl and press Home, the cursor will move to the beginning of the document. Ctrl and End will take the cursor to the end of the document.
• The Page Up and Page Down keys do 'exactly what it says on the tin'; they move the cursor one page up or one page down.
  

You probably already use the cursor keys (the ones with arrows on) to navigate around your compositions, moving one character at a time. If you hold Ctrl and press the left or right cursor keys you can jump one word at a time, left or right.

You should now be able to whiz around your documents, but what about keyboard shortcuts for selecting bits of the text? To select, simply hold down the Shift key as well as the key combinations I already mentioned.

• Holding down Shift and pressing a cursor key will select one character to the left or right, dependent on which cursor key you press.
• Hold Shift and press Home to select the text from the cursor position to the beginning of a line. Shift and End selects the text from cursor to end of line. So, a quick way to select a line of text is to press Home, then Shift and End.
• Holding down Shift and Ctrl together and pressing Home will select all the text between the cursor position and the start of the document. Shift, Ctrl and End will select all the text between cursor and end of document.
  
• To select the whole document you could press Ctrl and Home to take you to the top, then Shift, Ctrl and End to select to end, but it is much easier to use the keyboard combination for selecting the whole of a text: Ctrl and A.
• Holding down Shift, Ctrl and pressing a cursor key will select one word left or right, dependent on which cursor key you press.
  

So, you can whiz through your document selecting chunks of text as you go. The last selection of key combinations in this article enable you to do stuff to the text.

• Hold down Ctrl and press C to copy the selected text.
• Hold down Ctrl and press X to cut the selected text - that is to copy it and delete it.
• Hold down Ctrl and press V to paste the copied text where the cursor is located.

Whereas, it is easy to remember the key combination for copy (Ctrl+C) the combinations for cut and paste are not so intuitive. When I first started using these particular keyboard shortcuts I remembered the cut combination because the X looks like a pair of scissors, and the V looks a little like an upturned glue pot (a little imagination is required I know).

Play around with all these key combinations in this text box.

In the country of Westphalia, in the castle of the most noble Baron of Thunder-ten-tronckh, lived a youth whom Nature had endowed with a most sweet disposition. His face was the true index of his mind. He had a solid judgment joined to the most unaffected simplicity; and hence, I presume, he had his name of Candide. The old servants of the house suspected him to have been the son of the Baron's sister, by a very good sort of a gentleman of the neighborhood, whom that young lady refused to marry, because he could produce no more than threescore and eleven quarterings in his arms; the rest of the genealogical tree belonging to the family having been lost through the injuries of time.

Some text boxes allow you to use 'rich text', that is, text that has extra formatting options such as bold, italic or underline.

• Hold down Ctrl and press B to make the selected text bold.
• Hold down Ctrl and press I to make the selected text italic.
• Ctrl and U will underline the selected text.
  

Thankfully all three of these are intuitive, so no need for imaginative mnemonics to remember them.

Faster word processing revisited

Do you wish to be able to use your word processor more efficiently? Would you like to be able to edit a piece of text without having to reach for the mouse every few seconds? If your answer is 'yes' then this selection of time-saving keyboard shortcuts are for you. They should work in any text editor on Windows (and possibly on other operating systems too), whether you are using a word processor or a comments box on a web page.

I have included a text box as part of this article so you can play around with the various key combinations. For those interested, the text in the box is the opening paragraph of Candide by Voltaire.

We will start with quick navigation links.

• The Home key will move the cursor to the beginning of the line (on most keyboards this key is in a collection of 6 keys located above the cursor keys).
• The End key will, unsurprisingly, move the cursor to the end of the line.
• If you hold down Ctrl and press Home, the cursor will move to the beginning of the document. Ctrl and End will take the cursor to the end of the document.
• The Page Up and Page Down keys do 'exactly what it says on the tin'; they move the cursor one page up or one page down.
  

You probably already use the cursor keys (the ones with arrows on) to navigate around your compositions, moving one character at a time. If you hold Ctrl and press the left or right cursor keys you can jump one word at a time, left or right.

You should now be able to whiz around your documents; but what about keyboard shortcuts for selecting bits of the text? To select, simply hold down the Shift key as well as the key combinations I have already mentioned.

• Holding down Shift and pressing a cursor key will select one character to the left or right, dependent on which cursor key you press.
• Hold Shift and press Home to select the text from the cursor position to the beginning of a line. Shift and End selects the text from cursor to end of line. Thus, a quick way to select a line of text is to press Home, hold down Shift and press End.
• Holding down Shift and Ctrl together and pressing Home will select all the text between the cursor position and the start of the document. Holding down Shift and Ctrl while pressing End selects all the text between cursor and end of document.
  
• To select the whole document you could hold down Ctrl and press Home to take you to the top; then Shift, Ctrl and End to select to end; however, it is much easier to use the keyboard combination for selecting the whole of a text: Ctrl and A.
• Holding down Shift and Ctrl and pressing a cursor key will select one word left or right, dependent on which cursor key you press.
  

So, you can whiz through your document selecting chunks of text as you go. The last selection of key combinations in this article enable you to do stuff to the text.

• Hold down Ctrl and press C to copy the selected text.
• Hold down Ctrl and press X to cut the selected text - that is to copy it and delete it.
• Hold down Ctrl and press V to paste the copied text where the cursor is located.

Whereas, it is easy to remember the key combination for copy (Ctrl+C) the combinations for cut and paste are not so intuitive. When I first started using these particular keyboard shortcuts I remembered the cut combination because the X looks like a pair of scissors, and the V looks a little like an upturned glue pot (a little imagination is required I know).

Play around with all these key combinations in this text box.

In the country of Westphalia, in the castle of the most noble Baron of Thunder-ten->tronckh, lived a youth whom Nature had endowed with a most sweet disposition. His face was the true index of his mind. He had a solid judgement joined to the most unaffected simplicity; and hence, I presume, he had his name of Candide. The old servants of the house suspected him to have been the son of the Baron's sister, by a very good sort of a gentleman of the neighborhood, whom that young lady refused to marry, because he could produce no more than threescore and eleven quarterings in his arms; the rest of the genealogical tree belonging to the family having been lost through the injuries of time.

Some text boxes allow you to use 'rich text'; that is, text that has extra formatting options such as bold, italic or underline.

• Hold down Ctrl and press B to make the selected text bold.
• Hold down Ctrl and press I to make the selected text italic.
• Ctrl and U will underline the selected text.
  

Thankfully all three of these are intuitive, so no need for imaginative mnemonics to remember them.

To further increase your productivity while using a word processor you can use your keyboard to access the application's menus too as detailed in this tutorial.

This is an edited version of a post that I originally posted on September 5, 2007.

MS Word: replace, reformat, rejoice

Here is the scenario, you have copied some text from somewhere and pasted it into Word; however, the text ends up looking something like this.

To see the cause of this problem, press the 'Show/Hide ' button. As shown, the original text has carriage returns - as indicated by the '' marks - at the end of the original lines. When this text was pasted into word the lines were no longer the same length, so, the carriage returns were in the wrong place.

The solution to this problem is to replace the carriage returns with spaces. You can do this manually, or use the replace feature in Word. To open the 'Find and Replace' dialog box, pull down the 'Edit' menu and select 'Replace' - you may have to click the double arrows at the bottom of the menu to display all the entries on the menu - or you could hold down the Ctrl key and press H.

Each special character has its own code associated with it. For the carriage return this is '^p', for Tab it is '^t' and so on (you can see them all by pressing the 'More' button on the 'Find and Replace' dialog box - this will display more options - and press the 'Special' button.

The text we are editing is broken into various paragraphs with an empty line between them. In order to maintain this separation of paragraphs, we need to mark all the places where one return follows another. I usually use two tildes '~' to mark these, because that rarely occurs in a text. Fill in the fields as below and press the 'Replace all' button.


A dialog box will be shown telling you how many replacements have been made. Press OK to close it. The text will then look like this...

With the separation of paragraphs marked we can now remove all those superfluous returns. Enter '^p' in the Find what: field and a space in the Replace with: field.


Press 'Replace All' again and OK when you are told how many replacements have been made. The text will then look like this...

We need to return the paragraphs to their original form. To do this replace all the occasions of '~~' with two carriage returns, as in the following image. Again, press 'Replace All'.


The text should now look like this. We are very close to what we want, except that there are some superfluous spaces in the quote at the bottom.

To remove these, go to the 'Find and Replace' dialog box again, and enter two spaces in the Find what: field and one space in the Replace with: field. Keep pressing the 'Replace All' button until there are no more examples to replace. The text should now look like this: nicely formatted with all the separate paragraphs maintained.

How to copy charts into a word processor

When copying charts into a word processor, whether in Microsoft Office from Excel to Word or in openoffice.org from Calc to Writer, the software embeds a special object that links back to the original spreadsheet. If you then change the details in the Excel spreadsheet the chart in the Word document will change accordingly. In many cases this is advantageous; however, it can cause problems if the Word document cannot 'see' the Excel file, for example, if you email the Word file to someone without the Excel file. It is generally better to paste the chart as an image in the first place using the 'Paste special' facility.

I will start by explaining how to do this in Microsoft Office:

Once you have created your chart in Excel you select it and copy it, as shown here.


In older versions of Word you pull down the 'Edit' menu and select 'Paste Special'. You may have to wait a moment for all the menu items to be revealed.


In the latest versions of Word, 'Paste special' is in a menu underneath the 'Paste' button.


A box will open, from which you select 'Picture (Enhanced Metafile)', and click OK.

This will then insert the chart as a picture, which you can manipulate like any other imported image.
In openoffice.org, the procedure is pretty much the same as above, with 'Paste special' is in the 'Edit' menu, or alternatively you can use a keyboard shortcut: Ctrl + Shift + V. The major difference from above is that the following box will open when you select 'Paste special'. Simply select 'Bitmap' and click OK to paste the chart as a picture.

Multiple Series of Page Numbers

Sometimes a MS Word document requires separate numbering systems for different sections. The introduction may have to be numbered with Roman numerals (i, ii, iii, etc), while the main body of the text may require normal Arabic numerals (1, 2 3, etc). There is a way of achieving this in Word without having to save the different sections as different files.

To start, you have to let Word know that the text is split into different sections. To do this, move the cursor to the end of the first section. To mark the end of that section pull down the 'Insert' menu and click on 'Break...' This will open a dialogue box offering a variety of breaks that you can insert. Select 'Next page' from the 'Section break types' list. Click 'OK' to close the dialogue box.

This will move the cursor onto the next page. To see the 'Section break' click on the 'Show/hide paragraph' toolbar button (pictured left). If you wish to add any text to the first section it must be put before this section break.


You can now add the page numbering. To do this we need to access the header or the footer (the areas above or below the text where the page numbers will go). In this tutorial the page numbering will be put in the footer. Pull down the 'View' menu and select 'Header and Footer'. Notice how the text turns grey, how two boxes appear on each page, and the appearance of a 'Header and Footer' toolbar. Click inside the footer for Section 1 and then on the 'Insert Page Number' button on the toolbar (shown right).

You will see that page numbers are now shown in the footer. You can align page numbers as if they were normal text. To change the format to Roman numerals click the 'Format Page Number' button (shown left). A dialogue box will open, pull down the 'Number format' list, select 'i, ii, iii, ...' and click on 'OK'.

You now need to reformat the numbers in the second section. Move down to the section 2 footer and click inside it (you will notice that the page numbers are still in Arabic numerals in this footer). Click on the 'Number format' button and in the 'Page numbering' section select 'Start at' and make sure the number is '1'. Click 'OK'.


To finish click the 'Close' button on the 'Header and Footer' toolbar.

Putting new buttons on toolbars in MS Office

A while ago I wrote an article that suggested that rather than printing directly from web browsers, such as Internet Explorer, it is better to copy the information that you want into a word processor and print it from there. In that article I mentioned the use of the 'Paste Special' in Word, which enables you to remove formatting from the information that you paste. In this article I will explain how to put a button for 'Paste Special' onto the toolbar in word. This technique can also be used to add any of the other available buttons onto the toolbar.

Open up word and right-click on one of the toolbars, which are at the top of the screen below the menu and look something like this:


From the menu, select 'Customize...', which will open a dialog box. Click on the 'Commands' tab.


Select 'Edit' from the left-hand menu, because the 'Paste Special' tool is listed in the 'Edit' menu. Scroll down through the list on the right-hand until you see 'Paste Special' then left-click on it and hold the mouse button down. The mouse pointer should change to an arrow pointing at a rectangle with a square to the bottom right, which will have an X in it initially.

Move the pointer up to the toolbars and release the mouse button when it is in a suitable position: next to the normal paste button for example. You will notice that the mouse pointer changed appearance again when you hovered over the toolbar, with the X being replaced with a + to let you know that the new button can be placed there.

Your toolbar should now look something like this:

If you wish to remove a button from the toolbar, follow the instructions above for opening the 'Customize' dialog, but rather than drag from the dialog box to the toolbar, click on the button you wish to remove from the toolbar and drag it into the dialog box.

This process also works in the other Microsoft Office applications such as Excel and PowerPoint.

Keyboard shortcut of the week: The Case of MS Word

When using a word processor it is quite common to forget that that the CapsLock key has been left on, or you might decide that a piece of text looks better in capital letters (also known as upper case: small letters are known as lower case).

Thankfully MS Word has a keyboard shortcut that lets you cycle between different cases and formats. All you need to do is highlight a piece of text, hold down the Shift key and press F3.

Each time you press F3 the case of the letters will change (don't release the Shift key!). So, 'testing' will be replaced with 'Testing' on the first press, and 'TESTING' if you press it a second time. Press F3 again and the text will return to 'testing'.

If you type 'tESTING' by mistake, you can change it to 'testing', then 'Testing', and 'TESTING'; however, it will not return to 'tESTING', probably because it is highly unlikely you'd ever want text to be in that format.

[Addendum]

As one commentator has pointed out, a particular word does not need to be highlighted to have its case changed by this method, all you need to do is have the cursor somewhere within the word. If you wish to change the case of several words then you have to highlight them all. Thanks to A. for this clarification.

Recovering text from Word documents (Part 1)

If Microsoft Word runs into a problem with a file it usually offers a recover option when you open the program the next time. But sometimes this option is not given to you, and you have to try to recover text from a corrupted file manually.

To do this pull down the 'File' menu in Word and select 'Open...' to see the appropriate dialog box. From the 'Files of type' drop-down list select 'Recover Text from Any File'. Then browse to the file you wish to try to recover text, select it, and click the 'Open' button. With any luck Word will extract the text from that file. This process may work with files of types that Word does not support too.

In the second part of the article I will look at what to do if this method fails.

Keyboard shortcut of the week: Sub and super

Occasionally we have to make use of subscripts or superscripts in our documents. The most common use of these is with dates, as in 20^th. There the 'th' is a superscript; that is, smaller text that is raised. Subscripts are most often used in technical language such as if we refer to water as H₂O. There the subscript is the '2'; smaller text that is lowered.

To switch to subscript mode or to change the selected text to a subscript, hold down the Control key and press the = key. This same combination will also set selected subscript text back to normal and switch out of subscript mode, as with the keyboard shortcuts for bold or italic mode.

To switch to superscript mode or to change the selected text to a superscript, hold down the Control key and the Shift key, and then press the = key. As with subscripts the same combination switches back to normal text to if presses again.

This tip applies to Microsoft Word and PowerPoint, but unfortunately not to Excel.

Keyboard shortcut of the week: screen capture

If you wish to capture what you have on your screen as an image you can do so by pressing the Print Screen key (sometimes abbreviated to Prt Scr or similar) - on most keyboards this key will be found next to the F12 key, above the Insert key.

This will put an image of the screen into the 'Clipboard', which is the name for the "holding area" where windows keeps things that you have copied. You can then paste this image into any program that accepts pasted images, such as image editors or word processors.

Windows includes an image editor, called Paint, which is found in the 'Accessories' folder on the Start Menu program list. This application enables you to edit the screen image, should you wish to copy a section of it, or change its size, and save it as an image file.

Most word processors also include a few limited image manipulation features. In MS Word there is a toolbar that includes image manipulation tools, such as brightness and contrast adjustment, and a tool to crop the image. To show it, right-click on the image you wish to edit and click on 'Show Picture Toolbar'.

Using AutoText in Word

If there are things that you find yourself typing regularly, there is a way of increasing your productivity. By using Word's AutoText feature you only have to start typing a few letters of your name or postal address before it offers an option to fill the rest of the text for you. Word comes with a number of entries already set up. If you start to type the word 'Cordially', you should notice a little box appear like the one pictured below. As it says, just press Enter and Word will insert the rest of the text.

If this does not appear, you probably have AutoComplete switched off. To switch this on, and to see a list of all the existing AutoText entries, pull down the 'Insert' menu and from the 'AutoText' sub-menu click on 'AutoText...', which will open the following dialog box.


Make sure that 'Show AutoComplete selections' is ticked. You can also create a new AutoText entry with this dialog by typing the text where indicated and clicking the 'Add' button; however, there is an easier way to do it.

Click on 'OK' to close the dialog box and in your current word document type your name. Select the text and either pull down the 'Insert' menu, then the 'AutoText' sub-menu, and click on 'Add...' or simply hold down the Alt key and press F3. You will then be asked to give the new AutoText entry a name.


From now on when you start to type your name you will be offered the option to insert it as with 'Cordially'. The advantage of entering new AutoText this way is that you can insert text that spans several lines like your postal address. All you need to do is type it in select it and press Alt and F3, as before. You can even add pictures to AutoText by selecting them along with some text or on their own and following the above instructions.

How to compress images in Word and Powerpoint

Inserted images in Word and Powerpoint may appear small, but they are actually stored as their original size unless compressed. This can cause printing to take a long time and needlessly increase file sizes. Thankfully there is a way to compress images in both these applications.

Office 2000, XP and 2003

Open the view menu and select 'Pictures' from the 'Toolbars' sub-menu. The picture toolbar, as shown below, should appear.

Click on the 'Compress pictures' icon (highlighted in orange on the above picture).

This opens the following window.


Select 'Web/Screen' for the highest level of compression, or 'Print' for a lower level. Make sure that 'Apply to' is set to 'All pictures in document', and click 'OK'.

You may then receive the following warning. If you do, click the 'Apply' button.



Office 2007 and 2010

Click on any image to enable 'Picture Tools', and click the 'Format' tab shown below.


Click the 'Compress Pictures' button (highlighted in orange on the above picture), to open the following window.

Select whichever level of compression best suits your purposes. Make sure that 'Apply only to this picture' is not selected, and click the 'OK' button.

How to print two pages per sheet

Cutting down on the amount of paper used in printing not only saves money, but is also more environmentally friendly. Some applications offer the option of printing multiple pages per sheet of paper. In this post I will show you how to print two pages per sheet in MS Word and Adobe Acrobat Reader.

MS Word
Open the print dialogue from the 'File' menu in older versions of Word, or by clicking the Office Button in newer versions (as shown below).


Simply set 'Pages per sheet' to '2 pages' and click 'OK'.



Adobe Acrobat
Open the print dialogue from the 'File' menu.
Change 'Page Scaling' to 'Multiple pages per sheet' and 'Pages per sheet' to '2'.



OpenOffice
I found no easy way to print two pages per sheet in OpenOffice, but you can save the file as a pdf using the 'Export as PDF' tool in the 'File' menu and then open it in Adobe Acrobat and follow the above instructions.

More spelling and grammar information from Word

I doubt many people do not make use the spellchecking facility in MS Word. Most people probably run a grammar check too. Nevertheless, few people will use Word's readability statistics report.

To switch this report on, open the 'Tools' menu in Word and click on 'Options', select the 'Spelling & Grammar' tab, tick the 'Show Readability Statistics' box, and click 'OK'.


Now, when you click on the 'Spelling and Grammar' button (shown left), Word will go through any errors it finds in the selected text, or the whole text if none is selected, and then it will show you the 'Readability Statistics' report.


This report is particularly useful to anyone who wishes to make their writing more legible. The report not only contains general information about the number of words, characters and sentences etc, but also the average number of sentences per paragraph, words per sentence and the like.

The bottom section includes three very useful measures. The first gives a percentage of the number of passive sentences in the selected text. As you may know, the active voice makes a text more readable, so it is best to avoid the passive voice when possible. There is a good tutorial about the difference between the voices here.

The second and third measures, the Flesch reading ease and the Flesch-Kincaid grade level, show how difficult a text is to comprehend according to mathematical equations. More details on these equations and an explanation of the scales are available here.