Tip: How to enter the same text in many cells in Excel

spiros · 1 · 3581

Online spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 792094
    • Gender:Male
  • point d’amour
    • spiros.doikas
    • greektranslator
    • doikas
    • lavagraph
    • Greek translator CV
How to enter the same in many cells in Excel

1. Select the cells you wish to fill with the same data.
2. Type your text of whatever you want.
3. Press Ctrl+Enter

Another method:

1. Select a cell which contains your text.
2. Press Ctrl+C to copy.
3. Expand the selection (down, up or sideways).
4. Press Ctrl+V to paste to all cells.
« Last Edit: 20 Jul, 2005, 14:07:57 by spiros »


 

Search Tools