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 ...
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 ...

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 add a column in Microsoft Excel in 2 different ways

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.