View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default copy the same format to a cell using =

If you copy and paste special as link you can carry over the format but it
is a double paste

Copy cell you want to link to, select the cell where you want this to
happen, do editpaste special and select paste link, then do editpaste
special again and this time select formats



--


Regards,


Peo Sjoblom




"Del" wrote in message
...
I am trying to copy a cell from one sheet to another and I use the =
function
but it doesn't copy the same format ie: bold and under line etc.