| View previous topic :: View next topic |
| Author |
Message |
nalieke
Newbie
Joined: 31 Jan 2008
Posts: 3
|
 Posted: Thu Jan 31, 2008 7:03 am Post subject: input same value in different cells |
 |
|
Hi,
in microsoft office when you select different cells, then insert value, then press enter, the value appears to be in each cell. In open office this doesn't work. How does it works in OO?
I tried searching on this site with the keywords in subject but didn't find anything ...
tia
nath |
|
| Back to top |
|
 |
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Thu Jan 31, 2008 7:38 am Post subject: |
|
|
| Alt+Enter |
|
| Back to top |
|
|
nalieke
Newbie
Joined: 31 Jan 2008
Posts: 3
|
| Posted: Thu Jan 31, 2008 7:41 am Post subject: |
|
|
aaaaaaah!
thx
nath |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Thu Jan 31, 2008 8:12 am Post subject: |
|
|
| Note, if you ever forget to hold down Alt, as I sometimes do, trying again by putting the cell into edit mode and pressing Alt+Enter won't work. You have to also "make a change". I usually press the spacebar followed by backspace. Then Calc will think you've edited the cell, and take notice of Alt+Enter. |
|
| Back to top |
|
|
|
