Home  >  Article  >  Topics  >  How to fix columns in excel so they don’t scroll

How to fix columns in excel so they don’t scroll

尚
Original
2020-04-22 14:49:3219199browse

How to fix columns in excel so they don’t scroll

For a spreadsheet that has not been fixed, when the table is dragged or scrolled, the information in the first row or column that needs to be fixed disappears as the table is scrolled.

Let’s take a look at how to set a fixed column in Excel without scrolling:

1. Select a cell in front of the column that needs to be fixed

How to fix columns in excel so they don’t scroll

2. Then select "View" - "Freeze Panes" - "Freeze Split Panes"

How to fix columns in excel so they don’t scroll3. The effect is as follows

How to fix columns in excel so they don’t scroll

Recommended learning: Excel basic tutorial

The above is the detailed content of How to fix columns in excel so they don’t scroll. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn