ExcelBanter - Fill without formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fill without formatting (https://www.excelbanter.com/excel-discussion-misc-queries/160329-fill-without-formatting.html)

Pivo

Fill without formatting

Most of the time when I fill a column, I want to do so without changing the
existing formatting. Is there a way to change the default so that I don't
have to remember to click on the "fill without formatting" button?

All times are GMT +1. The time now is 02:17 AM.