How to keep Excel and Excel columns fixed?

Fixed Excel box, fixed row, fixed Excel column when scrolling mouse makes it easy to track and manipulate data sheet. In addition, you can split the Excel view area to edit on individual Excel areas.

Fixed Excel box, fixed row, fixed Excel column when scrolling mouse makes it easy to track and manipulate data sheet. In addition, you can split the Excel view area to edit on individual Excel areas.

Video tutorial fixed column, Excel row

Keep fixed Excel columns, fixed Excel rows

Step 1 : Determine the rows, columns or Excel cells that you want to keep fixed

These boxes will always be displayed on the screen while you move the scroll bar on the spreadsheet. It will be useful if you want the row or column title to always be displayed on the worksheet. But you can only fix all rows or all columns at the same time.

How to keep Excel and Excel columns fixed? Picture 1

Step 2 : Click the View menu, select Freeze Panes > Freeze Top Row (in case you want to fix the top row )

How to keep Excel and Excel columns fixed? Picture 2

Step 3 : If you want to permanently add the first column, select Freeze First Column

How to keep Excel and Excel columns fixed? Picture 3

Step 4 : To cancel the fixed boxes, just click Unfreeze Panes and you 're done

How to keep Excel and Excel columns fixed? Picture 4

Split multiple views

Split the viewing area to help you scroll the mouse wheel to see each part individually. It is very useful for large spreadsheets that you need to operate on multiple areas at once.

Before you can place the mouse pointer under the fixed row then click on the Split tool in the View menu. Immediately the screen will split into two parts, you can operate independently on both parts.

How to keep Excel and Excel columns fixed? Picture 5

To return to the original state, just click the Split icon again.

  1. MS Excel - Lesson 4: Working with lines, columns, sheets
  2. How to temporarily hide rows and columns in Excel 2013
  3. Change color between different lines in Microsoft Excel

Good luck!

« PREV POST
NEXT POST »