"format as same below" option as default when inse

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: "format as same below" option as default when inse

  1. #1
    New Member
    Join Date
    Oct 2007
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  3. #3
    New Member
    Join Date
    Oct 2007
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,832
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    you're WELCOME

    Enjoy the Board!!
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

User Tag List

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