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

Merging cells

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


Joined: 18 Oct 2011
Posts: 2

PostPosted: Tue Oct 18, 2011 11:57 am    Post subject: Merging cells Reply with quote

Hello there helpful people!

I was wondering if it was possible to merge rows of different sizes (see screenshot) which are separated by a single empty row?

http://imageshack.us/photo/my-images/441/40289272.jpg/

Thank you!
Back to top
View user's profile Send private message
claven123
General User
General User


Joined: 22 Dec 2010
Posts: 13

PostPosted: Tue Oct 18, 2011 5:21 pm    Post subject: Reply with quote

If you want to merge all three, just highlight the cells and hit the merge and center button. It will center the info, you then can hit the left or right button to un-center them.

D
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Tue Oct 18, 2011 9:21 pm    Post subject: Reply with quote

Hi,


What about pressing the merge button and see what it does?

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).


Last edited by mgroenescheij on Wed Oct 19, 2011 1:25 pm; edited 1 time in total
Back to top
View user's profile Send private message
monkeh4yew
Newbie
Newbie


Joined: 18 Oct 2011
Posts: 2

PostPosted: Wed Oct 19, 2011 5:41 am    Post subject: Reply with quote

Thanks for the advice but there are over 10,000 entries so I was hoping there was an automatic way of grouping and merging the rows so I didn't have to individually merge each chunk manually which would take forever.

So if you see the screenshot, rows 95 through 100 I want to merge together, then the next chunk below that and so on all the way through...
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