OpenOfficeOrg Calc: enter data into all selected cells?

10

1

I want to enter the same data (e.g. "superuser") into multiple cells in OpenOffice.Org Calc (version 3.3.0). In order to do so, I select all the cells I want the data to be entered in. However, only the cell selected last (i.e. when releasing the LMB for group selection) gets the value entered subsequently.

None

Posted 2011-03-11T08:35:41.447

Reputation: 525

Answers

14

Select the cells, type the data and then press enter while keeping the alt key pressed.

Works on my system (Mac, OO 3.2), maybe the modifier key is different on different systems. In Excel on Windows the modifier key is ctrl.

Erika

Posted 2011-03-11T08:35:41.447

Reputation: 576

What about when you want to paste into multiple cells? ctrl or alt don't seem to help (Ubuntu). I would have sworn it used to Just Work (tm) with ctrl-v. – Tomislav Nakic-Alfirevic – 2019-09-06T15:46:55.360

1ALT+ENTER works on 3.3.0 Win7 32 bit. – None – 2011-03-11T09:58:32.280

Asked: 2011-03-11T08:35:41.447

Viewed: 7 837 times

Active: 2011-03-11T16:53:59.867