When you have a lot of data in an Excel worksheet it often becomes necessary to summarize the information to get to the crux of what it is telling you. There are a number of ways to do this in Excel, ...

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 ...

Choosing to share or reuse a Microsoft Excel spreadsheet may be a time-saving business decision, whether you want to simply update information or reduce the potential ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

Microsoft Excel lets you add two types of buttons to a worksheet: option buttons and toggle buttons. Option buttons, also referred to as radio buttons, let you choose one item from a list. Toggle ...

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 ...