Download example paste-special.xls Description Paste special is used for only pasting specific information like formulas, numbers only, and performing on the fly addition, subtraction, multiplication, and division. Alternate Route Edit > paste special…
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…
Download example shading-borders.xls Learn how to create simple yet effective borders and advanced shading.
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…
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
