ExcelBanter - Cell D3 = Cell A1 for the Value as well as formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell D3 = Cell A1 for the Value as well as formats (https://www.excelbanter.com/excel-discussion-misc-queries/46847-cell-d3-%3D-cell-a1-value-well-formats.html)

Sunantoro

Cell D3 = Cell A1 for the Value as well as formats

If in Cell D3 we fill with "=A1" then Value of D3 always equal to that of A1.
If A1 contains Bold or Italic Texts , how can D3 contains the same?
Thanks, SUNAN.

Gary''s Student

After filling D3 with "=A1", click on A1:
Edit Copy
click on D3 and then:
Edit Paste Special and check format.
--
Gary''s Student

"Sunantoro" wrote:

If in Cell D3 we fill with "=A1" then Value of D3 always equal to that of A1.
If A1 contains Bold or Italic Texts , how can D3 contains the same?
Thanks, SUNAN.

All times are GMT +1. The time now is 11:01 PM.