Monthly Archives: August 2011

Protecting Excel worksheet cells against changes

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, when a new worksheet … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013 | Tagged , , | 1 Comment

Freezing headings in an Excel worksheet for easier scrolling

I don’t know about you, but I find it a great nuisance if I scroll down an Excel worksheet and cannot see the column figures as I often can’t remember to what the data refers. You can get Excel to … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013 | Tagged , | 1 Comment

Bringing slides from another presentation into Microsoft PowerPoint

When people have to include slides from another presentation in PowerPoint, they often copy and paste the slides from one presentation to another and then have great problems with the formatting. If you are using Office 2007, Office 2010 or … Continue reading

Posted in Microsoft PowerPoint | Tagged , | 1 Comment

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

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 the table, click the … Continue reading

Posted in Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013 | Tagged , , | 2 Comments

Creating a table of contents in Microsoft Word

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, Heading2 and Heading3 when … Continue reading

Posted in Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013 | Tagged , | 1 Comment