Format in Excel 2013 2010 2007 2003

Four ways to improve your data presentation in Excel

Using simple tricks, you can convert your Excel spreadsheet from a table with rows and columns to an interactive application that will help you to represent the date in a more appealing and convenient way.

Change the decimal point to a comma or vice versa

This tip is about changing number separators in Excel - comma to point, point to comma, semicolon to comma, etc.

The best way to organize your workbook using hyperlinks

For some workbooks with big number of sheets or to highlighting some important data, it is necessary to create hyperlinks to another cell in the same spreadsheet.

Copy and paste only nonblank cells

Unfortunately, when you try to paste a series of cells with blank cells, Paste special with Skip blanks option doesn't seem to work.

Unmerging all merged cells

Here's a quick way to unmerge all merged cells in a worksheet:

Quick way to select all cells

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

A quick way to duplicate all of the custom chart formatting

Creation of a large number of visually consistent charts to represent different data is a time consuming and error prone task, unless you know how to copy formatting between charts.

Creating a Drop-Down List in a Cell

This tip will show you how to display a drop-down list in a cell.

Adding watermarks to workbook

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

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.