linking cells

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

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

Linking cells

resolvedResolved · Low Priority · Version 2003

Nasif has attended:
Excel Advanced course

Linking cells

I am trying to link cells(with formula) in the opposite direction. for eg. If I have a range of formula which are horizontal across a row how do I link to those forumla horizontally down a column without referring to each cell manually? Thanks

RE: Linking cells

Hi Nasif

Thank you for your question; and welcome to the forum.

Can you please explain what the formula you are creating is doing, e.g. is the formula adding the cell range which is in the row?

Thank you in advance
Amanda

RE: Linking cells

Hi Amanda

Its simply linking cells in a spreadsheet.(trying to link cells which are displaynig horizontal data to display it vertically down a column)

For eg. if you have the months of the year across a row and data underneath each month, is there a way of linking the data down a column, so I could drag the column down and it would pick up the data across the row?

I have used the transpose function in the paste tools but am unable to link the actual cells. What I then have to do is reference each cell which can take alot of time.

Hope this makes sense.

RE: Linking cells

Hi Nasif

Thank you for clarifying this for me.

This is a tricky one - I will need to do some further research to find out if this is possible. I'll look into and let you know if I find anything that will help.

Amanda

RE: Linking cells

Hi Amanda

Any luck on this one?


 

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


Server loaded in 0.08 secs.