There may be times when a business proposal or report you need to write needs data that is kept in two or more separate Excel worksheets. Fortunately there a couple of ways you can combine multiple ...

If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites. We all have features and commands that we use more than others.

If you need to find a particular value in an Excel sheet, the quickest way is to use a lookup formula. The most popular functions to use in these formulas are VLOOKUP and HLOOKUP, which search across ...

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

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

If you use Microsoft Excel at all to make and edit spreadsheets, you have probably heard of Excel worksheets and workbooks. An Excel workbook is an Excel file that can contain multiple, somewhat ...