If you want to keep a row of data visible at all times, even when you've scrolled down the sheet, you can freeze it. You can set this row to print on all pages as well, which can be very useful for spreadsheets that span multiple pages. See the next section for details. You can set Excel to freeze rows and columns so that they are always visible. To do this, you'll want to select the cell in the corner of the area you want to keep unlocked. For example, if you want to keep the top row and the first column locked on the screen, highlight cell B2. All columns to the left will be frozen, and all rows above will be frozen. This will lock the rows above your selected cell and the columns to the left of your selected cell. For example, if you had cell B2 selected, the top row and the first column will be locked on the screen. Create a visual contrast for this row by centering the text in these cells, applying bold text, adding a background color, or drawing a border under the cells. this can help the reader take notice of the header when reading the data on the sheet.
व्यू (View) टैब पर क्लिक करें: जिस पंक्ति और कॉलम को आप फ्रीज करना चाहते हैं, उसके ठीक नीचे के फ्रेम को सेलेक्ट करें: "फ्रीज पेन्स Freeze Panes" बटन पर क्लिक करें और "फ्रीज पेन्स" सेलेक्ट करें: अपने हेडर पंक्ति को आकर्षक बनाएँ (वैकल्पिक):