Auto Fill Options
We like the auto fill options button when changing formulas for many cells.
However, we would like to change the default auto fill from COPY CELLS to FILL FORMATTING ONLY. Is there anyway to do this? Patti Brookens Strickler Agency Inc Chambersburg PA |
Right-mouse click the fill-handle & drag down. When you let go, you'll see
many options, including Fill Formatting... Bob Umlas Excel MVP I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks. Dec 16, Jan 14, Jan 27 from 4-5PM (each session is the same). If interested, go to http://www.iil.com, click on the yellow/orange "Try a free webinar" link on the left side, click the Microsoft Excel Tips & Tricks link, follow instructions to register. "Patti B" <Patti wrote in message ... We like the auto fill options button when changing formulas for many cells. However, we would like to change the default auto fill from COPY CELLS to FILL FORMATTING ONLY. Is there anyway to do this? Patti Brookens Strickler Agency Inc Chambersburg PA |
Thanks Bob, but is there anyway to change the default?
"Bob Umlas" wrote: Right-mouse click the fill-handle & drag down. When you let go, you'll see many options, including Fill Formatting... Bob Umlas Excel MVP I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks. Dec 16, Jan 14, Jan 27 from 4-5PM (each session is the same). If interested, go to http://www.iil.com, click on the yellow/orange "Try a free webinar" link on the left side, click the Microsoft Excel Tips & Tricks link, follow instructions to register. "Patti B" <Patti wrote in message ... We like the auto fill options button when changing formulas for many cells. However, we would like to change the default auto fill from COPY CELLS to FILL FORMATTING ONLY. Is there anyway to do this? Patti Brookens Strickler Agency Inc Chambersburg PA |
I don't think you can change the default, but you could record a macro when you
do it once and then tweak that macro to make it useful in most situations. Patti B wrote: Thanks Bob, but is there anyway to change the default? "Bob Umlas" wrote: Right-mouse click the fill-handle & drag down. When you let go, you'll see many options, including Fill Formatting... Bob Umlas Excel MVP I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks. Dec 16, Jan 14, Jan 27 from 4-5PM (each session is the same). If interested, go to http://www.iil.com, click on the yellow/orange "Try a free webinar" link on the left side, click the Microsoft Excel Tips & Tricks link, follow instructions to register. "Patti B" <Patti wrote in message ... We like the auto fill options button when changing formulas for many cells. However, we would like to change the default auto fill from COPY CELLS to FILL FORMATTING ONLY. Is there anyway to do this? Patti Brookens Strickler Agency Inc Chambersburg PA -- Dave Peterson |
All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com