advanced excel courses - two more work sheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

resolvedResolved · Low Priority · Version Standard

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.

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

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips


Server loaded in 0.09 secs.