ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   auto format - how do I turn it off? (https://www.excelbanter.com/setting-up-configuration-excel/35131-auto-format-how-do-i-turn-off.html)

TooManyPutters

auto format - how do I turn it off?
 
Using Office XP



Kassie

Hi

Not too sure what you mean. Do you mean you do not want formats and
formulas in cells to automatically extend to new rows, eg when you insert
rows, or want to enter new data in adjacent columns etc? Is so, click on
Tools|Options|Edit tab, and untick "Extend list formats and formulas"

"TooManyPutters" wrote:

Using Office XP





All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com