![]() Freezing Several Rows / Panes In Excel On A MACĪs you must have noticed, the Column headings go out of view and are no longer visible when you scroll down in an Excel worksheet. Let us know in the comments below!If you are usually working with large worksheets, it is really important that you become familiar with the steps to Freeze Rows and Columns in Excel. Be sure to check out some of our other Numbers tutorials for helpful tips like how to merge cells or how to convert columns and rows. The ability to freeze columns and rows in Numbers is a convenient feature to keep in mind, especially as your spreadsheets grow. You can also adjust these numbers later if necessary. ![]() You can do this by tapping any area of the table. ![]() ![]() For example, if column A is frozen, you cannot freeze column C. Just note that the additional column or row you want to freeze must be next to another header column or row. You can follow those same steps to add more columns or rows, or alternatively use the instructions below. Once you make the change, you will notice that you can scroll and not lose sight of those headers. You can also click the Header Rows and Header Columns options to select the number of rows or columns to freeze. You can do this by clicking any area of the table. Sandy Writtenhouse on November 2, By freezing one or both of these areas, you can scroll through large spreadsheets while still being able to see the headers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |