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...

Read More

Adding custom lists to Excel and OpenOffice.org

In the last post I demonstrated how to easily enter lists of numbers, days of the week and months of the year in Excel and Calc (the OpenOffice.org spreadsheet application). Both programs offer the option to add custom lists to this feature. In this post I will show you how to add the colours of the...

Read More

How to quickly enter lists in Excel and OpenOffice

Excel spreadsheets often have a column or a row of incremental data. That is, information in the form of a list of numbers (1, 2, 3, 4, etc), times (09:00, 10:00, 11:00, etc), the names of months or the days of the week. You could type all this information into the row or column yourself, or you can...

Read More

Customising the Quick Access Toolbar

In a recent post about adding buttons to the toolbars in Microsoft Office applications I pointed out that there is no way to add buttons to the new 'ribbon' that has replaced the old toolbars. Nevertheless, it has come to my attention that there is still one customisable toolbar in the latest versions of Word, Excel and Powerpoint. This is called the 'Quick Access Toolbar'. If you wish to add extra...

Read More

Printing from Excel - Part 2

In the last post I showed how to format an Excel sheet so that it fitted to the page and added page numbers. The end result as displayed in Print Preview is as shown here.As we can see there are no gridlines on the print. We can either remedy this by selecting border types on the table or, more easily,...

Read More

Printing from Excel - Part 1

Printing from Microsoft Excel is markedly different to printing from Word. Whereas in Word we can usually just tell it to print without worrying that much about formatting the page, in Excel we will usually have to specifically tell it how we want to print our speadsheets, and this can sometimes be...

Read More

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...

Read More

How to quickly enter lists of numbers, dates and times in Excel

Excel spreadsheets often have a column or a row of incremental data. That is, information in the form of a list of numbers (1, 2, 3, 4, etc), times (09:00, 10:00, 11:00, etc), the names of months or the days of the week. You could type all this information into the row or column yourself, or you can...

Read More

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...

Read More

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...

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 inIf you wish to edit the...

Read More