How to lock cells in Microsoft Excel, so you need a password to change or erase data

You can lock cells in Excel by heading into the program's "Protection" tab. There, you can set a password, and protect your ...

How to freeze a row in Excel so it always stays on the screen, even when you scroll away

You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen ...
MUO on MSN

Excel’s INFO and CELL functions tell you what’s happening under the hood

While INFO tells you about your Excel environment, CELL digs into individual cells and returns details about their formatting ...
MUO on MSN

I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...