Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel courses - Two or more work sheets

advanced excel courses - Two or more work sheets

ResolvedVersion Standard

Thu 31 Jan 2008, 12:57 Delegate Darren said...

Darren has attended:
Excel Intermediate course

Two or more work sheets

Please could you supply more information on split work sheets and the formulas for totalling years of account etc.

Sun 10 Feb 2008, 11:09 Trainer Stephen said...

RE: Two or more work sheets

Hi Darren

Thank you for your question

When you say split worksheets do you mean split panes?

If so then a split pane simply allows you to break the window into up to 4 different views, each showing a different section of a worksheet. To do this click on Window-Split, and then go to the required ranges in each window.

As to the second part of your question could you please clarify your requirements, so I can be more specific in my answer

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips

advanced excel courses - Two or more work sheets

Two or more work sheets

RE: Two or more work sheets

Excel articles

Excel tip:

Hiding a worksheet in Excel