Advertisement You can fit a lot of data into an Excel sheet. With thousands upon thousands of rows and columns, it can get pretty unwieldy. Blu ray player for os x. One small feature that makes it easier to manage all of that data is the ability to freeze rows and columns so that no matter where you scroll in the spreadsheet, those rows or columns always stay visible. How to Freeze the First Column or Top Row in Excel With this method, you’re going to have to choose to freeze either the row or column.

Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. Note: to keep the first column visible while scrolling through the right of the worksheet, click Freeze First Column. Unfreeze Panes. To unlock all rows and columns, execute the following steps. On the View tab, in the Window group, click Freeze Panes.

Unfortunately, you can’t do both. • Open your Excel spreadsheet and go to the View tab. • Click the Freeze Panes button. • To freeze the top row, click Freeze Top Row in the dropdown menu. How to turn on universal access for steam mac. To freeze the first column, click Freeze First Column in the dropdown menu.

How to Freeze a Selection of Columns and Rows in Excel If you would prefer to freeze a combination of rows and columns, it’s possible but it’s only just slightly more tricky: • Open your Excel spreadsheet and go to the View tab. • Select the cell directly below the row you want to freeze and the cell to the right of the column you want to freeze. If you want to freeze rows 1 to 4 and columns 1 to 3, then you’ll select cell D5. If you want to freeze the top row and the first column, you’ll select cell B2. • Click the Freeze Panes button and again, click the Freeze Panes option in the drop down menu.

How to Unfreeze Columns or Rows in Excel • Open your Excel spreadsheet and go to the View tab. • Click the Freeze Panes button. • Click Unfreeze Panes in the drop down menu. To see each of these processes in action, check out this video demonstrating the feature in Excel 2016.

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun.

As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Or read our to learn how to use this site. How much RAM do you have? I didn't see your system specs.

Hi Rocky and thanks for asking. I have 16 GIGS and an I7 64 bit It's more than powerful enough. I'm not running any 3rd party software. I do run quite a bit with Macros and over 2 GIGS at a time but I can open a new sheet at times and go and out a little conditional formatting on it like =ISEVEN(2A) fill in 6 rows and 4 columns of numbers Go to copy and paste them in another column or even add a new column and it will freeze up and that particular will not open back up Now here's where it gets a little weird 'to me' I can take that same file or ANY file that crashes. Save it to a memory stick. Open it on my another computer that has Windows 7 Office 2010 Re save it with the same name, close it and then open it back up on my laptop which is Windows 8 Office 2013 and it will run fine until it decides it's ready to crash again.

It may run for a week, 2 weeks or 10 minutes I've had MS on the phone for hours and in my computer )-: fir hours and they gave no clue lol. Just so you know I have been working on hardware / software troubleshooting since computers were born and a controls systems integrator and this one has stumped me Any ideas is appreciated. It hasn't done it in a few days Can post some old error codes but they relate to the video drivers which are up to date and are fine.

Actually, there was not even an issue with them. If you take the spreadsheet and use it for a while on another computer, does it crash on the other PC? That would help determine if it's related to something on your PC or perhaps something the file itself. Were the macros first written in a 32-bit version of Office or a 64-bit version? I've never had any excel file crash using 2010 so no All my Macros were written on a 64 bit machine either my 2010 or 2013. Both machines are 64 bit Desktop I7Core 16 GIGS RAM 6 months old But it will crash with no Macros sometimes on a new sheet.

Now, u may have a book open with a Macros when it does crash. I'll pay better attention next time. I've got a bunch of users that all have Windows 10 and Excel 2013 and it freezes randomly and I've updated their Displaylink drivers (per other websites) and tried running Excel in safe mode and it still freezes. None of them have any Macros running at all. They all have 64 bit processors with 32 bit versions of Office 2013.