Copying formats

  • Thread starter Thread starter Amadeo
  • Start date Start date
A

Amadeo

Can anybody tell me how I can copy the formating of one
part of a spreadsheet (e.g. last year's data) to another
part of the spreadsheet (or to another spreadsheet)
without also copying the figures?
 
Amadeo,

You can copy the range, then use Paste special - Formats. Or use the format
painter on the Standard toolbar.
 
Back
Top