Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - Linked spreadsheets - inserting columns
Resolved · Low Priority · Version Standard
Kate has attended:
Excel Advanced course
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
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:Do a fast scrollIn big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle. |
We'll call during UK business hours
Server loaded in 0.08 secs.