Follow the steps below on how to switch between sheets using the Watch Window in Microsoft Excel: Click a cell in Sheet 1, then click the Formulas tab. Click the Watch Window button in the Formula ...

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.

To change Gridline color in Excel, use Excel Options, apply a custom-colored border to the cells, or apply a custom line color. Full details here.

In this month’s column, find out how to change text strings to sentence case in Excel.

To lock your cells in Microsoft Excel, you just need to head into the program's "Protection" tab. Locking a cell in Excel will make it so viewers can't change the data inside of that cell, which ...

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while ...

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