Excel 2016

How to hide, display, and expand the Formula bar

The Formula bar displays data and formulas for the current cell in Microsoft Excel. You can expand the formula editor if the data or formula does not fit and hide the formula bar if you need more screen space.

Column and row headers

Column letters and Row numbers are principal features of Excel spreadsheets. Using Column letter and Row number, you can address any cell - the main element in Excel.

How to work with a large number of objects in Excel

When you work with many graphical objects such as pictures, charts, text boxes, shapes, etc., it is sometimes challenging to select one of the objects - it can lay behind other objects, or it can be too small, etc.
Excel proposes an excellent feature named Selection pane to help navigate between different objects and groups.

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 on the Comments pane (see How to hide/show note and comment indicators for more details).

How to delete all comments and notes in the spreadsheet

When you create a presentation from a draft Excel spreadsheet, you might need to delete all notes and comments. You can delete every note and comment one by one, but this will take some time. This tip shows the quick way how to delete all notes and comments in your spreadsheet.

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.

How to create two horizontal axes on the same side

While the secondary vertical axis provides a way to display two different types of data for the one time range, the secondary horizontal axis allows you to create a chart showing two data series for different time ranges:

How to create two vertical axes on the same side

If you need to display two different data series for the one- or compatible-time ranges that have different value scales, you can add the secondary vertical axis:ß