G
Guest
Is it possible to link fill format as well as values between two cells in different sheets.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
Not without vba, though you can use a picture link to paste a *picture* of the
cell reference in your other sheet. This would have all the formatting, but
would not be a real piece of data that you could actually link anything else to.
To do this though, you would simply copy the range in question, then hold SHIFT
down and use Edit / Paste Picture Link (This option only appears when you hold
down shift).
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------
cell reference in your other sheet. This would have all the formatting, but
would not be a real piece of data that you could actually link anything else to.
To do this though, you would simply copy the range in question, then hold SHIFT
down and use Edit / Paste Picture Link (This option only appears when you hold
down shift).
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------
different sheets.Tom W said:Is it possible to link fill format as well as values between two cells in
D
Dave R.
Very cool Ken. Is there a list of such hidden goodies somewhere, if there
are others?
are others?
K
Ken Wright
Very possibly, but not that I know of I'm afraid. Most of this stuff comes from
these newsgroups, and given that we haunt them a fair bit, you just tend to fall
over this stuff in various postings. I also have a number of books on Excel and
a lot of these tips are mentioned in some of those.
these newsgroups, and given that we haunt them a fair bit, you just tend to fall
over this stuff in various postings. I also have a number of books on Excel and
a lot of these tips are mentioned in some of those.