Results 1 to 4 of 4

"format as same below" option as default when inse

This is a discussion on "format as same below" option as default when inse within the Excel Questions forums, part of the Question Forums category; I want to use "format as same below" option as default when I insert a row. Could you please tell ...

  1. #1
    New Member
    Join Date
    Oct 2007
    Posts
    2

    Default "format as same below" option as default when inse

    I want to use "format as same below" option as default when I insert a row. Could you please tell me how can I do it?

    I have a spreadsheet on which I constantly need to add a new row below the top two rows. My first two rows are formatted differently from the rest of the file. When I insert a row below them, Excel formats it automatically as same above, which I have to change manually each time. I want it to format inserted row as same below, not as same above. Please help.

  2. #2
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,767

    Default

    Hi, ryukun
    Welcome to the Board!!!!!

    The most easy solution which comes to my mind is to insert an extra hidden row (row 3).

    kind regards,
    Erik

  3. #3
    New Member
    Join Date
    Oct 2007
    Posts
    2

    Default

    That is the solution!! Thank you very much!

  4. #4
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,767

    Default

    you're WELCOME

    Enjoy the Board!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com