Microsoft Excel is a spreadsheet program used for analytical purposes. The program's files are known as workbooks. A workbook should contain at least one visible worksheet--a collection of cells ...

Nearly every Microsoft Excel workbook I own—especially those I share with others—contains a hidden backend worksheet. It's essentially the engine room of my workbook and helps me keep my spreadsheets ...

Excel files can be complicated worksheets with pages of data, calculations and cross-referenced information. With all that information, it's no wonder you might feel panicked when one of your ...

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

How to copy an Excel sheet into a new workbook Your email has been sent Copying or moving data is a common task for users in Excel workbooks. Copying data from one worksheet to another within the same ...