Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Automatic Disable of Autoformat in Excel without selecting range of cells

1 view
Skip to first unread message

Iris

unread,
Aug 1, 2003, 4:33:08 AM8/1/03
to
Hi,

Please help on how to automatically disable autoformat in
excel without specifying the range of cells that do not
need formatting.

Thanks.

Debra Dalgleish

unread,
Aug 1, 2003, 6:51:51 PM8/1/03
to
Do you want Excel to stop copying the formatting from rows above? If so,
you can do the following:

1. Choose Tools>Options.
2. On the Edit tab, remove the check mark from
'Extend list formats and formulas'
3. Click OK

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0 new messages