Sheet reference

Resolved · High Priority · Version 2007

Thu 10 Jan 2013, 18:31 Delegate Reema said...

Reema has attended:
Excel Introduction course
Excel Intermediate course
Excel VBA Intermediate course

Sheet reference

I have referenced a large number of cells in one column to Sheet A, but they should refer to exact cells in sheet B, how can I change Sheet A to sheet B maintaining the cell reference?

Fri 11 Jan 2013, 10:08 Trainer Gary said...

RE: Sheet reference

Hi Reema

Thanks for getting in touch.

This is easiest achieved with Find and Replace. Highlight the cells that need to change, and on the Home ribbon select Find & Select > Replace.

In the box "Find What" type "Sheet A" (without quotes). In "Replace with" type "Sheet B". Click Replace All and the substitutions will be made for you.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips

Sheet reference

Sheet reference

RE: Sheet reference

Excel articles

Excel tip:

Display Formulas Instead of Results in Excel 2010