Excel 2016 2013 2007 2003

How to change the default colors that Excel uses for chart series

Every workbook uses a palette of 56 colors, but you can change palette for the current workbook or even change the default colors for new workbooks.

How to change default font

This enables you to select a different font and font size for your worksheets.

AutoCorrect for data entry

You can use Excel's AutoCorrect feature to create shortcuts for commonly used words or phrases.

Changing moving direction of the cell pointer after entering data

Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behavior to move it up, down, left, right and even stay on.

3 Shortcut keys for worksheet

In this tip describes shortcut keys which can useful.

Creating Master and Scrolled Detail Charts

When you create a chart with a scroll bar, it will be useful create a chart with all data to see which data fragment you see in the scrolling chart.

Creating a Scrolling Chart

Sometimes you need to create a chart that shows a large data amount. Then it would be useful to insert a scroll bar in your chart.

Show the Developer tab

You should display the Developer tab when you want to write macros, run macros that you previously recorded, or create applications to use with Microsoft Office programs. Do the following:

View spreadsheets side by side

Sometimes it is necessary to compare two Excel worksheets. E.g., compare balance sheets for different periods of time. You can do it by comparing worksheets side by side in two automatically linked windows.

Bubble and Area chart

In this tip we will show how to different charts could be combined in the one chart. In example we will combine a Bubble chart with an Area chart: