Simple Solution? Force autofill without formatting?

BBexcel

New Member
Joined
Sep 23, 2009
Messages
1
Hello -

Is there any way I can set the default autofill to "without formatting"? I'm distributing a workbook to individuals using various versions of excel and don't want my 2 colored rows to get messed up when an autofill is used. Thanks for your help!
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,108,655
Messages
5,524,136
Members
409,562
Latest member
meeranaskar

This Week's Hot Topics

Top