ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert Row & format as per other rows, above/below (https://www.excelbanter.com/excel-programming/404602-insert-row-format-per-other-rows-above-below.html)

Les

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

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


Raymond Angana

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