Printing Tip

If your sheet has a lot of colour and you want to print it on a black laser printer, one of the Page Setup options can improve the print.

On the Sheet tab of the Page Setup dialog there is a Black And White option – see image below.

This removes all the colour and prints in black only,

You can access the Page Setup dialog from the Page Layout tab. Click the small arrow on the bottom right of the Page Setup section.

 

Data entry and calculating

In some large models Excel may calculate for a few seconds after you make an entry.

In most cases you don’t have to wait for Excel to finish calculating before you make your next entry.

Type your entries as fast as you like. Excel will finish calculating once you are done.

Creating a Book Index in Excel

A macro to simplify and speed up the process

My book was published just over four years ago and part of the writing process was creating an Index. To make the task easier I wrote a macro to assist me. Adding an Index to a large document can improve its usefulness. I am sharing the file I used in this blog post.

Validating Checkbox Linked Cells

Data Validation and formula options

When you create a checkbox you need to link it to a cell on a sheet to be able to use its result. The user could overwrite that linked cell with a value or text and affect formulas that are using the checkbox linked cell. You can add a validation to make sure the linked cell only contains TRUE or FALSE.