Cell = Cell on other worksheet

Cell = Cell on other worksheet - formatting lost?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed from AZ - 29 Feb 2008 19:07 GMT

I have a worksheet with cells linked back to another worksheet in the
same workbook using the formula "='Sheet1!'B2". The information comes
across, but I'm losing formatting such as left, right, or center,
indents, and line breaks within cells. Is there a way I can do this
without losing the formatting?

Ed

Reply to this Message

Pete_UK - 29 Feb 2008 19:13 GMT

You can't do it with a formula.

However, you can <copy> the source cell(s), then click on the
destination sheet and cell then do Edit | Paste Special | Formats
(check) | OK then <Esc> to transfer the formats over.

Hope this helps.

Pete

> I have a worksheet with cells linked back to another worksheet in the
> same workbook using the formula "='Sheet1!'B2". The information comes
[quoted text clipped - 3 lines]
>
> Ed

Reply to this Message

Ed from AZ - 29 Feb 2008 20:30 GMT

Thanks, Pete. I appreicate the boost.

Ed

> You can't do it with a formula.
>
[quoted text clipped - 15 lines]
>
> - Show quoted text -

Reply to this Message

Pete_UK - 29 Feb 2008 23:02 GMT

You're welcome, Ed - thanks for feeding back.

Pete

Thanks, Pete. I appreicate the boost.

Ed

On Feb 29, 12:13 pm, Pete_UK <pashu...@auditel.net> wrote:

> You can't do it with a formula.
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: