If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use insert to move cell data.
"Suzanne S. Barnhill" wrote: Where you should be managing the data is in a data source from which you can create new label sets as needed using a mail merge. For more, see these articles: How to create a Mail merge http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm Creating a mail merge Data Source http://word.mvps.org/FAQs/MailMerge/...DataSource.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Alf Hill" wrote in message ... I have a table of addresses. 5 columns for address divided by narrow blank columns and 13 rows also divided by narrow blank rows. This is to suit standard A4 adhesive address label sheets. Total addresses per page = 65. I wish to add(insert) or delete an address as updates arise to keep surnames in alphabetical order. I cannot find how to move existing data along and down to leave empty spaces for the new address or how to delete data in a cell and have the addresses move back automatically so there are no empty spaces. I do not want to move cells but to insert new text so all existing addresses move along one address space.(ie 1 narrow empty cell and 1 address cell. There must be an automatic method because this is what computers should do but I could not find it in help?? Alf Thanks everybody. I have written to microsoft suggesting one simple command is needed so the computer does all these tedious tasks. Alf |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell reference data not displaying in chart | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 06:30 PM |
entering data changes the cell pattern | ozzie_90680 | Worksheet Functions | 2 | September 26th, 2003 09:07 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |