A common source of errors in Excel is "the gap"—a situation where you add new data to the bottom of a list, but your formulas ...

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

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

Q. Some of my Excel spreadsheets contain many worksheets—up to 36 in some cases. But not all the worksheet tabs show at the bottom of the screen. Is there some way to make more tabs visible, such as ...