How to move to the next row with the same format for the previous row ?

[midoo77]

Dear valued Experts

I want to move to the next row but i don't want to make another format just when i begin to write in the next row the format appear automatically like previous row ?

Note : format include formulas ,borders and colors every thing in previous row

regards

[Fermented Reptile]

SORRY - MISREAD YOUR POST, BELOW INFO PROB NOT OF USE!!!

Hi there,

Beginning with the cell where you formula is, select the range you want to copy the formulas into. Now, click in the formula bar to activate editing (enter the formula now if you haven't done so already), then press Control + Return. Excel should copy the formula, but leave formatting untouched.

HTH,

FermentedR

[midoo77]

Dear valued Experts

Why No one solved my problem - i need help

[midoo77]

why no answer?

[midoo77]

[Pepe Le Mokko]

If you are mad you did not get a free answer, try pay sites.

[Lemice]

Hello,

What you can do is ... insert as many rows as you like, then when you want to format them like a row which you already formatted, you can just select the row (like, from A4 to E4), select "copy" (Ctrl-C works fine), then select all the new rows, right click and choose "Paste Special..." (You can also find this under Edit), choose "Format" then "OK". All of your new rows should have the same format with whatever row you copied.

About the total in the end of the table, you will just have to put this formula to whichever cell at the end of the table

Please Login or Register  to view this content.

Assuming the first row with data is E3, and the final row with data is E6. Don't worry about it, if you insert a random number or row between 3 and 6, the formula will adjust itself.

Hope this help.

[midoo77]

Pepe Le Mokko

Do you have pay site that you want to tell us about it ? No need for that keep you advice for yourself dear , here to ask and who want to answer its OK and at the End all of members have useful

[midoo77]

Dear Lemice

Thank you for your reply and i appreciate your interesting but i think not that what i mean.

regards

[Pepe Le Mokko]

Pepe Le Mokko

Do you have pay site that you want to tell us about it ? No need for that keep you advice for yourself dear , here to ask and who want to answer its OK and at the End all of members have useful

I suggest you try Google for pay sites., and again please have some respect for peolple giving you FREE answers on THEIR spare time - Also check out the meaning of the smilies you use.
You are now one of the select members of my ignore list.

[midoo77]

I suggest you try Google for pay sites., and again please have some respect for peolple giving you FREE answers on THEIR spare time - Also check out the meaning of the smilies you use.
You are now one of the select members of my ignore list.

at the beginning i'm sorry for my bad English

first of all i always use the expression "valued experts " because i appreciate their time and their help for people. and if I use incorrect emotions i apologize about that.
second : Now you suggest but before i think read your post better." If you are mad you did not get a free answer, try pay sites."
third: 163 members who are enter to see this thread want to know the answer , they didn't want your Genius solution to search in Google about pay sites
finaly : i don't care about your ignore list , I'll be care about your list if you enter to help 163 members not to tell us about pay sites