banner



How To Connect Two Ball Locks Together To Clean Lines

To keep an area of a worksheet visible while you scroll to some other area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or y'all can Split panes to create dissever windows of the same worksheet.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Freeze rows or columns

Freeze the kickoff column

  • SelectView>Freeze Panes >Freeze First Column.

            The faint line that appears between Column A and B shows that the get-go column is frozen.

Freeze the kickoff two columns

  1. Select the third column.

  2. SelectView> Freeze Panes >Freeze Panes.

Freeze columns and rows

  1. Select the cell below the rows and to the right of the columns y'all want to keep visible when yous ringlet.

  2. SelectView>Freeze Panes >Freeze Panes.

Unfreeze rows or columns

  • On the View tab > Window > Unfreeze Panes.

    Unfreeze Panes

    Notation:If you don't come across the View tab, it's likely that you are using Excel Starter. Not all features are supported in Excel Starter.

Demand more aid?

You tin always ask an practiced in the Excel Tech Customs or become support in the Answers community.

Meet Likewise

Freeze panes to lock the first row or column in Excel 2022 for Mac

Split panes to lock rows or columns in separate worksheet areas

Overview of formulas in Excel

How to avoid broken formulas

Find and correct errors in formulas

Keyboard shortcuts in Excel

Excel functions (alphabetical)

Excel functions (by category)

Demand more aid?

Source: https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f

Posted by: garrisoncrinver.blogspot.com

0 Response to "How To Connect Two Ball Locks Together To Clean Lines"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel