| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Can't open doc. Too many different cell formats. | Excel Discussion (Misc queries) | |||
| How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
Linear Mode
