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

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

On Feb 29, 7:07*pm, Ed from AZ <prof_ofw...@yahoo.com> wrote:
> 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

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.
>
> 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
>
> On Feb 29, 7:07*pm, Ed from AZ <prof_ofw...@yahoo.com> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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

Pete

"Ed from AZ" <(E-Mail Removed)> wrote in message
news:c28cfa75-c48f-4e31-bce9-(E-Mail Removed)...
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.
>
> 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
>
> On Feb 29, 7:07 pm, Ed from AZ <prof_ofw...@yahoo.com> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -