Small businesses need to ensure data integrity in spreadsheets. Microsoft groups objects such as drop-down lists in a category called data validation. These objects help spreadsheet creators control ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

No one deliberately creates a worksheet that contains errors. The sad truth, however, is that many people unwittingly do just that and end up with a worksheet that doesn’t give correct results. This ...

If you find yourself wondering where your money went at the end of each month, budgeting can help you become more aware of your income and spending. Committing your budget to paper takes the benefits ...

A story web worksheet is a tool you can use to help stimulate your creative juices and organize your thoughts. A typical story web begins with a central topic or thought that you use as the focal ...

Thanks to a suggestion from Macworld reader David Erato, I’ve spent the last couple of weeks immersed in spreadsheet applications…no, not on my Mac, but on my iPhone. David was curious how well the ...

If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...

Nearly every Microsoft Excel workbook I own—especially those I share with others—contains a hidden backend worksheet. It's essentially the engine room of my workbook and helps me keep my spreadsheets ...

How to copy an Excel sheet into a new workbook Your email has been sent Copying or moving data is a common task for users in Excel workbooks. Copying data from one worksheet to another within the same ...