| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need one PERMANENT FORMAT but format changes row to row
I set a format for the file with a font, font size, alignment, word wrap, but
if I add something to the row, add another row, the format I want is gone. It's very frustrating and time-consuming to have to reformat the rows all the time. I have extend the formatting on. There must be a way to keep the formatting. Excel 2003 running on XP. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need one PERMANENT FORMAT but format changes row to row
I'd just select one of the perfectly formatted rows
Edit|copy select the row(s) that I want to fix Edit|Paste special|formats vanilla bean wrote: I set a format for the file with a font, font size, alignment, word wrap, but if I add something to the row, add another row, the format I want is gone. It's very frustrating and time-consuming to have to reformat the rows all the time. I have extend the formatting on. There must be a way to keep the formatting. Excel 2003 running on XP. Thanks for your help. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need one PERMANENT FORMAT but format changes row to row
Hi Dave,
Thank you for your answer. However, isn't there a way to set the format for the whole file so I don't have to continually copy each line. I'm working on a large file. In Word, you establish a format that remains in force for the document. Sometimes I reformat an item, and only some of the fields change. Hmmm...I just thought of something. I could increase the width of each field so that everything fits in, and then in the end, reformat everything. "Dave Peterson" wrote: I'd just select one of the perfectly formatted rows Edit|copy select the row(s) that I want to fix Edit|Paste special|formats vanilla bean wrote: I set a format for the file with a font, font size, alignment, word wrap, but if I add something to the row, add another row, the format I want is gone. It's very frustrating and time-consuming to have to reformat the rows all the time. I have extend the formatting on. There must be a way to keep the formatting. Excel 2003 running on XP. Thanks for your help. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need one PERMANENT FORMAT but format changes row to row
You could always apply the formatting to the entire row or column.
You could select all the cells and adjust the rowheight/columnwidth of one of the selected and all will be made the same. vanilla bean wrote: Hi Dave, Thank you for your answer. However, isn't there a way to set the format for the whole file so I don't have to continually copy each line. I'm working on a large file. In Word, you establish a format that remains in force for the document. Sometimes I reformat an item, and only some of the fields change. Hmmm...I just thought of something. I could increase the width of each field so that everything fits in, and then in the end, reformat everything. "Dave Peterson" wrote: I'd just select one of the perfectly formatted rows Edit|copy select the row(s) that I want to fix Edit|Paste special|formats vanilla bean wrote: I set a format for the file with a font, font size, alignment, word wrap, but if I add something to the row, add another row, the format I want is gone. It's very frustrating and time-consuming to have to reformat the rows all the time. I have extend the formatting on. There must be a way to keep the formatting. Excel 2003 running on XP. Thanks for your help. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need one PERMANENT FORMAT but format changes row to row
Hi Dave,
I apply the formatting but it doesn't remain formatted that way. That's why I'm so frustrated. I think something may be wrong with my program. It's time to write the big guns. "Dave Peterson" wrote: You could always apply the formatting to the entire row or column. You could select all the cells and adjust the rowheight/columnwidth of one of the selected and all will be made the same. vanilla bean wrote: Hi Dave, Thank you for your answer. However, isn't there a way to set the format for the whole file so I don't have to continually copy each line. I'm working on a large file. In Word, you establish a format that remains in force for the document. Sometimes I reformat an item, and only some of the fields change. Hmmm...I just thought of something. I could increase the width of each field so that everything fits in, and then in the end, reformat everything. "Dave Peterson" wrote: I'd just select one of the perfectly formatted rows Edit|copy select the row(s) that I want to fix Edit|Paste special|formats vanilla bean wrote: I set a format for the file with a font, font size, alignment, word wrap, but if I add something to the row, add another row, the format I want is gone. It's very frustrating and time-consuming to have to reformat the rows all the time. I have extend the formatting on. There must be a way to keep the formatting. Excel 2003 running on XP. Thanks for your help. -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need one PERMANENT FORMAT but format changes row to row
Are you formatting the entire column? Or a subset of that column?
vanilla bean wrote: Hi Dave, I apply the formatting but it doesn't remain formatted that way. That's why I'm so frustrated. I think something may be wrong with my program. It's time to write the big guns. "Dave Peterson" wrote: You could always apply the formatting to the entire row or column. You could select all the cells and adjust the rowheight/columnwidth of one of the selected and all will be made the same. vanilla bean wrote: Hi Dave, Thank you for your answer. However, isn't there a way to set the format for the whole file so I don't have to continually copy each line. I'm working on a large file. In Word, you establish a format that remains in force for the document. Sometimes I reformat an item, and only some of the fields change. Hmmm...I just thought of something. I could increase the width of each field so that everything fits in, and then in the end, reformat everything. "Dave Peterson" wrote: I'd just select one of the perfectly formatted rows Edit|copy select the row(s) that I want to fix Edit|Paste special|formats vanilla bean wrote: I set a format for the file with a font, font size, alignment, word wrap, but if I add something to the row, add another row, the format I want is gone. It's very frustrating and time-consuming to have to reformat the rows all the time. I have extend the formatting on. There must be a way to keep the formatting. Excel 2003 running on XP. Thanks for your help. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need one PERMANENT FORMAT but format changes row to row
And just who would those be?
Gord Dibben MS Excel MVP On Sat, 26 Sep 2009 11:10:01 -0700, vanilla bean wrote: It's time to write the big guns. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| Date format in permanent list | Excel Discussion (Misc queries) | |||
| Give permanent name to custom format? | Excel Discussion (Misc queries) | |||
| Set Permanent Date Format to MM//DD/YYYY | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
![vanilla bean[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
