HomeApplicationOffice informationHow to fix columns in Excel

How to fix columns in Excel

For Excel spreadsheets that have a large number of columns, you want to freeze the first columns so that when you move the mouse over the column larger than the number of columns displayed in Excel, these columns remain the same. If you do not know how to fix columns in Excel, you can refer to the following article.

How to fix columns in Excel Picture 1

Below article will guide you in detail how to fix columns in Excel.

Freeze first column in Excel worksheet

On the Excel worksheet, you need to fix the first column, select View -> Freeze Panes -> Freeze First Column.

How to fix columns in Excel Picture 2

So the first column in the spreadsheet will be fixed, you can drag to the data in how many columns the first column will still show.

How to fix columns in Excel Picture 3

Freeze multiple columns in Excel spreadsheets

If you want to freeze more columns than just the first column, follow these steps:

Step 1 : Place your cursor in the first cell in the column next to the columns you want to freeze, or select all of them.

Note: all the columns to the left of the column where you place the mouse cursor will be fixed, the column where the mouse cursor is will not be fixed. Fixed columns always start from the first column (column A), you can't fix multiple columns in the middle of the worksheet. You need to determine the right position of the mouse cursor to fixed columns more accurately .

For example, if you want to fix the HS column and the HS Name column , you put the mouse pointer in the first cell in the next column which is C3 is Specialized Class.

How to fix columns in Excel Picture 4

Step 2: Click the View -> Freeze Panes tab -> Freeze Panes to freeze the columns before the column you select.

How to fix columns in Excel Picture 5

Thus, you have fixed many columns for Excel worksheet, the fixed columns will always be displayed no matter you move the mouse to the nth column in the data file with many columns.

How to fix columns in Excel Picture 6

How to unfreeze columns

If you have fixed the column and have finished processing the data on the Excel spreadsheet, you want to remove the column so that the Excel spreadsheet to its original form, you just need to select View -> Freeze Panes -> Unfreeze Panes.

How to fix columns in Excel Picture 7

Above is how to fix columns in Excel, if you want to fix both rows and rows, then you should refer to the tutorial here http://TipsMake.vn/cach-co-dinh-cot -va-dong -ieu-de-in-excel-2016 /.

Hope the article will help you. Good luck!

5 ★ | 2 Vote

You should read it

May be interested

  • Find and delete duplicate data in ExcelPhoto of Find and delete duplicate data in Excel
    find and delete duplicate data in excel. in the process of working with excel spreadsheets, there will be excel files with large amounts of data so duplication of data is very common. there are cases where duplicate data is useful, but sometimes values ​​are
  • How to calculate totals in ExcelPhoto of How to calculate totals in Excel
    how to calculate totals in excel. when it comes to summarizing in excel, you often think of using the sum function to sum the data in excel. but there are many cases where a simple data area, just a column or a row of data, you can use fish
  • How to turn on, turn off, delete Macro in ExcelPhoto of How to turn on, turn off, delete Macro in Excel
    how to turn on, turn off, delete macro in excel. macros help you save more time processing data in excel, bringing greater efficiency at work. if you are new to macros in excel, then turning on, off, and deleting macros is not much
  • How to split cells, combine cells in ExcelPhoto of How to split cells, combine cells in Excel
    how to split cells, combine cells in excel. on excel spreadsheets, many times you need to split cells, merge cells to fit the data you need to enter. you can combine two or more cells together using excel's built-in functions or use visual basic to merge
  • How to rotate any 1 page size paper in WordPhoto of How to rotate any 1 page size paper in Word
    instructions on how to convert a single page to horizontal paper size, the remaining pages remain the default vertical format in word. the default in text editing often to paper vertical size. however, the case of combined reports that exceeds the required length of vertical paper
  • How to edit PDF files with Word 2016Photo of How to edit PDF files with Word 2016
    how to edit pdf files with word 2016. previously, to edit pdf files we need specialized pdf processing software, but word 2016 and onwards has built-in very powerful pdf editing function, if if you do not know this feature then follow up

Office information