Share via

Add horizontal line in excel to create a separation.

Anonymous
2022-03-10T18:30:40+00:00

Hi,

I need to add a horizontal line in excel. This line will keep the top 10 lines visible while I can scroll down the remaining bottom data lines.

Thanks,

Joe

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. triptotokyo-5840 36,681 Reputation points Volunteer Moderator
    2022-03-10T18:35:01+00:00

    Hi,

    I need to add a horizontal line in excel. This line will keep the top 10 lines visible while I can scroll down the remaining bottom data lines.

    Thanks,

    Joe

    Inset tab

    Click on the drop down arrow beneath:-

    Illustrations

     - then click on:-

    Shapes

     - then click on:-

    Line

     - then draw the line where you want it on the EXCEL Worksheet.

     OR in addition / substitution of the above:-

     - click in cell A 11 then:-

    View tab

    Window group

    Click on the drop down arrow to the right of:-

    Freeze Panes

     - then click on:-

    Freeze Panes

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-29T20:25:27+00:00

    Thanks!

    0 comments