Sheet Names in Formulae

hmyers · May 9th, 2002, 08:45 AM

You're working on a sheet, say "sheet 1", and have a formula on that sheet which includes a cell on the same sheet. Why do I sometimes see that instead of showing A1 in the formula, it shows 'Sheet 1'!A1, as if it were picking up from another sheet?

Aladin Akyurek · May 9th, 2002, 09:04 AM

Quote:

On 2002-05-09 07:45, hmyers wrote:
You're working on a sheet, say "sheet 1", and have a formula on that sheet which includes a cell on the same sheet. Why do I sometimes see that instead of showing A1 in the formula, it shows 'Sheet 1'!A1, as if it were picking up from another sheet?

One way that can happen is:

While entering a formula in a worksheet (WS1)you navigate to another (WS2) and return back to WS1, Excel will prefix the cells/ranges from WS1 with WS1!.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:45 AM	#1
hmyers New Member Join Date: May 2002 Posts: 8	You're working on a sheet, say "sheet 1", and have a formula on that sheet which includes a cell on the same sheet. Why do I sometimes see that instead of showing A1 in the formula, it shows 'Sheet 1'!A1, as if it were picking up from another sheet?