View source for EN/documentation/ooo3 user guides/getting started/autoformatting cells and sheets

<section begin=title /><noinclude>{{DISPLAYTITLE:</noinclude>Autoformatting cells and sheets<noinclude>}}</noinclude><section end=title />

{{Documentation/GSCalc3TOC
|ShowPrevNext=block
|PrevPage=EN/documentation/ooo3_user_guides/getting_started/formatting_data
|NextPage=EN/documentation/ooo3_user_guides/getting_started/formatting_spreadsheets_using_themes
}}__notoc__
You can use the AutoFormat feature to quickly apply a set of cell formats to a sheet or a selected cell range.

<ol>
<li>Select the cells, including the column and row headers, that you want to format.</li>
<li>Choose '''Format > AutoFormat'''.</li>

[[Image:CalcAutoformat.png|thumb|none|500px|''Choosing an AutoFormat'']]

<li>To select which properties (number format, font, alignment, borders, pattern, autofit width and height) to include in an AutoFormat, click '''More'''. Select or deselect the required options.</li>
<li>Click '''OK'''.</li>
</ol>

If you do not see any change in color of the cell contents, choose '''View > Value Highlighting''' from the menu bar.

== Defining a new AutoFormat ==
You can define a new AutoFormat that is available to all spreadsheets.

# Format a sheet.
# Choose '''Edit > Select All'''.
# Choose '''Format > AutoFormat'''. The '''Add''' button is now active.
# Click '''Add'''.
# In the ''Name'' box of the Add AutoFormat dialog, type a meaningful name for the new format.
# Click '''OK''' to save. The new format is now available in the ''Format'' list in the AutoFormat dialog.


{{CCBY}}
[[Category:Getting Started (Documentation)]]