MS Excel Tips and Tricks – Remove or Add Fixed Decimal Points

Sometimes you will see Microsoft excel sheet adds the decimal points with all the numbers that you enter. You can remove that from happening.

If you want to add the decimal points in every number you enter you can also do that.

  • Open the Excel Sheet
  • Go to Tools
  • Click Options

Excel Decimal Options


  • Click the Edit tab
  • As highlighted in the above image, you will see the fixed decimal option
  • If you want the Excel to automatically enter the decimal points check the Fixed Decimal option, also you can choose how many decimal points that you want to have
  • If you want to remove the automatic decimal points, un check the Fixed decimal points
  • Click Ok to save the settings
  • Now any number you enter you will see the changes

This is applicable to Microsoft Office 2003, Excel 2003 and Excel 2007.

Read more Excel Tips and Tricks from our website


MS Excel Tips and Tricks – Hide or Unhide scroll bar


  • You can hide the vertical scroll bar or the horizontal scroll bar in any excel work book.
  • Go to Tools menu
  • Click Options

Hide or unhide scrollbar

  • The options window opens as seen above
  • Just uncheck the Horizontal scroll bar to hide the Horizontal scroll bar. Check or uncheck the Vertical scroll bar to hide or unhide
  • You can also hide the sheets tab by unchecking the Sheets tabs check box
  • and click OK, you will see the changes in your excel
  • You can make this default in all the excel workbooks that you open by editing the template file

If you have a question, please post a comment.