Thread: Pasting formats and values without formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Pasting formats and values without formulas
Two steps?

Paste SpecialValues

Paste SpecialFormats.

Or one step if using the Show Paste Options buttonValues and source
formatting.



Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 13:38:01 -0700, Rae
wrote:

How can formatting (number and font, cell highlighting, size, etc.) and cell
values be pasted without pasting formulas?

Reply With QuoteReply With Quote