Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2016, 01:28 PM
Prot64 Prot64 is offline Issue splitting rows Windows 10 Issue splitting rows Office 2016
Novice
Issue splitting rows
 
Join Date: Sep 2016
Posts: 6
Prot64 is on a distinguished road
Default Issue splitting rows


Hi! New to the forums, but I've got a few questions I'm hoping to clear up. For starters, my most recent problem:

I had this table, 7 by 18, and I realized that the last two rows need to be 3 by 36 -two rows for every one of the first three columns. Should have been easy as pie to split them. But when I tried to do it I received and error: "The number [of rows] must be between 1 and 18". I tried splitting 2 rows into 4 and I received the same message: "The number must be between 1 and 2". Only one row could I split into two. What the hell?

Note: Normally I could've worked around this easily, but I had already filled the first 4 by 18 cells with data. When I created a 7 by 36 table and then split the first 4 by 36 into 4 by 18, pasting the info didn't work (Word pasted two rows of data per cell).

Long story short I had to duplicate my work. It was infuriating. Any ideas why this happened?
Reply With Quote
  #2  
Old 09-08-2016, 04:45 PM
macropod's Avatar
macropod macropod is offline Issue splitting rows Windows 7 64bit Issue splitting rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you need to split the 3 cells in a given row into multiple rows, select those cells and choose 1 for the number of columns & 2 for the number of rows. If you need to do that for two or more rows, process them one at a time - you can't do them together.

Splitting cells into multiple columns is quite simple and can be done for both rows in one pass. You can either select all the cells and accept the split defaults (6 columns & 2 rows) which assumes cell merging before splitting, or uncheck that option and accept the new split defaults (2 columns & 1 row).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-08-2016, 06:27 PM
Prot64 Prot64 is offline Issue splitting rows Windows 10 Issue splitting rows Office 2016
Novice
Issue splitting rows
 
Join Date: Sep 2016
Posts: 6
Prot64 is on a distinguished road
Default

I guess this is hard to explain with just words and I'm not quite sure I understand what you're saying. Let me show you a screenshot. Below the entire three columns to the right were selected in full (they got unselected when I took the screenshot). I tried to split them from 8 rows into 16 and there's the error. Is there truly no way around this? It seems incredible I can only split one row at a time!

Reply With Quote
  #4  
Old 09-08-2016, 06:35 PM
macropod's Avatar
macropod macropod is offline Issue splitting rows Windows 7 64bit Issue splitting rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Prot64 View Post
It seems incredible I can only split one row at a time!
That is only so for splitting cells into multiple rows. It's still not obvious from your screenshot what you're trying to do. Perhaps you could attach a document to a post, containing before & after versions of your table.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 09-08-2016, 07:10 PM
Prot64 Prot64 is offline Issue splitting rows Windows 10 Issue splitting rows Office 2016
Novice
Issue splitting rows
 
Join Date: Sep 2016
Posts: 6
Prot64 is on a distinguished road
Default

This is what I have (for example):



This is what I want:

Reply With Quote
  #6  
Old 09-08-2016, 08:00 PM
macropod's Avatar
macropod macropod is offline Issue splitting rows Windows 7 64bit Issue splitting rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For that, you can choose to create as many rows as you need for either:
• columns 2 & 3, then merge rows in column 1 (you could do this by row pairs, or by merging all into one cell, then splitting that cell into 3 rows); or
• column 1, then split the rows for columns 2 & 3, one row at a time.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 09-09-2016, 12:08 PM
Prot64 Prot64 is offline Issue splitting rows Windows 10 Issue splitting rows Office 2016
Novice
Issue splitting rows
 
Join Date: Sep 2016
Posts: 6
Prot64 is on a distinguished road
Default

That's where the issue lies. Method 1 was not practical because column 1 was full of data and there were many rows of it.

As far as method two, here's what happens:

First I select the rows and columns to split:



Then I open the split cells dialog and choose the number of columns (same) and rows (2x) I want:



And the result (where "the number" means the number of rows):

Reply With Quote
  #8  
Old 09-09-2016, 04:38 PM
macropod's Avatar
macropod macropod is offline Issue splitting rows Windows 7 64bit Issue splitting rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You would need to split the rows individually, not collectively.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 09-10-2016, 11:08 AM
Prot64 Prot64 is offline Issue splitting rows Windows 10 Issue splitting rows Office 2016
Novice
Issue splitting rows
 
Join Date: Sep 2016
Posts: 6
Prot64 is on a distinguished road
Default

Thanks. It's mind-boggling that a software that can be so powerful at some things cannot do some awfully basic stuff, like this or like setting default options for text boxes and tables.
Reply With Quote
  #10  
Old 09-10-2016, 08:41 PM
macropod's Avatar
macropod macropod is offline Issue splitting rows Windows 7 64bit Issue splitting rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Prot64 View Post
It's mind-boggling that a software that can be so powerful at some things cannot do some awfully basic stuff, like this or like setting default options for text boxes and tables.
It's hardly mind-boggling that the software doesn't come with facilities to compensate for a user's poor table design. Be thankful the fix is a trivial undertaking.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 09-11-2016, 04:00 PM
Prot64 Prot64 is offline Issue splitting rows Windows 10 Issue splitting rows Office 2016
Novice
Issue splitting rows
 
Join Date: Sep 2016
Posts: 6
Prot64 is on a distinguished road
Default

I am only thankful for your help and attention, but only that. A "fix" that means going through 17 rows one by one is hardly trivial. Trivial would be to split two rows in four, which Word cannot do. This is not an advanced function we're talking about. Open-source software like LibreOffice has no issues with the little "glitches" Word suffers from. Word wins the beauty contests and the monopoly contests that forces users like me to use it, but Libre is the much superior software.
Reply With Quote
  #12  
Old 09-11-2016, 04:06 PM
macropod's Avatar
macropod macropod is offline Issue splitting rows Windows 7 64bit Issue splitting rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Prot64 View Post
Libre is the much superior software.
Until you try to use it for anything serious. There is a reason people pay for Word instead of using Libre and the like that they can get for free...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue splitting rows Mail Merge Multiple Rows format issue Peterlar Mail Merge 4 07-14-2016 04:50 AM
Issue splitting rows Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
Issue splitting rows Grouping table rows to prevent individual rows from breaking across pages dennist77 Word 1 10-29-2013 11:39 PM
Issue splitting rows Splitting Out PDFs 4mysanity Word VBA 27 12-05-2012 03:31 PM
Document splitting MsLavigne Word 2 05-09-2012 05:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft