ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autoformating (https://www.excelbanter.com/excel-discussion-misc-queries/138234-autoformating.html)

Diefett

Autoformating
 
The only autoformating that is close to what I need is Table formating.
Which I can't use as this is not a table.

My question is there any way to use autoformat on a set of data as if you
clicked format, autoformat, options?

Diefett

Autoformating
 
My question is there any way to use autoformat on a set of data as if you
clicked format, autoformat, options in Excel 2003?

Debra Dalgleish

Autoformating
 
What are you trying to format, and what problem do you have when you try
to apply an AutoFormat?

Perhaps you could record the steps as you select the data and manually
apply formatting. Then run that macro when needed.

Diefett wrote:
The only autoformating that is close to what I need is Table formating.
Which I can't use as this is not a table.

My question is there any way to use autoformat on a set of data as if you
clicked format, autoformat, options?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com