grouping

[tvi]

Hi
i'm new to Excel previously a quattro-pro user. Can any one tell me if it is posible in Excel to group a number of pages together ie for monthly statements, then name the sheets as a notebook ie Income January and summarise the totals on a separate sheet. i assume this would be possible as it is a relatively simple task BUT i don't know the right commands for Excel. Can any one help

Thanks

tvi

[PDuPre']

On 2002-05-15 02:14, tvi wrote:
Can any one tell me if it is posible in Excel to group a number of pages together ie for monthly statements, then name the sheets as a notebook ie Income January and summarise the totals on a separate sheet.

In Excel each workbook contains multiple worksheets. It sounds like when you say "pages" we would say "worksheet" (or "tab"). When you say "notebook" I think we would say "workbook". At the bottom of the screen in Excel you will see the different tabs that refer to different spreadsheets. Each one can have a different name. You can insert worksheets to your workbook, copy them, move them, etc.

So, if you already have a workbook with multiple worksheets I would simply select all the worksheets you want (hold CTRL and click on each tab or worksheet) and then click the right mouse button on one of the worksheet names to bring up a menu. Select move or copy on the menu and follow directions. Simply copy them to a new workbook and save that workbook as Income January.

To summarize totals on another worksheet, simply insert a worksheet and name it Summary. Create the format, etc. for the summary sheet and then in the cell you want to add the values from the other worksheets press = and then click on the first cell you want to add. For instance, click on sheet1 cell A1. Then hit + and the second cell you want to add. In this case, sheet2 cell A1. Repeat for everything. If the cells are all uniform then you can copy the formula down one cell and it will repeat the formula, but for one cell below those initally selected.

I hope that is what you wanted.

Philip

[ This Message was edited by: PDuPre' on 2002-05-15 04:44 ]

[ This Message was edited by: PDuPre' on 2002-05-15 04:45 ]