| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep border permenant in a worksheet template?
I am using an accounting form for a worksheet to enter monthly figures and I
have problems keeping the cell formats permenant. Whenever I copy and paste, I inadvertently overwrite the current cells borders and need to re-enter the previous fromatting. Is there a way anyone knows to keep the formats besides using the clumsy Paste Special-Cell Contents option? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep border permenant in a worksheet template?
If you are using Excel 2003, the Paste icon on the toolbar has a drop-down
arrow on the right side. The drop down has choices like Values, Formulas and No Borders. Tim C "LostInVegas" wrote in message ... I am using an accounting form for a worksheet to enter monthly figures and I have problems keeping the cell formats permenant. Whenever I copy and paste, I inadvertently overwrite the current cells borders and need to re-enter the previous fromatting. Is there a way anyone knows to keep the formats besides using the clumsy Paste Special-Cell Contents option? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep border permenant in a worksheet template?
Thank you so much!!!!
"Tim C" wrote: If you are using Excel 2003, the Paste icon on the toolbar has a drop-down arrow on the right side. The drop down has choices like Values, Formulas and No Borders. Tim C "LostInVegas" wrote in message ... I am using an accounting form for a worksheet to enter monthly figures and I have problems keeping the cell formats permenant. Whenever I copy and paste, I inadvertently overwrite the current cells borders and need to re-enter the previous fromatting. Is there a way anyone knows to keep the formats besides using the clumsy Paste Special-Cell Contents option? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep border permenant in a worksheet template?
And later on when that Option button become too annoying, you can go in and
disable it in ToolsOptionsEdit Gord Dibben Excel MVP On Thu, 15 Dec 2005 11:37:02 -0800, "LostInVegas" wrote: Thank you so much!!!! "Tim C" wrote: If you are using Excel 2003, the Paste icon on the toolbar has a drop-down arrow on the right side. The drop down has choices like Values, Formulas and No Borders. Tim C "LostInVegas" wrote in message ... I am using an accounting form for a worksheet to enter monthly figures and I have problems keeping the cell formats permenant. Whenever I copy and paste, I inadvertently overwrite the current cells borders and need to re-enter the previous fromatting. Is there a way anyone knows to keep the formats besides using the clumsy Paste Special-Cell Contents option? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet template | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Linear Mode
