Lock row in excel 2008 for mac

In excel 2008 for mac, how do i lock certain cells of a. Freeze or lock rows and columns in an excel worksheet. If you needed for example the first three rows frozen, just go to fourth row and select freeze panes. Freeze panes to lock the first row or column in excel 2016 for mac. Split panes to lock rows or columns in separate worksheet areas. If you need to lock the first row of your sheet in microsoft excel, you have to use the freeze panes. 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. Excel s freeze panes feature solves this problem by letting you lock specific rows so theyre always visible when you scroll. 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 rows 1 to 3 left in place.

Getting started wtih excel 2008 mac university of michigan library. Freeze rowsmac excel 2008 select a2, then windowfreeze panes. Freeze panes to lock the first row or column in excel for mac excel. Lock rows and columns with freeze panes or split duration. Then click the freeze panes and select freeze top row from the menu that opens.

How to freeze rows and columns in excel for mac 2011. How to freeze rows and columns in excel 2008 youtube. Freeze panes to lock the first row or column in excel for mac. Excel functions alphabetical excel functions by category. How to find and delete duplicates in excel 2008 for mac. This lesson explains how to freeze rows and columns officially known as freeze panes in excel 2010 for windows and excel 2011 for mac. What to do when the freeze panes command is disabled in excel. 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. How to select multiple rows columns off screen in mac excel duration. As long as you are in normal view, not page layout view, as emerald said, you should be fine.

Arial renaud teaches you how to freeze row s and columns in excel 2008 for the mac. How to lock the top row in excel freeze panes the keenet. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. How to freeze rows and columns in excel 2016 and newer. To hide a column or row, put your cursor on any cell in the column or row, go to. Lock cells to protect them in excel for mac excel for mac. 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. 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. Heres how to freeze rows and columns in excel 2016. 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. I have all my data in one column and i need to find and remove duplicates. Excel provides a very easy way to freeze rows and columns. How do i freeze first row in microsoft ex apple community.