How to freeze rows and columns in excel 2008 youtube. Freeze or lock rows and columns in an excel worksheet. I am making an order form i will be emailing to clients for them to fill out the quantities they would like, but i dont want anything else on the page to be modifiable. How to lock the top row in excel freeze panes the keenet. Freeze panes to lock the first row or column in excel for mac excel. This command enables you to lock certain rows or columns onscreen so that as you scroll down or to the right, the frozen rows andor columns. Freeze panes to lock the first row or column in excel 2016 for mac. Excel functions alphabetical excel functions by category. In excel 2008 for mac, how do i lock certain cells of a worksheet, but allow for other parties to enter information into others on the same sheet. Then click the freeze panes and select freeze top row from the menu that opens. This lesson explains how to freeze rows and columns officially known as freeze panes in excel 2010 for windows and excel 2011 for mac. Heres how to freeze rows and columns in excel 2016.
Freeze rowsmac excel 2008 select a2, then windowfreeze panes. To hide a column or row, put your cursor on any cell in the column or row, go to. Lock specific rows or columns in place by freezing panes, so you can scroll through an excel spreadsheet and still see the top row or left column. When you do this, the border under row 1 is a little darker than other borders. If you needed for example the first three rows frozen, just go to fourth row and select freeze panes. This excel tutorial explains how to freeze panes to keep the first row and first column visible when scrolling in excel 2011 for mac with screenshots and.
Arial renaud teaches you how to freeze rows and columns in excel 2008 for the mac. Split panes to lock rows or columns in separate worksheet areas. How to hide all unused cells in all columns and all rows in excel spreadsheets. Then you should be able to scroll down the sheet with row 1 left in place.
How do i freeze first row in microsoft ex apple community. Excel s freeze panes feature solves this problem by letting you lock specific rows so theyre always visible when you scroll. As long as you are in normal view, not page layout view, as emerald said, you should be fine. Freeze panes to lock the first row or column in excel for mac. Excel provides a very easy way to freeze rows and columns. How to freeze rows and columns in excel 2016 and newer. This excel tutorial explains how to freeze panes to keep the top row visible when scrolling in excel 2011 for mac with screenshots and stepbystep instructions. Lock rows and columns with freeze panes or split duration. In excel 2008 for mac, how do i lock certain cells of a.
1436 533 19 948 682 369 34 1074 443 760 64 735 344 328 1079 388 1466 601 765 375 1228 710 1369 861 1250 229 1345 882 763 548 337 728 556 98 291