here's the simplest question ever asked ..... (grin)

[dave_cason]

Hi,

Total newbie to excel ..... got a template and make this ...... I figured out most of it except how to copy and paste or add more rows to the bottom.

I've tried the paste SPECIAL and then ALL but no lines show up and I can't figure out that format painter thing........

I just want the same look in all the rows to run on forever ..... right now I can't figure out how to cut & paste rows 8,9 and 10 to the next
unformatted row(s) like 14,15 and 16 for example.

I just want to add more rows past 13. Yep, silly total newbie question but after watching a few YT vids still no joy ! (grin)

Cheers'
Dave

 

[dreid1011]

To use the Format Painter, select the rows that have the formatting you want to duplicate, then press the Format Painter button and then select the cells you want to apply that format to.

IE: select rows 8, 9 and 10, press Format Painter, then select rows 14, 15 and 16.

 

[dave_cason]

Hi, yep, tried that ......nothing !?
I just tried to do all 3 rows and even just one and that row 14 is still white and unformatted.

- I click row # 9 for example, the row is highlighted by a green box and the cell turn gray....... as normal. (pic 1)

- I took a pic with the cell phone camera because the screen cap function does not show the paint brush and the plus sign.
(however this site says 630 kb is too big)
- But its there and when I then click on the row 14 - it still stays white and looks unformatted.

Is there a shift button I need to hold down or a specific place on the row I newed to click ?


I put the 21k file on to my google drive ......

sent example.xlsx

Rental Schedule Wicom Rental Schedlue Cust. Name,Pickup Date,Return Date,Qty Rented,OUT / RET,Notes Test Cust name,Friday, September 15, 2023,Sunday, September 03, 2023,23,Out,Long Term - HT750 Dave Cason,Friday, August 11, 2023,Tuesday, September 05, 2023,1,RET,Borrowed Solara Flare # 3

docs.google.com

This shouldn't be this hard should it? (grin) Maybe its child proof - that's why I can't do it!

Cheers'
Dave

 

[dreid1011]

Hi, yep, tried that ......nothing !?
I just tried to do all 3 rows and even just one and that row 14 is still white and unformatted.

- I click row # 9 for example, the row is highlighted by a green box and the cell turn gray....... as normal. (pic 1)

- I took a pic with the cell phone camera because the screen cap function does not show the paint brush and the plus sign.
(however this site says 630 kb is too big)
- But its there and when I then click on the row 14 - it still stays white and looks unformatted.

Is there a shift button I need to hold down or a specific place on the row I newed to click ?


I put the 21k file on to my google drive ......

sent example.xlsx

Rental Schedule Wicom Rental Schedlue Cust. Name,Pickup Date,Return Date,Qty Rented,OUT / RET,Notes Test Cust name,Friday, September 15, 2023,Sunday, September 03, 2023,23,Out,Long Term - HT750 Dave Cason,Friday, August 11, 2023,Tuesday, September 05, 2023,1,RET,Borrowed Solara Flare # 3

docs.google.com

This shouldn't be this hard should it? (grin) Maybe its child proof - that's why I can't do it!

Cheers'
Dave

Is your data formatted as a table? I just tried to use the Format Painter on some rows in a table and it did not paste the formatting on the target rows.

Edit: Silly question, yes it is, I see it in the screen shot in your first post. If you want to extend the table, and it's formatting, click the little arrow in the bottom right corner of the last row until your cursor looks like diagonal two-sided arrows, then drag that down as far as you need.

 

[MARK858]

@dave_cason The shading in column E paints fine, the border lines aren't normal formatting, they are part of the Table style and will appear when you insert a new line in the table

 

[dave_cason]

Is your data formatted as a table? I just tried to use the Format Painter on some rows in a table and it did not paste the formatting on the target rows.

Edit: Silly question, yes it is, I see it in the screen shot in your first post. If you want to extend the table, and it's formatting, click the little arrow in the bottom right corner of the last row until your cursor looks like diagonal two-sided arrows, then drag that down as far as you need.

AH HA !

That did it ...... " If you want to extend the table, and it's formatting, click the little arrow in the bottom right corner of the last row until your cursor looks like
diagonal two-sided arrows, then drag that down as far as you need. "

Thanks very much for the help, it was driving me crazy, (not that I'm not l'm already halfway there ) I really appreciate the help!

I hope you have a great weekend !

Cheers'
Dave

 

[dreid1011]

You're welcome, glad to be able to help.