MS Office / Open Office
How to make dropdown list in Excel
Select a cell or a range that is to contain the validation dropdown listbox
Go to menu item "Data / Validation"
Select the Settings tab, in the Allow dropdown list, select List.
The Source box can refer to a range of cells for its values, or you can type them directly, separated by a list separator (comma or hsemicolon)
If necessary, select "Input message" and "Error Alert"
MS Office keyboard shortcuts
| Ctrl+F3/Ctrl+Shift+F3 | Office clipboard |
| Ctrl+Shift+F8 | vertical block |
| Ctrl+Shift+C | copy format |
| Ctrl+Shift+V | paste format |
| Ctrl+Alt+E | € character |
See also: Hotkeys for other programs
Named cells in MS Excel
The cell in Microsoft Excel could have special name.
It makes the work more convenient and understandable.
For example, it’s much more easy to reference the cell as "Salary", than "S25".
To create a named cell in Microsoft Excel, move the cursor to the "Name Box" and enter the new name of the cell.
After this the new name could be used everywhere in charts, formulae and cell references.
Example:
You could use the following formula "=Salary*(I1+0.2)"
instead of "=S25*(I1+0.2)".
Links:
Code snippets for Visual Basic & VBA Programmers
Books about MS Office/OpenOffice
| 