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

Click the named sheet tab at the bottom of Excel to select it. To simultaneously change the orientation of multiple sheets, hold the "Ctrl" key and click the applicable sheet tabs. If you only have ...

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

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

When your Microsoft Excel spreadsheet slows to a crawl, you can’t help but notice. It may take longer to open and save your files, longer for Excel to calculate your formulas, and longer for the ...