You can record a Macro that does this. From the menu choose Tools, Macros,
Record new macro. Then do all the formatting you want and click the square
stop button when you are done. Then you will have your macro.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003


"Amol" wrote:

I have data in text file which i want to convert on xl with selected
column (there is some unwanted column which i want to delete)
and want to change the header name of column with specific color and
and font type
can anyone suggest macro for that which can do the same and chang the
font type of all data