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

input same info in multiple cells at once?

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


Joined: 11 Jul 2007
Posts: 49

PostPosted: Thu Jan 21, 2010 12:12 pm    Post subject: input same info in multiple cells at once? Reply with quote

Just as you would hold down the shift key to select multiple cells at the same time in a row or column say Column A Rows 1-19 and you wish to place the same info into each of those 19 cells, how can this be done please without having to paste into each cell one at a time?
Back to top
View user's profile Send private message
EYo
Newbie
Newbie


Joined: 21 Jan 2010
Posts: 1

PostPosted: Thu Jan 21, 2010 12:26 pm    Post subject: Re: input same info in multiple cells at once? Reply with quote

Select the value and the empty cells you want to fill, then Edit > Fill > Down.
Back to top
View user's profile Send private message
mikehende
General User
General User


Joined: 11 Jul 2007
Posts: 49

PostPosted: Thu Jan 21, 2010 12:33 pm    Post subject: Reply with quote

Thank you!!
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Jan 21, 2010 12:35 pm    Post subject: Reply with quote

Or move to the lower right corner of the cell with the value (cursor changes to cross hair) and drag down. If the value is a number and you want it to stay the same then hold down the Ctrl key.
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