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.
This enables you to select a different font and font size for your worksheets.
You can use Excel's AutoCorrect feature to create shortcuts for commonly used words or phrases.
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.
In this tip describes shortcut keys which can useful.
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.
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.
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:
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.
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: