Automatically Add the Chapter Heading into a Documents Header

If you are working on a long document you may want to display each chapter heading in the relevant header. For example, to display chapter 1 in the header for pages 2 – 15 and then chapter 2 for pages 16 – 21 and so on.

You may have previously thought that this technique would require inserting multiple section breaks and using the Link to Previous option you get with Headers and Footers. This is how most training sessions and online tutorials approach this.

However Microsoft Word contains a fantastic feature that will enable you automatically insert each chapter heading into the relevant page header. This also means that the header can be updated when content is moved or changed. And all without a single section break. Continue reading

Excel Tips 2010 – Where is the Excel 2010 Data Entry Form?

The popular data entry form from Excel 2003 was removed from the Ribbon in Excel 2010. I am often asked where this feature went. So what is this feature and where can it be found? Find out in this Excel tips 2010 guide.

What is the Data Entry Form?

The Excel 2010 data entry form makes it easy to;

  • Add new records to a table
  • Edit and delete records from a table
  • Search for records in the table

The data entry form is very user friendly and is a must for anyone who performs alot of data entry, especially in a large table.

Continue reading

Locate the Locked Cells on a Worksheet

If you wish to protect the cells on a worksheet that contain formulas you will need to lock the cells first, whilst also ensuring that the cells users should be able to change are unlocked.

It may have been a while since you worked on this worksheet and you are not sure which cells are locked and which are not. You need a fast method of locating the locked cells. Let’s use Conditional Formatting to highlight the cells that are already locked so they are easy to identify. Continue reading

Unleash the Power of Excel’s CELL Function

A very powerful function in Excel that is unknown by many is the Cell function. Use the Cell function to find information about a cell. This can include the cell’s number format, row number or whether it is locked or protected.

There are times when this kind of functionality becomes extremely useful. Especially whilst Excel does not provide many other means of finding the number format of a cell, or whether it has been locked. Continue reading

Use Sections in PowerPoint 2010

Sections is a new feature to PowerPoint 2010 making it easier to organise and manage the slides of your presentation. By adding sections to your presentation you can group slides under meaningful names. This makes it easier to work with the slides of a large presentation as each section can be hidden and shown as and when required.

Sections can also be used for better collaboration with other members of your team. Ownership amongst a team can be distributed by section rather than a selection of slides. Continue reading

Change the Default Paste Setting in Word

When pasting data from another program such as the Internet into a Word document, it is normally a good idea to paste as unformatted text. This removes any source formatting from the copied text.

This can be achieved by using Paste Special rather than a normal paste or Ctrl + V. However if you regularly copy data from the Internet into a Word document you might find the need to use Paste Special each time quite irritating.

Fortunately Word provides a way for you to change the default paste setting for when pasting data between programs. Continue reading

Highlight Dates Over 30 Days Old

I was asked yesterday how to highlight dates that were over 30 days old. The situation was that the date of a transaction is recorded and the team need to be alerted when that date is older than 30 days.

Because they wish to highlight the cell, Conditional Formatting will be used. A new rule will be created with criteria to find those dates older than 30 days. Continue reading

Excel Fixtures and League Table Generator

Due to popular demand I have created an Excel fixtures and league table generator.

Following on from my fixture list creator and league table generator files, I was asked to create a combined file to create a fixture list and also generate a league table from results entered.

Download the Excel fixtures and league table generator.

To use the file;

  1. Enter the teams competing and how many times they will play each other on the “Teams” sheet
  2. Enter the results from fixtures on the “fixtures” sheet
  3. View the league table on the “League table” sheet