Monthly Archives: September 2014

Centering a title over several columns in Microsoft Excel

Originally posted on ifonlyidknownthat:
When you start creating a worksheet you may not be sure how many columns you are going to use, so may just type a title or heading in row 1; once you have got your data…

Posted in Uncategorized | Leave a comment

Customising the Office 2007, Office 2010 or Office 2013 Quick Access Toolbar

Originally posted on ifonlyidknownthat:
Even when people have been using Office 2007, Office 2010 or Office 2013 for some time, if they have taught themselves, they often miss some of the features which will make them more productive. One of…

Posted in Uncategorized | Leave a comment

Conversation threads in Outlook 2013 on tablets/netbooks

If you are using email via Outlook 2013 and Windows 8 on a tablet, you may find that conversations are in a thread by default. If this annoys you, you can change the settings. With Outlook open, go to the … Continue reading

Posted in Microsoft Outlook 2013 | Tagged , | Leave a comment

Duplicating shapes in Microsoft PowerPoint

Originally posted on ifonlyidknownthat:
To duplicate shapes in PowerPoint: Draw the first shape and format it as required. Press Ctrl + D. Repeat for as many shapes as required. If you want to create a different shape but with the…

Posted in Uncategorized | Leave a comment

Protecting Excel worksheet cells against changes

Originally posted on ifonlyidknownthat:
If you apply protection to cells in a worksheet, the contents of the cells cannot be changed until the protection is turned off. Locking cells has no effect unless the worksheet itself is protected. By default,…

Posted in Uncategorized | Leave a comment

Keeping Microsoft Word table column headings on each page of large table

Originally posted on ifonlyidknownthat:
If you have a large table in Microsoft Word that is longer than one page, you may want to see the column headings on the top of each page. In Microsoft Word 2003 and earlier: In…

Posted in Uncategorized | Leave a comment

Creating a table of contents in Microsoft Word

Originally posted on ifonlyidknownthat:
A table of contents can be used to help you find your way through a long document by creating links to headings throughout your documents. Word can do this most effectively if you use styles Heading1,…

Posted in Uncategorized | Leave a comment

Microsoft Excel – entering weekdays into a worksheet

In Microsoft Excel, if you type in Monday, you can then use the Autofill handle to enter the rest of the days of the week. If you carry on dragging down, it will start again at Monday. However, what if … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – comparing two columns of figures using conditional formatting

Suppose I have sales figures for two years and I want to highlight this year’s figures in green if they are higher than last year’s figures and in red if they are lower than last year’s figures. Select the figures … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment