The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

Tips More complex default value setting requires Excel Macro scripts to be written, for example, setting a different default value depending on the value of other columns in the spreadsheet.

The next time you need to configure the Page Setup options for a new worksheet, try this quick copy trick.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.