Q. Is there a list of standard Excel design rules we should be following as we create new Excel worksheets? A. By following a common set of spreadsheet design rules, companies can produce more ...

Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Our company creates ...

Audit hidden data, filters, and hard-coded values to ensure your Excel spreadsheets are professional and precise.

Sometimes when I’m working with an Excel worksheet and I want a cell to look a certain way, I run into what appears to be a limitation in the program. It might be trying to enter product numbers with ...

Microsoft Excel spreadsheets hold more than a million rows of data and automate number crunching, but they can do so much more. Excel’s simple interface lends itself to uses well beyond those that its ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

Picture this: you've created an all-singing-all-dancing Microsoft Excel workbook, but when you share it with others, they have no idea where to start. That's why you need a homepage worksheet that ...

An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd." When preparing a worksheet in Excel for your ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

If you use simple copy and paste methods to duplicate an Excel drop-down list, you may discover a problem; when you copy a cell that has a drop-down list and press "Ctrl-V" to paste it into a new cell ...