Thread: how do i automatically format repeated text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default how do i automatically format repeated text
One way is to use on the Edit Menu the Paste Special. Copy the cell with the
format you want, the go to Paste Special and select format only.

"Mel" wrote:

Please can someone tell me how to automatically format text that is repeated
throughout my spreadsheet e.g. Payment Received.

Many thanks.
Reply With QuoteReply With Quote