How can you tell cell data is linked?

  • Thread starter Thread starter Worksmart
  • Start date Start date
W

Worksmart

Hello, I'm using Excel 2003, and I'm manually adding shading to all linked
cells. I'm wondering if there is some trick to being able to tell when data
in a cell is linked.

Thanks in advance
 
Worksmart said:
Hello, I'm using Excel 2003, and I'm manually adding shading to all linked
cells. I'm wondering if there is some trick to being able to tell when data
in a cell is linked.

Thanks in advance
Click to expand...

Hi,

Try this "Ctrl+`" it will display all cell with formula press "Ctrl+`" to go
back to normal view.

Hope this help.
 
Ctrl+~ shows me all formulas. It might be that as soon as I paste the linked
data that shading the cells is the best idea.
 
Hi Rick, when I copy results in one worksheet and Edit, Paste Special, Link
to another worksheet.

Later, I'll forget because it's not obvious that the cell results are linked
to other worksheet.
 
Maybe this will work for you. Go to the worksheet you want to shade the
cells on, click Edit/Find on Excel's menu bar, put just the exclamation
symbol in the "Find what" field. If the Options button is showing two
greater than signs (>>), then click the button to open the options part of
the dialog... make sure "Sheet: is selected in the "Within" drop down,
"Formulas" is selected in the "Look in" drop down and that there is *NO*
check mark in the "Match entire cell contents" check box. Once the above is
all set, click the "Find All" button, then press Ctrl+A (this will select
all the cells shown in the table that appeared on the bottom of the panel),
click the "Close" button and, after the dialog box closes, all cells on the
worksheet with a reference to another worksheet should all be selected...
then just fill them by whatever means you currently do (that is, click the
Fill icon in the tool bar if it is displayed or use the Patterns tab on the
Format Cells dialog box).
 
I should point out that if any cells have quoted text where that text
contains an exclamation symbol, it will become selected even if the cell is
not linked to another sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unlink cells- how? 0
How do I use different colours in drop down menus in Excel 2003? 4
linking shaded cells 1
how do I link data between worksheets when data is transposed? 3
Displaying zeros in cells 2
How do I have a linked cell auto-size to fit the linked data? 2
Cond. Formatting, Mod(Row) and cell conditions 2
How to create absolue path link to another workbook (Excel 2003) 1

Back
Top