Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Opening workbooks on one screen

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel.training.course.london - Opening workbooks on one screen

Resolved · Low Priority · Version Standard

Reply Wed 21 Nov 2007, 10:01Delegate Ajay said...

Ajay has attended:
Excel Advanced course

Opening workbooks on one screen

Hi
Can you please tell me how I would work with 4 workbooks at once so I can see all 4 on one screen? Is that possible?

Thanks

For upcoming training course dates see: Pricing & availability

Reply Wed 21 Nov 2007, 13:15Trainer Sandy said...

RE: opening workbooks on one screen

Hi Ajay

If you go to the Window menu and select Arrange.., choose Tiled and OK.

Hope this helps.
Sandy

Excel articles

· Update Your VAT Rates In Excel
· Working Together Is Easier Than Ever With Excel 2010
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Conditional Formatting in Excel 2007
· How To Add A Second Axis To An Excel Line Chart

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips