View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default how do I apply formatting from one worksheet to a whole workbo

I would think creating a normal template should help this, because
that works for new files. Unless the query makes its own formatting,
changing whatever Excel's normal format is, then there probably isn't
much you can do ahead of time.

Since you are copying the data in, you could try Paste Special and
select plain Text from the dialog box. It isn't the same as the normal
Excel Paste Special when copying from a different program, but it is
there.