How to freeze cells in microsoft excel 2007

Table of contents. Insert or delete rows, and columns Article Select cell contents in Excel Article Freeze panes to lock rows and columns Article Hide or show rows or columns Article Filter for unique values or remove duplicate values Article Split text into different columns with the Convert Text to Columns Wizard Article Create a list of sequential dates Article.

Next: Cells. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Freezing the first column locks column A of the worksheet.

This means that on moving from left to right, this column will be visible at all times. In addition, column A is fixed irrespective of the column from which the actual data begins. The data relates to various countries and is spread across the first five months of the year Freezing multiple excel columns is similar to freezing multiple rows.

For freezing multiple columns, select the first right-hand side cell immediately after the last column to be frozen.

This is because multiple columns are frozen based on the current selection. Similarly, for freezing multiple rows, select the first cell immediately below the last row to be frozen. For example, to freeze the columns A, B, and C, select the cell D1. By freezing the first three columns, they remain visible to the user at all times.

Likewise, to freeze the rows 1, 2, and 3, select the cell A4. Step 1: Select the cell E1. This is because the first four columns are to be frozen. Step 3: The first four columns are frozen. The grey line appears shown in the following image at the end of column D, indicating that the columns to the left are frozen.

The columns R and S shown in the following image are the scrolled columns towards the end of the dataset. Step 4: On scrolling from left to right till the last column of the dataset, the first four columns are visible. The same is shown in the following image.

Usually, the first row and the first column of a database contain headers. It's in the "Window" section of the toolbar. A set of three freezing options will appear.

If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row. To keep the first column in place as you scroll horizontally, select Freeze First Column. Unfreeze your cells. If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes. Method 2. Select the row or column after those you want to freeze. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze.

For example: If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row 4 to select it. If you want columns A and B to remain still as you scroll sideways through your data, click column C to select it. Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet. Click Freeze Panes on the menu. It's at the top of the menu.

This freezes the columns or rows before the one you selected. Select the row directly under the rows you want to freeze in this case, the third row. Not Helpful 10 Helpful Performing a selective startup also known as a "clean boot" can help you identify problems with conflicting applications.

To perform a selective startup, choose one of the following links depending on your version of Windows, then follow the steps in the article:. Selective startup is used to help identify the offending process, service, or application that conflicts with Excel. If your issue is not resolved after you re-create the profile, continue on to the next item on the list.

Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. For instructions on doing this, see: Repair an Office application.

If repairing your Office programs did not resolve your issue, continue on to the next item on the list. To keep up with new viruses that are created, antivirus software vendors periodically provide updates that you can download from the Internet. For a list of antivirus vendors, see: Consumer security software providers. Check whether your antivirus software is conflicting with Excel:. If your antivirus software includes integration with Excel you may experience performance issues.

In this case, you can disable all Excel integration within the antivirus software. Or, you can disable any antivirus software add-ins that are installed in Excel. Important: Changing your antivirus settings may make your PC vulnerable to viral, fraudulent or malicious attacks.

Microsoft does not recommend that you attempt to change your antivirus settings. Use this workaround at your own risk. You may have to contact your antivirus software vendor to determine how to configure your software to exclude any integration with Excel or to exclude scanning in Excel. If the methods that were mentioned earlier did not resolve your issue, the issue could be either file specific, or environmental.

The following section describes how to troubleshoot additional issue that can cause Excel to hang, or crash. Environmental factors are just as important as file contents, and add-ins when you are troubleshooting crashes. You can help determine the cause of your issue by taking the following actions:. Moving the file locally will help determine whether there is something wrong with the file, or with where the file is saved.

Several issues can arise when you save an Excel file over a network or to a web server.