Hello friends I am Sameer and welcome to my blog Sameer Pro Tech. In this article, I will tell you how to unhide rows and columns in excel.
The Freeze panes facility in Microsoft Excel can freeze and lock some rows or columns of the data sheet that we have so that the rows or columns will always be displayed even if we scroll down/up (vertical) or left/right (horizontally) view sheets. This will really help us when entering data in tables that have a large number of rows or columns. Because by using freeze panes, the column headings located at the top, or the row identifiers (eg numbers, names or others) located on the left will always be visible. Thus, errors in filling and reading data in columns or rows will be avoided. If you want Best way to How to Hide Columns in Excel.
1. Set the display on your worksheet so that columns and rows appear that are always visible
2. Then move the excel cursor position in the upper left cell of the scrollable part.
3. Then click Ribbon View
4. Then in the Window group click the Freeze Panes button
5. Next you will be given three options to Freeze the heat:
- Freeze Panes , to freeze rows and columns according to the excel cursor position (which we have selected earlier)
- Freeze Top Row , to freeze and keep only the first row always visible
- Freeze First Column , to freeze and make only the first column always visible
- SELECT or Click the Freeze Panes item to keep rows and columns always appearing on the screen
6. The rows and columns that have been selected will remain visible on the screen.
In the picture above, the light blue cells will always be visible even if we scroll vertically or horizontally. Thus the process of reading, displaying and editing / data entry will become easier. For the example above, we can still see which spare part and what month we are currently selecting/editing because every time we scroll vertically down/up, the table head or column headings (No, Code, Spare Part Name, January, etc.) will remain. in position and does not move. Meanwhile, if we slide horizontally to the right/left, the contents of the column No, Code and Sparepart Name will also remain in position and do not move. If you want Best Method to How to Create a Pivot Table in Excel.
Tips on How to Make Columns or Rows Always Appear in Microsoft Excel
When you create Freeze Panes (including the Freeze Top Row or Freeze First Column options ), the Freeze Panes selected item will change its name to Unfreeze Panes . To remove the freeze panes and return the rows and columns to their original state (lost when scrolled), click the Unfreeze Panes item.