| View previous topic :: View next topic |
| Author |
Message |
SomeSpreadsheetScrub
General User
Joined: 06 Feb 2008
Posts: 10
|
 Posted: Fri Feb 08, 2008 8:39 am Post subject: How to enter a value in multiple cells at ones? |
 |
|
If I want to give all cells in a certain column the same value. Just selecting them all and entering something only puts the value into the top cell. Hitting ctrl+shift+enter gives an error with formulas and you can't change a part of an array so that doesn't work. I can't find any other ways.
Thanks in advance. |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Feb 08, 2008 9:37 am Post subject: Re: How to enter a value in multiple cells at ones? |
|
|
| SomeSpreadsheetScrub wrote: | If I want to give all cells in a certain column the same value. Just selecting them all and entering something only puts the value into the top cell. Hitting ctrl+shift+enter gives an error with formulas and you can't change a part of an array so that doesn't work. I can't find any other ways.
Thanks in advance. |
Copy the value, select the column and then use Paste Special - numbers only.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8995
Location: Lexinton, Kentucky, USA
|
| Posted: Fri Feb 08, 2008 10:59 am Post subject: |
|
|
| Quote: | | Hitting ctrl+shift+enter gives an error with formulas |
I used Ctrl+Shift+Enter for the formula =A1 with no problem. |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Feb 08, 2008 11:43 am Post subject: |
|
|
| Ctrl+Shift+Enter enters an array formula. Alt+Enter enters a value or "plain formula" into all cells of the selected range. Ctrl+Enter puts a new line in a text value. In Excel Alt+Enter and Ctrl+Enter are reversed. |
|
| Back to top |
|
|
SomeSpreadsheetScrub
General User
Joined: 06 Feb 2008
Posts: 10
|
| Posted: Fri Feb 08, 2008 1:14 pm Post subject: Re: How to enter a value in multiple cells at ones? |
|
|
| jrkrideau wrote: | | SomeSpreadsheetScrub wrote: | If I want to give all cells in a certain column the same value. Just selecting them all and entering something only puts the value into the top cell. Hitting ctrl+shift+enter gives an error with formulas and you can't change a part of an array so that doesn't work. I can't find any other ways.
Thanks in advance. |
Copy the value, select the column and then use Paste Special - numbers only. |
I can only choose from unformatted text or rich text, not numbers only. Besides, I'm trying to do it with a formula.
| JohnV wrote: | | Quote: | | Hitting ctrl+shift+enter gives an error with formulas |
I used Ctrl+Shift+Enter for the formula =A1 with no problem. |
=SUM(OFFSET(D3;0;0;(ROW()-2)))+364,56 stops working
| Villeroy wrote: | | Ctrl+Shift+Enter enters an array formula. Alt+Enter enters a value or "plain formula" into all cells of the selected range. Ctrl+Enter puts a new line in a text value. In Excel Alt+Enter and Ctrl+Enter are reversed. |
Alt enter replaces the 3 from D3 in every cell by the row number.
I guess I'll just ctrl+v enter till RSI  |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Feb 08, 2008 1:23 pm Post subject: |
|
|
| Quote: | Alt enter replaces the 3 from D3 in every cell by the row number.
I guess I'll just ctrl+v enter till RSI Very Happy |
Yes, this is what relative references do when you enter or copy them across cells.
D3 in cell E3 refers to the cell one column left in the same row like this one.
$D$3 refers to D3 actually.
Try the same operation with =SUM(OFFSET($D$3;0;0;(ROW()-2)))+364,56
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=2443 |
|
| Back to top |
|
|
SomeSpreadsheetScrub
General User
Joined: 06 Feb 2008
Posts: 10
|
| Posted: Fri Feb 08, 2008 4:18 pm Post subject: |
|
|
| Villeroy wrote: | | Quote: | Alt enter replaces the 3 from D3 in every cell by the row number.
I guess I'll just ctrl+v enter till RSI Very Happy |
Yes, this is what relative references do when you enter or copy them across cells.
D3 in cell E3 refers to the cell one column left in the same row like this one.
$D$3 refers to D3 actually.
Try the same operation with =SUM(OFFSET($D$3;0;0;(ROW()-2)))+364,56
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=2443 |
Ah I see, thank you very much  |
|
| Back to top |
|
|
|
