Tutorial How to Make Columns and Rows in Microsoft Excel Not Moving

Easy and practical, this is how to create columns and rows in Microsoft excel.

Microsoft Excel. (Microsoft)

Hitekno.com – How to make column and CLASSIFIED on Microsoft Excel You can do not move easily using the built-in feature of the Microsoft Excel program itself called Freeze Panes. Follow tutorial Microsoft Excel which the HiTekno.com team has summarized below.

You can find the Freeze Panes feature at the top of the View menu tab in the Microsoft Excel window.

So by using the Freeze Panes feature, the columns and rows in your Microsoft Excel document will not move when shifted, even if you scroll down or to the side.

Therefore, the Freeze Panes feature is usually used to lock or make the first column or first row in an excel worksheet not move.

The display of Excel documents that have used the Freeze Panes feature will be marked with a thin line at the place where the Excel worksheet is locked.

The Freeze Panes feature itself consists of 3 choices of menu options, namely the Freeze Panes menu option that you can use to lock some of the columns and rows that you choose (blocks) on a sheet.

Then the Freeze Top Row menu option that you can use to lock the first row of the currently active sheet, and the Freeze First Column menu option that you can use to lock the first column of the currently active sheet.

Then for the full tutorial, you can follow the steps below if you want to know How to create columns and rows in Microsoft Excel not moving:

• Open your Microsoft Excel document
• When your Microsoft Excel document is open, place the cursor on the cell you want to make the scroll reference angle or the columns and rows you want to lock so that it does not move.
• Then on the menu bar at the top of the Microsoft Excel program, select the View menu tab
• Locate the Window Group containing the Freeze Panes menu and click
• Then 3 menu options will appear, namely Freeze Panes, Freeze Top Row, and Freeze First Column
• Click on the Freeze Panes menu option to make the columns and rows in Microsoft Excel not move
• Done! After that the columns and rows that you selected previously will not move even if you scroll right or down

That’s how to make columns and rows in Microsoft Excel not move, which will make it easier for you to do document processing. Good luck with the Microsoft Excel tutorial above!

Contributor: Jeffry francisco

–