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

When you need to select several cells with a similar attribute, you can use Excel's Find feature to make the process eaiser.

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.

This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

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.