Review in Excel 2016 2013 2010 2007 2003

Formatting comments

Like a regular text, the comment boxes can be formatted. Excel provides many formatting options and allows you to customize most aspects of its appearance, including color, border, and margins.

Changing a comment shape

The kind of comments that users of earlier versions of Excel used to work in Excel for Microsoft 365 are called notes. You cannot change the shape of comments because all comments are displayed in the separate pane with threads or in the Comments pane (see How to hide/show note and comment indicators for more details).

Print comments

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

How to hide/display comment indicators

Excel for Microsoft 365 has changed the way to work with comments. Now you have two different features for commenting: comments and notes.

Useful Excel features to work with a lot of data

If you have a lot of data, manual editing and formatting of cells isn't an option anymore. However, Excel provides you many group operations that make those manipulations quick and easy.

Quick way to select all cells

This tip will help you to select all cells in the worksheet in one click.

Adding watermarks to workbook

This tip describes how to add watermark text or picture to your workbook.

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.

How to select all the embedded charts on the worksheet

If you need to select all objects embedded into the worksheet, e.g., select all charts to adjust their size, press Ctrl+G and click the Special button or use Ctrl to select objects individually.

Viewing a worksheet in multiple windows

Sometimes, you may want to view two different parts of a worksheet simultaneously - perhaps to make it easier to reference a distant cell in a formula. Or you may want to examine more than one sheet in the same workbook simultaneously.