#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Allow user to add rows to Word '03 table....how? | PMR | Word Tables | 2 | 05-18-2012 06:16 AM |
hidden rows | gsrikanth | Excel | 5 | 01-19-2012 02:40 PM |
merging rows and creating sub-rows | gib65 | Excel | 2 | 12-09-2011 02:09 PM |
adding rows to word table | hklein | Word VBA | 4 | 07-18-2011 12:21 AM |
Rows to Columns | kyakobi | Excel | 5 | 12-07-2010 03:12 PM |