Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem with deleting rows in a List object with center alignment

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem with deleting rows in a List object with center alignment

I should note this was in Excel 2003 and I haven't replicated it in 2007.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How How do I change the default alignment to vertical center? Brian Setting up and Configuration of Excel 0 March 6th 09 03:50 PM
Alignment: Center text but Right numbers. Brad E. Excel Worksheet Functions 2 August 19th 08 08:07 PM
Problem Deleting all rows from List Object Dean[_10_] Excel Programming 1 April 19th 06 02:36 PM
Help!! I have problem deleting 2500 rows of filtered rows!!!! shirley_kee Excel Discussion (Misc queries) 1 January 12th 06 03:24 AM
Help!!! I have problem deleting 2500 rows of filtered rows shirley_kee[_2_] Excel Programming 1 January 12th 06 03:15 AM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"