MS Excel How To Freze Panes

Oleh Electricity Software Treatment

Friday, November 6, 2015

Bagikan :

Tweet

Try to see whether there was something strange in the picture above? yap, after column B contained the letter F. Should after B is C? Probably from my friends already knows, but this does not hide columns ya know. This is FREEZE panes. This will be discussed this time. Hopefully useful yes
Okay. Here we have a problem, that is, when the data that we have had a lot of columns (column) and rows (rows). But as a benchmark or indukannya, we need the data at the beginning of the column or row. For example, the data value of students for a year. So we look at the data (sample) in column AN, owner of the line to 14 worth 90. Well, yes if complicated also must scroll here and there. So here we need Freeze Panes. gausah talk much more, here's how:

1. Open your Excel file, select the sheet you are going to freeze-kan.
2. Activate one cell by clicking it's up, but ...
It intends, columns and rows you are going to freeze-kan is rows and columns before the active cell. for example: if you activate or click on cell C4, then the column will you freeze-kan is column B to A; and the line you are going to freeze-kan is a line of 3 to 1.
3. Open the Tab View → Freeze Panes
As the picture above
4. Click Freeze Panes
Duh, Freze Panes again? This clay nih aja 5. It's So deh
Try scrolled. This means that you are already mem-freeze columns and rows at once.
In my opinion, the success or failure is determined by the position of the active cell (step 2). So yes a little more thoroughly. Apologize in advance, may be useful. Thank you

Tag : Office Skill