If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting cells
I have a seniority roster of personnel. It has five colums and 30 rows. The
borders of the cells are formatted.....some thin some bold. Lets say that today, there are 15 rows with info in them to represent 15 people . I now need to move the bottom 5 rows down one row to make room for another person in proper seniority position. When I cut/paste the 25 cells I lose some of the formatting and have to go back and insert lines where they have disappeared. How can I lock the formatting of the border while still being able to edit the cell content? |
#2
|
|||
|
|||
Formatting cells
Instead of cutting and pasting simply select 5 rows and Insert Row.
Gord Dibben MS Excel MVP On Wed, 18 Nov 2009 14:26:02 -0800, Danny wrote: I have a seniority roster of personnel. It has five colums and 30 rows. The borders of the cells are formatted.....some thin some bold. Lets say that today, there are 15 rows with info in them to represent 15 people . I now need to move the bottom 5 rows down one row to make room for another person in proper seniority position. When I cut/paste the 25 cells I lose some of the formatting and have to go back and insert lines where they have disappeared. How can I lock the formatting of the border while still being able to edit the cell content? |
#3
|
|||
|
|||
Formatting cells
hi
if you are only adding 1 row (or maybe more) and want the formating to "fill in" in between, don't use cut/paste. cut/paste does exactly what it says....cuts all data AND formating and pastes it where ever you say. it does not fill in any "gaps". instead use add row(s). high light the area(rows) you wish to add a row(s) then.... 2003 on the menu bar....Insertrows this will drag the formating down. keyboard shortcut = Ctrl + Plus sign Ctrl + Minus sign = delete high lighted row(s). OR same for add/delete high lighted column(s). this will drag formating across. regards FSt1 "Danny" wrote: I have a seniority roster of personnel. It has five colums and 30 rows. The borders of the cells are formatted.....some thin some bold. Lets say that today, there are 15 rows with info in them to represent 15 people . I now need to move the bottom 5 rows down one row to make room for another person in proper seniority position. When I cut/paste the 25 cells I lose some of the formatting and have to go back and insert lines where they have disappeared. How can I lock the formatting of the border while still being able to edit the cell content? |
Thread Tools | |
Display Modes | |
|
|