| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Rows NO FORMAT | Excel Worksheet Functions | |||
| Insert rows: Formats & formulas extended to additonal rows | Excel Worksheet Functions | |||
| Insert page breaks every 50 rows but do not include hidden rows | Excel Programming | |||
| How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) | |||
| Insert cell/format/text/fontsize and auto insert into header? | Excel Programming | |||
Hybrid Mode
