Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Learn how to use Excel’s Allow Edit Ranges feature to assign editable cells, protect data, and streamline collaboration in shared workbooks.

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

Edit Unnamed List Launch Excel and click the cell that contains a drop-down list to select that cell. Click "Data" and choose "Data Validation" to view the Data Validation window.

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

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

Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style. It’s common to highlight input cells so users know which values to change ...

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.

Microsoft Excel 2013 surrounds the active cell with a dark border to help identify the cell you are editing. Pressing the Enter key after editing the cell moves the active cell to the next cell down.

Want to highlight Cell or Row if a checkbox is selected? We show you hHow to highlight a Cell or Row with a Checkbox in Excel.