Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

Microsoft Excel can allow users to move charts from one spreadsheet to another or to move it up and down on the same spreadsheet. You can also size a chart by using the dragging technique.

We explain how to use the Excel Column and Excel Columns functions. They are Lookup and Reference functions in Microsoft Excel.

The busier a Microsoft Excel workbook is the more ways you need to get around in it. Check out these shortcuts to help you move between sheets.

Mixed references let you lock the row or the column while keeping the other part flexible. For example, A$1 will lock row 1 while allowing the column to adjust when the formula is copied.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to fix the issue.