Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I noticed that if I create a List object and center align the fields, fill
some data in, delete all the list rows, and then fill the data in again, the second row in the list object will would change to general while the rows above and below it are still fine (centered). This is also reproducible without code. To reproduce without code: 1. Select A1:C1 and right click Create List. 2. Highlight column B and column C and center justify the columns. 3. Paste a few lines (or the below) in the insert row (A2 or B2) asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf All four rows should be center justified as expected. 4. Now while the four list rows are still selected (or you can select the four rows), right click and Delete Row. 5. Repeat step 3 and this time the second row in the List should be general justified while the other three are centered. Is this behavior actually expected and are there any workarounds? Any help would be appreciated. Thanks. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I should note this was in Excel 2003 and I haven't replicated it in 2007.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How How do I change the default alignment to vertical center? | Setting up and Configuration of Excel | |||
Alignment: Center text but Right numbers. | Excel Worksheet Functions | |||
Problem Deleting all rows from List Object | Excel Programming | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
Help!!! I have problem deleting 2500 rows of filtered rows | Excel Programming |