Recalculating the Worksheet
If you are working with huge workbooks that contain a very large number of formulas, functions, and data, you can turn off the automatic recalculation.
Paste results into cell without formulas
You may not always want to copy everything from the source cells to the destination cells. For example, you may want to copy only the current values of formulas rather than the formulas themselves.
Using the Keyboard for moving within a worksheet
To move around the worksheet with your keyboard, use the key combinations:
Entering decimal points automatically
If you need to enter lots of numbers with a fixed number of decimal places, Excel has a useful tool:
How to change default font
This enables you to select a different font and font size for your worksheets.
Freezing Column and Row Labels
You can freeze your column and row labels so that you can view them no matter how far you scroll down or to the right in your worksheet.
Applying Conditional Formatting
This tip describes how to use conditional formatting for comfortable viewing results in the worksheet.
3 Shortcut keys for worksheet
In this tip describes shortcut keys which can useful.
Show or Hide Enhanced ScreenTips
By default, Excel shows document tooltips (or screentips) when you hover on a button, but this option can be turned off.
Collapse the Ribbon to get more space on screen
When you need as much space as possible on screen to view a document, you can collapse (or minimize) the Ribbon and then restore it very simple.