
Printing - Multiple Pages from a single worksheet
Often when we are creating an Excel based report, we need to print various sections. If all the information is contained within one worksheet, creating a multi-page print-out can be quite a laborious process, especially if multiple copies are required. Excel allows you to select multiple areas within a worksheet at the same time and print them out. This is referred to as a “non-contiguous range” in Excel literature. To create a non-contiguous range, select the first area tha

Formulas not calculating
One problem that we are asked about on a fairly regular basis is to do with formulas not calculating in a spreadsheet. We will not go in to all the reasons why formulas are not calculating but will look at the two most common solutions to the problem (I would say that the two solutions are responsible for about 90% of the cases we see). Cells formatted incorrectly Cells that are not formatted as numbers will be ignored in any calculation in Excel. In the example below cell E