Microsoft Office Tutorials and References
In Depth Information
Apply an Auto Format to a Range
5
chapter
Formatting Excel Ranges
The AutoFormat dialog box
appears.
3 In the Table format list,
click the AutoFormat you
want to use.
4 Click OK.
A Excel applies the AutoFormat
to the selected range.
Is there a way to apply an AutoFormat without
using some of its formatting?
Yes. Follow Steps to to choose the 3
AutoFormat you want to apply. Click Options
to expand the dialog box and display the
Formats to apply group. Deselect the option
for each format you do not want to apply
(
How do I remove an AutoFormat?
Select the range and then click to display
the AutoFormat dialog box. At the bottom of
the format list, click None , and then click
OK. Excel removes the AutoFormat from the
selected range.
changes to
), and then click OK.
Search JabSto ::




Custom Search