How to Join Two Columns in Excel. When you're setting up a Microsoft Excel spreadsheet to build an employee directory, calculate product margins or project sales, you may run into circumstances in ...

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

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...

You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's how to use it.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

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.

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.

You can subtract multiple cells from one cell in Excel by using Minus sign, SUM function and Paste Special feature. Here is a tutorial on this.

Safeguard your Excel worksheets from accidentally deleting formulas or data sets by locking important cells, while leaving the rest of the worksheet editable.