Archive for the 'Intermediate' Category

Validation

Download example validation.xls Description The easiest way to restrict data input into your cells is with validation. You can have an informational message popup when you enter a cell and you can create a validation restriction with an error or warning message popup. Menu link Data > Validation…

Macro

Download example macro.xls Description Learn how to create your own custom macro within 60 seconds. This is a quick and easy way to save you lots of time. Menu Link Tools > Macro > Record new macro…

Custom Footer

Download example header-footer.xls Description Learn how to create your own custom footer and header that you can use on any spreadsheet. Menu Link File > Page Setup > Header/Footer tab

Custom Header

Download example header-footer.xls Description Learn how to create your own custom footer and header that you can use on any spreadsheet. Menu Link File > Page Setup > Header/Footer tab

Conditional Formatting

Download example conditional-formatting.xls Menu Link Format > Conditional Formatting…