How to Insert Text into Multiple Cells in OpenOffice


When you have data that repeats over multiple table or spreadsheet cells, it can be tedious to type the same thing over and over. You cannot directly type into multiple cells simultaneously in either a OpenOffice Writer table or OpenOffice Calc spreadsheet, but it is possible to duplicate a single cell or group of cells. This allows you to keep your typing to a minimum and still fill multiple cells with identical information.

  • Open the OpenOffice document that you want to edit.

  • Type the text that you want to duplicate into a single cell or group of cells.

  • Highlight the cells that contain the text and press "Ctrl" and "C" to copy them.

  • Highlight the rest of the cells to which you want to add the text.

  • Press "Ctrl" and "P" to paste the copied text into the highlighted cells.

Related Searches

Promoted By Zergnet



You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!