OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[solved] fill cells using keyboard

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
msh210
Newbie
Newbie


Joined: 06 Oct 2011
Posts: 3

PostPosted: Thu Oct 06, 2011 8:36 am    Post subject: [solved] fill cells using keyboard Reply with quote

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
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Thu Oct 06, 2011 8:47 am    Post subject: Re: fill cells using keyboard Reply with quote

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
View user's profile Send private message Visit poster's website
msh210
Newbie
Newbie


Joined: 06 Oct 2011
Posts: 3

PostPosted: Thu Oct 06, 2011 8:55 am    Post subject: Re: fill cells using keyboard Reply with quote

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
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Thu Oct 06, 2011 10:02 am    Post subject: Reply with quote

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.
  1. Copy your formula to the clipboard ( Ctrl + C )
  2. 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
  3. Enter the range of cells you want to paste the formula in . . . for example: B3:AZ3
  4. Press Enter ( this will select the range )
  5. Paste in your formula: Ctrl + V
  6. 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]." Smile
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
View user's profile Send private message
msh210
Newbie
Newbie


Joined: 06 Oct 2011
Posts: 3

PostPosted: Thu Oct 06, 2011 10:08 am    Post subject: Reply with quote

That does work (which means probe1's does, too). Thanks, you both!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group