Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Sep 2012
    Posts
    13
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excel formatting

    I am using MS Office 2010 Excel program. When formatting a column I format it for the style and type I want to enter. If I add lines between the formatting the sheet defaults to some other style. How can I format a column to stay the same through all entries?

  2. #2
    3 Star Lounger
    Join Date
    Apr 2012
    Posts
    240
    Thanks
    3
    Thanked 24 Times in 24 Posts
    I can't reproduce your problem. I formatted 3 columns, one text, one date, one time. I entered a name, date and time into two rows and all showed up correctly.
    I inserted a new row between the formatted rows and entered a name, date and time, which all showed up correctly.

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    371
    Thanked 1,457 Times in 1,326 Posts
    Capn-Ken,

    Can you post a sample workbook that exibits the problem?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post
    It depends on how you "Add lines", If you right click the number to the left of the row and click insert, it will insert a complete row with the same formatting as the row above. It also provides you with a drop=down gizmo(in col A below the new row) which lets you select "Format as above", "Format as below". or "Clear formatting". You can ignore the gizmo and it disappears when you do anything else on the sheet.

    If you select a part of the row, right click it and click Insert then "shift cells down" or "Entire row" the behaviour is similar except with the first option the gizmo is to the right and below the inserted cells.

    If however you select cells, right click, click insert, and click "shift cells right" it will insert new unformatted cells in the selected area. the shifted cells will retain their original formatting.

    You can turn the gizmo off. File/Options/Cut, Copy, and paste section/ Show insert options buttons.

    I cannot find any way to change the default insert option. On my set up it seems to default to "same as above"
    David Grugeon
    Brisbane Australia

  5. #5
    New Lounger
    Join Date
    Sep 2012
    Posts
    13
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks for the tips, I think I have figured the problem out. I am keeping a checkbook with Date, Type, Payee, Amount, Deposit and balance on one row. That works OK when a row is added to the bottom of the list, however, I keep mine running up instead of down, so when I insert a row at the top the formatting doesn't get picked up! Thanks again to all who responded.
    Capn Ken

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    371
    Thanked 1,457 Times in 1,326 Posts
    Ken,

    If you place a blank row below your title row, i.e. row 2 and format it like you want then you can insert between row 2 & 3 and keep the formatting.
    You can then place your cursor in A3 and select Freeze Panes from the View tab. Once frozen use the mouse to drag the dividing line between the row numbers up so that only row 1 shows (basically you're setting the height of row 2 to 0).
    Now the blank row is effectively hidden but will still affect formatting on insert operations.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  7. #7
    New Lounger
    Join Date
    Sep 2012
    Posts
    13
    Thanks
    0
    Thanked 1 Time in 1 Post
    RG Thank you, Thank you, Thank you, it works and will save me a lot of time reformatting.

    Regards

    Capn Ken

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •