vert line

A Mesa workbook can contain up to 256 separate worksheets within it. Each worksheet has a name, shown on the TAB at the top of the workbook. The first worksheet is called "Sheet 1", the next "Sheet 2' and so on.

You never have to use more than one worksheet, if you don't want to. But it can make your life easier if you organize your work into separate sheets.

Example:

The Head Office of a multinational might use a separate worksheet to hold the sales figures for each country they deal with, and have a 'front' worksheet to total up all the figures.

To change the name of a worksheet to something more meaningful, just double-click on the TAB name and type in the new name you want. You can use formulas to refer to cells in other worksheets. You can either use the mouse to 'click and select' the sheet and cells you want, or simply type the full cell reference yourself.

To refer to a cell on a different worksheet, put the sheet name and a '!' (bang) before the cell reference. For example: ="Japan"!A23*25% ="Japan"!A23+"France"!A23+"USA"!A23 If you change the name of a worksheet, all formulas referring to that sheet will automatically update and use the new name.

 

Also go to:

Index help

Contents help