Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2012, 11:51 AM
j2b3 j2b3 is offline rows in word? Windows Vista rows in word? Office 2010 32bit
Novice
rows in word?
 
Join Date: Jul 2012
Posts: 4
j2b3 is on a distinguished road
Default rows in word?

Hello,



I am making a directory and have been given specific orders for it to be in alphabetical order and pan from left to right and go down the page (two rows wide and 5 rows high). Ex:

1 2
3 4
5 6

I tried doing this by just using a 2x5 table, and I would just paste the names and pictures in to each slot. However, I have been told that, after completion, more names will show up in the directory. This is problematic because as is, if I have to insert one person, I will have to move everyone back one.

Is there a way to prevent this from happening (ex. make the names slide left or down and right)? Or make specific rows in word where this formatting can allow "inserting" things?

Thanks
Reply With Quote
  #2  
Old 07-18-2012, 04:26 PM
macropod's Avatar
macropod macropod is offline rows in word? Windows 7 64bit rows in word? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,232
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

No, you can't do that - Word inserts a whole row, or adds a new cell to the existing row.

What you could do, if you're willing to have the sort order from right to left is to configure your document with a single-column table side-on in a landscape format (assuming you're now using portrait) using a multi-column layout and rotated text in the cells. Then, whenever you insert a new row, all the others will move to the new 'correct' positions. Even if you insert the new rows out of order, in this scenario Word's table tools can be used to re-sort them. See attached.

Note: all cells have borders, but you may not see them unless you switch to print preview.
Attached Files
File Type: doc SnakingTable.doc (38.0 KB, 16 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-19-2012, 04:19 AM
j2b3 j2b3 is offline rows in word? Windows Vista rows in word? Office 2010 32bit
Novice
rows in word?
 
Join Date: Jul 2012
Posts: 4
j2b3 is on a distinguished road
Default

hmm... Good idea, but that only works from right to left?

If not in Word, Is there any way to do this in excel? It must be from left to right.
Reply With Quote
  #4  
Old 07-19-2012, 03:59 PM
macropod's Avatar
macropod macropod is offline rows in word? Windows 7 64bit rows in word? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,232
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

In Excel, if you put all the data into column A on Sheet1, the following formula in columns A & B on Sheet2 will generate the kind of output you're after:
=IF(OFFSET(Sheet1!$A$1,(ROW()-1)*2+COLUMN()-1,0)="","",OFFSET(Sheet1!$A$1,(ROW()-1)*2+COLUMN()-1,0))
If you add/delete rows on Sheet1, the formula will automatically rearrange the data. The only thing you'll need to ensure is that the formula in Sheet2 spans at least half the number of rows on Sheet1.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
rows in word? Allow user to add rows to Word '03 table....how? PMR Word Tables 2 05-18-2012 06:16 AM
rows in word? hidden rows gsrikanth Excel 5 01-19-2012 02:40 PM
rows in word? merging rows and creating sub-rows gib65 Excel 2 12-09-2011 02:09 PM
rows in word? adding rows to word table hklein Word VBA 4 07-18-2011 12:21 AM
rows in word? Rows to Columns kyakobi Excel 5 12-07-2010 03:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:35 AM.


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