HomeMicrosoft OfficeExcelHow to avoid automatic data formatting in Excel?

How to avoid automatic data formatting in Excel?

This article explains how you can avoid auto-formatting in Microsoft Excel. Excel has a autoformat which may prove useful in many ways but at times if you wanted to turn it off follow the steps given below.

How to avoid autoformatting in Excel?

Follow the below steps to avoid automatic data formatting in Excel.

  • Select the data which has been autoformatted.
How to avoid automatic data formatting in Excel
  • Click on the green-colored box.
How to avoid automatic data formatting in Excel
  • Select the Undo option.
How to avoid automatic data formatting in Excel
  • Now you can see that the format has been removed.
How to avoid automatic data formatting in Excel

If incase you wanted to avoid it through out the worksheet then click on Stop. This way you can undo the auto-format option in Excel.

    1 Comment

  1. User Avatar
    Sandhya
    April 15, 2023
    Reply

    Beginners should learn it. How to stop Excel’s automated data formatting although the idea is unclear

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021