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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
linking multiple sheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Multiple sheets

Linking Multiple sheets

ResolvedVersion 2003

Dina has attended:
Excel Intermediate course

Linking Multiple sheets

doee the layout of the sheet you are trying to link have to be identical

RE: Linking Multiple sheets

Hello Dina, Thank you for your post and welcome to the forum, in answer to your question,

I am assuming that you are refering to the exercise on the Intermediate course where sheets are linked to create a 3D formula;

If this is the case then it is advisable to have the sheets consistent (the same) so that Excel will know that data in cell A3 on Sheet1 will be the same type of data on A3 in Sheet2, so that when you create a formula linking the sheets for example an =SUM( then the same data is going to be computed.

I hope that has helped, if so please click the resolved link, regards Pete

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.