To keep the column headings at the top of the screen while doing data entry, click in the cell that is in the row below, and to the right , or any column/row headings to be frozen. Click on Window/Freeze Panes. To remove, click on Window/Unfreeze Panes

File/Page Setup/Page tab – Select number of pages to fit or enlarge spreadsheet by percentage

File/Page Setup/Headers and Footers. Adjust using the preformatted headers and footers, or make a custom header/footer

Format/Column/Column Width – Type the column size in the highlighted box or Get the sizing handle at the right edge of the column heading (dark line with two horizontal arrows)/double click to size to fit or drag the sizing handle to the appropriate width

Select the cell range to be changed. Format/Cells/Borders tab – change as desired or use the border button on the toolbar. There are more options available through the menu than the toolbar

File/Page Setup/Margins tab – Select horizontal or vertical centering by clicking in the appropriate box

Select cell to be bolded, then click on the B on the Formatting toolbar or Control+B

A data form is used to allow easy manipulation of information in an Excel data list. While a list is small—for instance, when it fits on one screen—it is easier to enter or change information directly. When you start getting a larger number of records, then you may find using a data form to be easier. A…

The dollar sign ($) in a formula – Fixing cell references When you copy and paste an Excel formula from one cell to another, the cell references change, relative to the new position: EXAMPLE: If we have the very simple formula “=A1” in cell B1 it will change as follows when copied and pasted: Pasted…

Charts in Excel offer a graphic way to “see” data, but sometimes adding an extra element can add meaning to the information. This weeks Software Tips and Tricks shows how to add a horizontal line of values to a bar chart. This can help illustrate relative values on the chart. Here’s How 1.      Create or open…