Settings in Excel 2016 2010 2007 2003

How to change the number of sheets for new workbooks

Excel 2013 automatically creates one worksheet in each new workbook, but you can force it to create as many worksheets as you need.

Changing a comment shape

Normally, cell comments are rectangular, but you can give a cell comment any shape you want:

How to insert cell content to the shape

If you are creating chart or diagram in Excel with shapes, you might need to update the shape text automatically depending on the value in a particular cell.

Increase the number of Undo levels in Excel

Like in version 2010, number of Undo levels in Excel 2013 is 100 - the biggest number that can be used.

Custom cell format

Excel includes a variety of built-in formats that cover general, numeric, currency, percentage, exponential, date, time, and custom numeric formats. You can also design your own custom formats based on one of the built-in formats.

Check data entry for invalid entries

You can greatly reduce data-entry problems in your workbooks by making Excel check entries before entering them in specific cells. To do so, you need to define restrictions and data-validation rules for those cells.