Color code is a perfect way to identify content and draw an attention to it. In Excel you can easily change colors of one or more spreadsheet tabs.
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 setting 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.
In this tip describes shortcut keys which can useful.
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.
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.