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

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

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

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

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

How to hide rows and columns and use groups in a shared Microsoft Excel workbook Your email has been sent A few years ago, Microsoft Excel improved collaboration by adding sheet view to shared ...