Review in Excel 365 2016 2010 2007 2003

View spreadsheets side by side

Sometimes it is necessary to compare two Excel worksheets. E.g., compare balance sheets for different periods of time. You can do it by comparing worksheets side by side in two automatically linked windows.

How to use keyboard to navigate in the spreadsheet

To move around the worksheet with your keyboard, use the key combinations:

How to change columns to rows and vice versa

In some cases, you may want to change columns and rows in your data range for more convenient and impressive view. Excel proposes the fast and simple way to change columns and rows in the data range.

Adding a header and footer to the worksheet

Headers and footers are widely used in the Microsoft Word document, but you should know that Excel has headers and footers too.

How to freeze columns and rows

You can freeze your column and row labels so that you can view them no matter how far you scroll down or to the right in your worksheet.