Shortcuts in Excel 2007
How to change default chart
When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart
type.
Apply or remove cell borders
Exist several ways to apply or remove cell borders, you can choose anyone:
Modify cell data
You can edit data in cells this in several ways:
Basic Formula operators
There are several operators that could be used in formulas.
Shortcut key to switch between relative, absolute and mixed references
You can enter nonrelative references (absolute or mixed) manually by inserting dollar signs in the
appropriate positions, or you can use a handy shortcut - F4 key.
Creating and using named ranges
Range names is a powerful Excel feature which allows you to give a symbolic name for the cell or range of
cells to be later used as convenient replacement for cell/range address in formulas.
Copy formulas for selected cells fast and easy
You can use "Copy" (Ctrl+C) and "Paste" (Ctrl+V) options, but there is faster way to "copy" a formula to
multiple adjacent cells.
Working with spreadsheets
In this tip describes shortcut keys which can useful.
How to change cells format easily
A simply way to apply number formatting is to use shortcut keys.
This tip summarizes the shortcut-key combinations that you can use to apply common number formatting to the selected cells or range.
This tip summarizes the shortcut-key combinations that you can use to apply common number formatting to the selected cells or range.