Comparing Lists
Sometimes it is necessary to compare information that is contained in two lists to see if there is duplication in the two lists. To...
Excessive Rows (and/or Columns)
Have you ever opened a spreadsheet and noticed that there seems to be thousands of rows (and/or columns - we will only discuss rows in...
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...
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...
DOUBLE CLICKING TO A FORMULA
Double Clicking in a cell to take you directly to the source of data of the formula is possibly one of the most useful tricks available...
PASTE VISIBLE CELLS ONLY
Copying cells and pasting them in to visible cells can be a problem. This is a problem when you drag the cell contents down as well as...