![]() |
Insert Row & format as per other rows, above/below
Hi all, I have a report and i need to insert a row at a number to be given by
the user but i need the new row if put in at the bottem of the list to take on the format of the row above it, any help would be appreciated. -- Les |
Insert Row & format as per other rows, above/below
Hi, i have managed this by just copying the top lime and past special format
thank you. -- Les "Les" wrote: Hi all, I have a report and i need to insert a row at a number to be given by the user but i need the new row if put in at the bottem of the list to take on the format of the row above it, any help would be appreciated. -- Les |
Insert Row & format as per other rows, above/below
Hi Les,
I would highlight the desired row, then copy. Select where you want the row to be inserted, then use "Paste Special" instead of paste. Select the "Format" radio button. See if it helps. "Les" wrote: Hi all, I have a report and i need to insert a row at a number to be given by the user but i need the new row if put in at the bottem of the list to take on the format of the row above it, any help would be appreciated. -- Les |
All times are GMT +1. The time now is 11:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com