Excel grays out menu commands for unavailable features or functions. To unlock the grayed-out menus, first review the most common causes, then take the steps necessary make the menu active. By default ...

Spreadsheets that contain complicated formulas and a lot of data can take a while to load when you open them in Excel 2007, but that's not the only reason spreadsheets can be slow to load. Microsoft ...

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

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

In business, spreadsheets are most often used to make financial calculations. Financial worksheets that contain errors could cause financial embarrassment to the business, but unfortunately ...

A selected Worksheet Tab in Microsoft Excel is white, but what if you want to add a splash of Color or distinctive Colors to your Worksheet Tab. Adding Color to your Worksheet Tabs is an easy way to ...

In case you work in one Excel workbook that you'd like to move to another one, there is a simple solution that doesn't require knowing macros or VBA codes – it can be done in a few simple clicks. Read ...

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