| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock Cell Borders
Hi,
I have a worksheet with text in each cell with borders around them. I copy and paste the cell back and forth depending on what im doing so i dont have to write the same thing again and again. But when i do this it also removes the borders around the cells. As i use different borders depending where it is on the worksheet, it is time consuming drawing all the borders again. Is there anyway I could lock the cell border so i can still change the text inside???? -- Jonno |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Cell Borders
Sorry i was ment to say that i cut and paste cells not copy and paste.
-- Jonno "Jonno" wrote: Hi, I have a worksheet with text in each cell with borders around them. I copy and paste the cell back and forth depending on what im doing so i dont have to write the same thing again and again. But when i do this it also removes the borders around the cells. As i use different borders depending where it is on the worksheet, it is time consuming drawing all the borders again. Is there anyway I could lock the cell border so i can still change the text inside???? -- Jonno |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Cell Borders
Maybe you can learn to Copy|paste special|formulas?
Jonno wrote: Hi, I have a worksheet with text in each cell with borders around them. I copy and paste the cell back and forth depending on what im doing so i dont have to write the same thing again and again. But when i do this it also removes the borders around the cells. As i use different borders depending where it is on the worksheet, it is time consuming drawing all the borders again. Is there anyway I could lock the cell border so i can still change the text inside???? -- Jonno -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to "lock" columns, rows and borders so new data | Excel Discussion (Misc queries) | |||
| I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
| I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
| Cell Borders | Excel Discussion (Misc queries) | |||
| Why data in cell doesn't stay aligned with cell borders when prin. | Excel Discussion (Misc queries) | |||
Linear Mode
