Reply to thread

Message: [QUOTE="Alf Hill, post: 5762268"] 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 [/QUOTE]