Home » Accounting » How To Create Column That Does Not Move In Excel

How To Create Column That Does Not Move In Excel

Download Business Management Templates Excel Dashboards KPI Reports

If you create a Microsoft excel sheet with big number of excel columns, it could be difficult to compare information in columns spaced because you have to scroll to see the information and cannot see each columns at the same time. For the reason, Excel enables you to make excel column that does not move by it set up. Freeze excel column in excel in order to prevent it from relocating. When freezing column, it stays visible in the window while you pull horizontally through the sheet.
Open excel, next open the spreadsheet which you need to freeze excel column in. Click on the letter on top of the column to right of one which you need to freeze.
Click on the Freeze Panes on the Window part of the top toolbar, and next click Freeze PanesA appears in the sheet.

Download Business Management Templates Excel Dashboards KPI Reports