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
excel software training london - linked spreadsheets inserting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - Linked spreadsheets - inserting columns

excel software training london - Linked spreadsheets - inserting columns

ResolvedVersion Standard

Kate has attended:
Excel Advanced course

Linked spreadsheets - inserting columns

Hi,

When I insert a column into a spreadsheet that is linked to another spreadsheet, the second one does not adjust its formulae to allow for the extra column. Is it possible to keep adding columns and have linked spreadsheet automatically adjust itself?

Thanks,

Kate

RE: Linked spreadsheets - inserting columns

Hi Kate

Thanks for your question.

I think it depends which version of Excel you are using - if you are using 2003 then formula results should automatically update themselves when extra columns or rows are inserted.

If the formulas are not automatically updating themselves then I'm afraid you might have to manually adjust the formulas yourself each time new columns are added in.

Amanda

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

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.