Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

Visual Basic Application or VBA , when used in Microsoft Excel, is an efficient tool, as repetitive jobs can be automated with its help. Users can even write custom VBA code to meet their programming ...

How to Go to Precedent Worksheets in Excel. Business owners and their office managers or accountants often need to check formula cells in Excel spreadsheets for potential links to a preceding cell ...