One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

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

Microsoft Office Excel 2010 enables you to open, edit and create spreadsheets and workbooks for your clients and employees on your business computers. You can insert blank worksheets into your ...

When you get into a car to drive it for the first time, you adjust the seat, the mirrors, and maybe even the steering wheel’s position. You want to make sure that it’s a comfortable fit before you set ...

If you're a spreadsheet jockey but you're not keen on Excel's default settings, reader Curare details how to set up a custom Excel template so the data-wrangling app always uses the workspace you ...

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