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

Over the course of business, you may find yourself with copious Excel files that you want to combine into a single workbook to make life a little easier. Excel 2010 allows you to copy or move ...

Over the past several decades, few workplace applications have become as indispensable as Microsoft's versatile spreadsheet editor, Excel. The tech company debuted the spreadsheet editor in 1985, and ...

When you launch Excel you will see an empty worksheet divided by horizontal and vertical lines into a grid – the intersection of a column and a row is called a cell. If you click-and-drag the cursor ...

Freeze results, hide sensitive logic, and boost performance by converting dynamic formulas into static values.

There are several possible reasons for an Excel worksheet to say it is Read Only. If you are able to make changes but not save them, a quick workaround is to select "Save As." This option lets you ...

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.

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