- To enter the same value
into each cell of an active range - select the range, type the value into the
first cell and then hit Ctrl+Enter.
- To add a tab in a cell hit "Ctrl+Alt+Tab"
- To add a line break in a cell hit "Ctrl+Enter"
paste an image of a range highlight and copy the range. Hold down
"Shift" then under the "Edit" menu you should have "Paste Picture
Link". The picture is still linked to the range so if you modify
it, the picture updates! (choose "Paste Picture" if you don't want it to update).