Cell = Cell on other worksheet - formatting lost?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

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
 
Thanks, Pete. I appreicate the boost.

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




- Show quoted text -
Click to expand...
 
You're welcome, Ed - thanks for feeding back.

Pete

Thanks, Pete. I appreicate the boost.

Ed
 
Back
Top