| View previous topic :: View next topic |
| Author |
Message |
msh210
Newbie
Joined: 06 Oct 2011
Posts: 3
|
 Posted: Thu Oct 06, 2011 8:36 am Post subject: [solved] fill cells using keyboard |
 |
|
By "fill" cells I mean to do extend the formula (or value) in one cell to adjacent cells using that cross-shaped thing that appears when you drag form the corner of the first cell.
Is there a way to do that using the keyboard?
Last edited by msh210 on Thu Oct 06, 2011 10:08 am; edited 1 time in total |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Thu Oct 06, 2011 8:47 am Post subject: Re: fill cells using keyboard |
|
|
Welcome to the forum
| msh210 wrote: | | extend the formula (or value) in one cell to adjacent cells |
Copy&Paste: CTRL+c then CTRL+v
Hold shift when moving to other cells to select multiple.
Does this help?
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
msh210
Newbie
Joined: 06 Oct 2011
Posts: 3
|
| Posted: Thu Oct 06, 2011 8:55 am Post subject: Re: fill cells using keyboard |
|
|
| probe1 wrote: | | Welcome to the forum |
Thanks. :-)
| probe1 wrote: | | msh210 wrote: | | extend the formula (or value) in one cell to adjacent cells |
Copy&Paste: CTRL+c then CTRL+v
Hold shift when moving to other cells to select multiple.
Does this help? |
I'm afraid not. If you have sum(A1:A2) in A3 and you want sum(B1:B2) in B3, sum(C1:C2) in C3, etc., then you click the corner of A3 and drag the cross (plus sign) that appears. That's what I want to do with the keyboard.
I should have specified: I'm on a Mac (OS X). But if anyone knows how to do it on another operating system, I'd like to know that, too. |
|
| Back to top |
|
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Thu Oct 06, 2011 10:02 am Post subject: |
|
|
msh210:
You asked:
| msh210 wrote: | | That's what I want to do with the keyboard. |
I am using OpenOffice on a Windows machine, but, I suspect this same technique should work for you.
- Copy your formula to the clipboard ( Ctrl + C )
- Press F6 multiple times ( depending on the toolbars available in your configuration ), until, you arrive at the Name Box ( see Calc help ( F1 ) for sheet area names ) . . . this is on the Formula Toolbar . . . on the left
- Enter the range of cells you want to paste the formula in . . . for example: B3:AZ3
- Press Enter ( this will select the range )
- Paste in your formula: Ctrl + V
- Smile and say: "Gee Sliderule, thanks, a mouse free pasting a formula into a cell range. Now all I have to do is mark the forum post as [Solved]."
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
msh210
Newbie
Joined: 06 Oct 2011
Posts: 3
|
| Posted: Thu Oct 06, 2011 10:08 am Post subject: |
|
|
| That does work (which means probe1's does, too). Thanks, you both! |
|
| Back to top |
|
|
|
