Review in Excel 2016 2013 2007 2003

Using a form for data entry

Sometimes you need to manage lists where the information is arranged in rows. Excel offers a simple way to work with this big data in rows.

Changing a comment shape

Normally, cell comments are rectangular, but you can give a cell comment any shape you want:

Center text across multiple columns

You can make a worksheet more visually appealing and easier to read by centering text across multiple columns. Often you do this by merging and centering the merged cells, but it is not the only option.

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

Formatting comments

Like a common text, any comments can be formatted: Excel represents many allows you to customize most aspects of its appearance, including color, border, and margins.

Print comments

If your worksheet contains comments, you can print them as they appear on the sheet or at the end of the sheet.

How to hide/display comment indicators

When a comment has been inserted in a cell, the little red triangle is being displayed to indicate a comment in a cell. This tip is how to hide/display this indicator.