ExcelBanter - auto formats

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - auto formats (https://www.excelbanter.com/excel-worksheet-functions/12890-auto-formats.html)

Jason

auto formats

What are autoformats in Excel?

nbrcrunch

Forgive if I misunderstand, but I think you are referring to:

Tools - Options
click on the General tab
About center you will see the default font.

--
nbrcrunch

Gord Dibben

They are pre-set formats provided in FormatAutoFormat

Select a data range then Autoformat.

Pick a style you like and OK.

Gord Dibben Excel MVP

On Sat, 12 Feb 2005 17:05:02 -0800, "Jason"
wrote:

What are autoformats in Excel?

All times are GMT +1. The time now is 01:54 PM.