In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

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.