Outlook I Cannot Read Text in Pane
The tutorial shows how to freeze cells in Excel to proceed them visible while you lot navigate to another surface area of the worksheet. Below you will find the detailed steps on how to lock a row or multiple rows, freeze one or more columns, or freeze cavalcade and row at once.
When working with large datasets in Excel, you lot may often want to lock sure rows or columns so that you can view their contents while scrolling to some other area of the worksheet. This can be hands done by using the Freeze Panes command and a few other features of Excel.
How to freeze rows in Excel
Freezing rows in Excel is a few clicks affair. You just click View tab > Freeze Panes and choose one of the post-obit options, depending on how many rows you wish to lock:
- Freeze Top Row - to lock the start row.
- Freeze Panes - to lock several rows.
The detailed guidelines follow below.
How to freeze tiptop row in Excel
To lock acme row in Excel, get to the View tab, Window grouping, and click Freeze Panes > Freeze Height Row.
This will lock the very first row in your worksheet and so that it remains visible when yous navigate through the rest of your worksheet.
You lot can determine that the top row is frozen past a grey line below it:
How to freeze multiple rows in Excel
In case yous desire to lock several rows (starting with row 1), comport out these steps:
- Select the row (or the beginning jail cell in the row) correct below the last row yous want to freeze.
- On the View tab, click Freeze Panes > Freeze Panes.
For case, to freeze elevation two rows in Excel, we select cell A3 or the unabridged row 3, and click Freeze Panes:
As the result, you lot'll exist able to scroll through the sheet content while continuing to view the frozen cells in the offset two rows:
Notes:
- Microsoft Excel allows freezing only rows at the top of the spreadsheet. It is not possible to lock rows in the center of the sheet.
- Make sure that all the rows to be locked are visible at the moment of freezing. If some of the rows are out of view, such rows will be hidden afterwards freezing. For more data, please see How to avoid frozen hidden rows in Excel.
How to freeze columns in Excel
Freezing columns in Excel is done similarly past using the Freeze Panes commands.
How to lock the start cavalcade
To freeze the get-go column in a sheet, click View tab > Freeze Panes > Freeze First Column.
This will make the leftmost column visible at all times while you curl to the right.
How to freeze multiple columns in Excel
In case yous want to freeze more one column, this is what you demand to do:
- Select the cavalcade (or the first prison cell in the column) to the right of the last column yous want to lock.
- Go to the View tab, and click Freeze Panes > Freeze Panes.
For case, to freeze the first ii columns, select the whole column C or cell C1, and click Freeze Panes:
This will lock the first two columns in identify, every bit indicated by the thicker and darker border, enabling you lot to view the cells in frozen columns as you motion across the worksheet:
Notes:
- You can simply freeze columns on the left side of the sheet. Columns in the centre of the worksheet cannot be frozen.
- All the columns to exist locked should exist visible, whatever columns that are out of view will exist hidden afterwards freezing.
How to freeze rows and columns in Excel
Besides locking columns and rows separately, Microsoft Excel lets y'all freeze both rows and columns at the aforementioned time. Here'southward how:
- Select a jail cell below the final row and to the right of the terminal column you'd like to freeze.
- On the View tab, click Freeze Panes > Freeze Panes.
Yeah, it'south that like shooting fish in a barrel :)
For example, to freeze top row and get-go column in a single step, select cell B2 and click Freeze Panes:
This way, the header row and leftmost column of your table volition always be viewable as you scroll down and to the correct:
In the same fashion, you lot can freeze as many rows and columns as you lot want as long equally y'all get-go with the top row and leftmost cavalcade. For instance, to lock top row and the first 2 columns, you select jail cell C2; to freeze the starting time two rows and the first two columns, you select C3, and so on.
How to unlock rows and columns in Excel
To unlock frozen rows and/or columns, go to the View tab, Window group, and click Freeze Panes > Unfreeze Panes.
Freeze Panes not working
If the Freeze Panes push button is disabled (greyed out) in your worksheet, nearly likely it's considering of the following reasons:
- You are in cell editing manner, for case inbound a formula or editing data in a cell. To exit cell editing mode, press the Enter or Esc primal.
- Your worksheet is protected. Delight remove the workbook protection commencement, and so freeze rows or columns.
Other ways to lock columns and rows in Excel
Apart from freezing panes, Microsoft Excel provides a few more ways to lock sure areas of a canvass.
Split panes instead of freezing panes
Another fashion to freeze cells in Excel is to split a worksheet area into several parts. The difference is every bit follows:
Freezing panes allows you to continue sure rows or/and columns visible when scrolling across the worksheet.
Splitting panes divides the Excel window into 2 or four areas that tin be scrolled separately. When you lot roll within one area, the cells in the other area(s) remain fixed.
To dissever Excel'southward window, select a cell below the row or to the right of the column where you desire the dissever, and click the Separate button on the View tab > Window grouping. To disengage a separate, click the Dissever button again.
Apply tables to lock top row in Excel
If you'd similar the header row to always stay fixed at the summit while yous whorl downwardly, catechumen a range to a fully-functional Excel tabular array:
The fastest way to create a tabular array in Excel is by pressing the Ctl + T shortcut. For more information, delight come across How to make a table in Excel.
Print header rows on every page
In case you'd like to repeat top row or rows on every printed page, switch to the Folio Layout tab, Page Setup grouping, click the Print Titles push, go to the Sheet tab, and select Rows to echo at top. The detailed instructions can be plant here: Print row and column headers on every page.
That'south how you can lock a row in Excel, freeze a cavalcade, or freeze both rows and columns at a time. I cheers for reading and hope to see you on our blog next calendar week!
You lot may also be interested in
felicianosmandertne.blogspot.com
Source: https://www.ablebits.com/office-addins-blog/freeze-rows-columns-excel/
0 Response to "Outlook I Cannot Read Text in Pane"
Postar um comentário