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.

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

You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, etc.

Just select all the cells, ensuring that the information you want to use is in the top-left cell in the range, then click "Merge" in the "Alignment" area of the ribbon. You can then center the text.

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