Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. Scroll down to the rest of the worksheet. If you see inaccuracies in our content, please report the mistake via this form. To freeze the top row, select row 2 and click the magic Freeze button. If we have made an error or published misleading information, we will correct or clarify the article. Our editors thoroughly review and fact-check every article to ensure that our content meets the highest standards. All rows above the selection will be non-scrolling. Our goal is to deliver the most accurate information and the most knowledgeable advice possible in order to help you make smarter buying decisions on tech gear and a wide array of products and services. Select the row below the row you want to be in the non-scrolling region. The primary purpose of a Calc document is to contain multiple spreadsheets, which in turn contain rows and columns of data - in other words, tables. ZDNET's editorial team writes on behalf of you, our reader. When using an Open Office Calc Spreadsheet additional rows or columns can be inserted by > Insert > and from the Drop Down > Row (or Column). After that, Go to the View tab and click on the Split icon. This selection will act as a reference for freezing rows and Excel will freeze all the rows which are at the top of the selected row. This option is located in the same place where New Window and Arrange All are located. For large spreadsheets that do not fit completely in the window, it is useful to be able to freeze the row and/or column headers to better view the data. Here, you are selecting the 4th row because you want to freeze the top 3 rows. Select Freeze Panels and click Freeze Panels. In this example, we want to freeze rows 1 through 5, so we chose row 6. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers. To freeze columns, select the cell immediately to the right of the column you want to freeze. Neither ZDNET nor the author are compensated for these independent reviews. This helps support our work, but does not affect what we cover or how, and it does not affect the price you pay. When you click through from our site to a retailer and buy a product or service, we may earn affiliate commissions. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. ZDNET's recommendations are based on many hours of testing, research, and comparison shopping.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |