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

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 Open a Corrupted Excel File?

Microsoft Excel is one of the most widely used tools as it is versatile and can adapt well for a whole range of functions from project management to financial tracking, and everything in between. That said, your faithful Excel can also fail at times, and data corruption can be a serious problem when this happens.

10 Best Excel Templates For Small Businesses

While the original quote is ‘there’s no rest for the weary,’ I’m sure weary was a synonym for business owner at one point. You’re juggling so many things at once; balancing the needs requests from customers, managing employees, organizing numbers and maintaining communication with suppliers.

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.

Import a text file to an Excel spreadsheet

Often you need to import data to the Excel spreadsheet from a text file. Microsoft Excel offers a Text Import Wizard to import data from different text file formats: