I often distribute complex spreadsheets so colleagues can enter their own information. But I don’t want them to access any of the other parts of the document. How can I create a hands-off section? One ...

Spreadsheet headings are especially useful for documents that span multiple pages. Adding a header to your spreadsheet enables you to automatically display the document heading on each page, whether ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Every time Laura publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from ...