Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Merged cell
Often on one of my workbooks I need to reference a cell from either another
workbook or worksheet. I usually have both workbooks open so I just hit the equal sign and click on the cell i want referenced. However when I do that when I am trying to reference a merged cell it automaticall pulls up a range of both of the merged cells and retuns a #value. Is there anyway to click on it and actually have it pull up a single cell instead of creating something like?: Sheet2!A1:B1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Merged cell
I can't repro this problem. I tried Excel 97 through 2003 since you didn't
mention your version. -- Jim "Mariano" wrote in message ... | Often on one of my workbooks I need to reference a cell from either another | workbook or worksheet. I usually have both workbooks open so I just hit the | equal sign and click on the cell i want referenced. However when I do that | when I am trying to reference a merged cell it automaticall pulls up a range | of both of the merged cells and retuns a #value. | Is there anyway to click on it and actually have it pull up a single cell | instead of creating something like?: | Sheet2!A1:B1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Merged cell
Not that I know of, although you can always adjust it afterwards.
Just another problem with merged cells. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Mariano" wrote in message ... Often on one of my workbooks I need to reference a cell from either another workbook or worksheet. I usually have both workbooks open so I just hit the equal sign and click on the cell i want referenced. However when I do that when I am trying to reference a merged cell it automaticall pulls up a range of both of the merged cells and retuns a #value. Is there anyway to click on it and actually have it pull up a single cell instead of creating something like?: Sheet2!A1:B1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Merged cell
I just tried this in xl2003 and the formula that excel build just used one
cell. But the way excel treats merged cells has changed since xl97. Until you upgrade, maybe you could just backspace after selecting that merged area???? (Not a pretty solution, huh?) Mariano wrote: Often on one of my workbooks I need to reference a cell from either another workbook or worksheet. I usually have both workbooks open so I just hit the equal sign and click on the cell i want referenced. However when I do that when I am trying to reference a merged cell it automaticall pulls up a range of both of the merged cells and retuns a #value. Is there anyway to click on it and actually have it pull up a single cell instead of creating something like?: Sheet2!A1:B1 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Merged cell
sorry, it is version 2002.
I have been just using the backspace. Which works fine for my personal use, but a few other people will be using this who have very little experience with excel. Perhaps I will just have to try and keep these cells seperate. "Mariano" wrote: Often on one of my workbooks I need to reference a cell from either another workbook or worksheet. I usually have both workbooks open so I just hit the equal sign and click on the cell i want referenced. However when I do that when I am trying to reference a merged cell it automaticall pulls up a range of both of the merged cells and retuns a #value. Is there anyway to click on it and actually have it pull up a single cell instead of creating something like?: Sheet2!A1:B1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Referencing a cell containing a graphic | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
Adjacent cell belong to same merged cell? | New Users to Excel |