Information on how to Excel freeze columns

Date:

2018-03-22 23:43:09

Views:

562

Rating:

1Like 0Dislike

Share:

Table of contents:

Today we talk about how to Excel freeze columns. While working with a variety of tabular data there is often a need to see the headers of the rows or columns during the whole process, at every moment of time, regardless of the cursor position-scrolling. Fortunately, the application includes a special feature that can help us.

Preparation

how to excel freeze columnsIn order to solve the question of how to Excel freeze columns and rows, run the table editor and open the file in it with required data. Next, go to the desired page of the document.

Instructions

how to freeze a column in excelFor a start I will explain how to freeze a column in Excel, if you use the application version 2010 or 2007. Fasten the left column of the sheet. To do this, go to the tab called “Views”. Reveal a drop-down list that allows you to freeze panes. It is placed in a special group of teams, United under the name “Window”. We need the bottom line of the list. It is responsible for pinning the first column. Click on it with the mouse or select using the button with the letter “y”.

Go right

Now look at how to Excel freeze columns if only the first of them is not enough. Allocated to the relevant column. It should be located to the right extreme column anchoring group. With this purpose, click with the left mouse button the header describes the column that is the cell above the top row. During the guidance of cursor to the desired area it changes appearance and turns into a black arrow. Open the list "freeze panes", which is located in the tab “”, you can find it in the main menu of the editor. This time select the upper row. It is also known as "freeze panes". This item may not appear in the menu. This is possible if a sheet already contains a different fixed region. If so specified in the list will take the function off freeze panes. Choose it first. Then re-open the list and use returned to its rightful place function "freeze panes". If you use the version of the table editor "2003" here the menu is different. Therefore, in this case by highlighting the column that follows dockable, expandable section “Window”. Next, select the line called. When you need to secure not only a certain number of columns, but several rows, execute the steps described below. Select the first cell of the floating region, that is, the upper, left. In the next stage, application version 2007 or 2010 repeat the steps above. With regard to the publication "2003" here you must select "freeze panes" in the section “Window”.

Recommended

How to get out of

How to get out of "Skype" on the "Android" and not only

How to get out of "Skype" "Android"? This question bothers many users. The thing is that the messenger is not so difficult. But there are features that are only for mobile versions. To log out of Skype in this case more difficult than it seems. But i...

Kingo ROOT: how to use the program to gain administrative rights on Android

Kingo ROOT: how to use the program to gain administrative rights on Android

The Gadgets on the platform Android regained the lion's share of the market. Developers are continually perfecting the OS, trying to fit the needs of the users, but from year to year admit palpable mistake: forbid the owner to "stuffing" of his gadge...

How to get from Stormwind to Tanaris: practical tips

How to get from Stormwind to Tanaris: practical tips

World of Warcraft is an iconic MMORPG, uniting millions of players around the world. There are many locations and puzzles, secret trails and larger, but rather dangerous paths. Sooner or later, every player chose the side of the Alliance, we have to ...

More features

how to excel freeze columns and rowsNow you know how to Excel freeze columns, but you also can't do without importing new rows or columns. So, you start with a document in which such planned changes, and create the necessary table. Reserve material, giving it an arbitrary name. In the cell that is to the right in the table, enter the value or text. Add a column with the mouse. Floating to the right label that changes the size. It is in the lower corner of the table. Thus, columns will be added. To determine where to place new elements in advance. Illuminated the place. The number of selected cells should be equal to the number of blank lines that you want to add. If you want to insert nonadjacent items, hold down CTRL during selection. Go to the tab “Main”, use the group “Cell”. Click on the arrow next to the “Insert”. So we figured out how to Excel freeze columns.


Article in other languages:

AR: https://www.tostpost.com/ar/computers/4866-information-on-how-to-excel-freeze-columns.html

BE: https://www.tostpost.com/be/kamputary/8658-padrabyazna-pra-toe-yak-u-excel-zamacavac-sto-bcy.html

DE: https://www.tostpost.com/de/computer/8659-einzelheiten-wie-sie-in-excel-spalten-fixieren.html

ES: https://www.tostpost.com/es/los-ordenadores/8665-los-detalles-de-c-mo-inmovilizar-las-columnas-en-excel.html

HI: https://www.tostpost.com/hi/computers/4868-excel.html

JA: https://www.tostpost.com/ja/computers/4866-excel.html

KK: https://www.tostpost.com/kk/komp-yuterler/8661-alay-excel-de-bek-tuge-ba-andar.html

PL: https://www.tostpost.com/pl/komputery/8663-szczeg-owo-o-tym-jak-w-programie-excel-zablokuj-kolumny.html

PT: https://www.tostpost.com/pt/computadores/8659-detalhes-sobre-como-congelar-colunas-no-excel.html

TR: https://www.tostpost.com/tr/bilgisayarlar/8665-ayr-nt-l-olarak-nas-l-excel-s-tunlar-dondur.html

UK: https://www.tostpost.com/uk/komp-yuteri/8662-dokladno-pro-te-yak-v-excel-zakr-piti-stovpc.html

ZH: https://www.tostpost.com/zh/computers/5298-excel.html






Alin Trodden - author of the article, editor
"Hi, I'm Alin Trodden. I write texts, read books, and look for impressions. And I'm not bad at telling you about it. I am always happy to participate in interesting projects."

Comments (0)

This article has no comment, be the first!

Add comment

Related News

His Majesty is a driver for network card

His Majesty is a driver for network card

for the owners of personal computers it is difficult to imagine that only some 5-10 years ago motherboard with integrated network card was a rarity rather than the rule. Currently, the situation has radically changed, that can not...

As reprivatise territory for a friend in Minecraft?

As reprivatise territory for a friend in Minecraft?

If you play in single player mode "Minecraft", then you do not have to think about the safety of your property. The fact that your opponents mobs, which, of course, seek to destroy your dwelling place, but to keep them simple-just...

iTunes is not installed: how to fix the problem?

iTunes is not installed: how to fix the problem?

When I try to install multimedia apps from Apple iTunes for Windows is very common to find errors related to the inability to install this package in the operating system environment. What is the reason, so to speak, in a global s...

How to open Docx?

How to open Docx?

In this article we will look at three basic ways to open Docx. With the release of Microsoft Office 2007, which began to use new formats to save documents, such as .docx, .pptx .xlsx, increasingly, the question “how to open ...

Who is Gabe Newell? Success story

Who is Gabe Newell? Success story

Every gamer can confidently say who is Gabe Newell. The genius of computer games have achieved great success in all their endeavors. In his hands is concentrated the power over one of the most famous and profitable studios Valve C...

Why during games the computer is turned off: reason

Why during games the computer is turned off: reason

Perhaps, with the spontaneous shut down or restart the personal computer at the crucial moment of the exciting game faced each user. However, even laptop owners often wonder why turn off the comp during the game. This behavior of ...