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.

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.

Let’s take a look at how to use concatenate in Excel. Using the concatenate function for two columns in Excel Step 1: Select the column and cell in which you’ll be combining data from other cells.

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

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

If you use Excel your text will sometimes spill over. This article will show you how to get Excel cells to fit Text. Make cells expand to fit Text!

How to Assign Names to Cells in Excel. Assigning names to cells in Microsoft Excel simplifies referencing the cell or cell range.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

How to Remove Extra Unused Cells in Microsoft Excel 2013. Worksheets in Microsoft Excel can contain over a million rows and over 15,000 columns. With a workspace that large, if you're not careful ...