Excel Tips

  • 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"
  • To 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).