Format in Excel 2016 2013 2010 2007 2003

Cell format to round off to thousands, millions, billions

Many of us live in the information space with the calculations performed with precise data expressed in cents or even more granular amounts. Still, it is advisable to present them in thousands or even millions in presentations and reports.

Move entire column or entire row in Excel

Sometimes you need to reorder columns or rows in Excel. If your data does not contain formulas, the procedure does not seem complicated – copy/paste works well for the plain data cells. However, when you try to move data with formulas, you may run into problems.

How to format negative timestamps

Excel supports different formats for positive and negative numbers. You can combine text and formatted values to make the display more presentative. Another numeric format is a timestamp, and you can find a difference between two timestamps and display it in days, hours, and minutes. However, Excel does not handle well negative timestamp differences.

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.

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.

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:

Import a structured text file to an Excel spreadsheet

When you import data from a text file to the Excel spreadsheet, Microsoft Excel launches a Text Import Wizard to help you to import data correctly. Here you can import all or some data from text files of different formats:

How to remove the diamond with question mark symbol

When you paste or import data into the Excel spreadsheet, you might notice unusual symbols like a diamond with a question mark. The replacement character � (often a black diamond with a white question mark or an empty square box) represents an unknown, unrecognized or unrepresentable character:

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more