Tip 166 – Easily Change the Starting Page Number in your Excel Footers
DOWNLOAD PDF When you need to print an Excel worksheet with a footer which contains a page number starting at a value other than 1 you can do so. To set the starting page number, choose Page Layout and click the dialog launcher for the Page Setup dialog. Click the Page tab and, in the […]
Tip 158 – Quickly Sum Numbers in Excel
DOWNLOAD PDF To quickly add a column or row of numbers, click in the cell to create the total and press Alt + =. This automatically inserts a SUM function into the cell which adds the cells above or to the left of the cell.
Getting text into columns in Excel
If you use online banking, most banks allow you to download your bank movements or statements in Excel format, however usually the information is in CSV format and may not display in neat columns as we would expect it to. CSV stands for “Comma Separated Values” and is actually a file type that is often […]
Excel Borders and fill colours for cells
Excel displays information in cells, set out in a grid. Although the borders of these cells are visible on the screen, when you print Excel, these gridlines don’t usually print. Here are two ways show the outlines of cells on a printed sheet. Although Excel does provide a way to print the gridlines, a better […]
Calculate dates in Excel
If you ever need to work out how many days, months or years are between two dates, Excel is an excellent tool to use. Excel has a couple of formulas especially used for working with dates, which we will look at now. Excel stores dates as a number rather than a date, so it’s important […]
Freeze columns & rows in Excel
If you have created a database or list in Excel, once you have entered several rows of data, you will soon notice the first row in Excel is no longer visible – which can be a problem if you rely on column headings to know what each column contains. It is always good practise to […]
Make a chart in Excel
Charts are an excellent way to display data in a visual way and bring it into context. Although charts are more common place in the business world, we can still use charts to analyse expenses or even track our weight, so here is how you do that in Excel. It’s important to choose the right […]
Calculate times in Excel
At some point you will need to work out the difference between two times or sum up a list of times. Adding up hours and minutes separately is time consuming even with a calculator, so Excel is a natural choice for this job, once you know how. Calculating times in Excel is relatively easy, and […]
Absolute & Relative cell references in Excel
Although Excel may not be used as heavily in the home as it is in the business, learning this fundamental tip about cell references in formulas will help you avoid mistakes when creating Excel formulas. Absolute & Relative References are important to know if you copy and paste cells that contain formulas, which is what […]
Conditional Formatting in Excel
Conditional formatting is a feature from Excel that allows you to automatically format a cell based on its contents. For example a cell could show a red fill colour if its contents are below a certain amount, or green if it’s over a certain amount, and automatically update if the value in the cell changes. […]
