How to lock rows or columns in Excel 2003

-

In Excel 2003, if you have a worksheet that has a large number of rows and columns and you need to have a specific number of rows or columns or both rows and columns be visible always then you may do this by freezing the rows or columns or both rows and columns.

Freeze only rows
To freeze only rows, you must first determine the number of rows to freeze. For example, if you need to freeze the first two rows then click on the A3 section in the worksheet and then click on the Window menu and click on Freeze Panes.

Freeze only columns
To freeze only columns, you must first determine the number of columns to freeze. For example, if you need to freeze the first two columns then click on the C1 section in the worksheet and then click on the Window menu and click on Freeze Panes.

Freeze both rows and columns
To freeze both rows and columns, first determine the number of rows and columns to freeze. For example, if you need to freeze the first two rows and first two columns then click on the C3 section in the worksheet and then click on the Window menu and click on Freeze Panes.


Comments

Anonymous said…
Thank you for the easy-to-follow guide!
May 9, 2012 at 8:49 AM
Post a Comment

Popular posts from this blog

How to check if your PSP can have CFW installed

-
Image
Taken from: atmaxplorer.com I’ve been receiving tons of questions on how to check if their PSP can have custom firmware installed. Here’s a complete and concise guide to get you going. Make sure to read through the guide fully since it will answer all your psp motherboard related questions. First of, you need to understand that there are three types of PSPs: 1) 1000 Series (Also known as PSP Phat/Fat) 2) 2000 Series (Also known as PSP Slim or Lite & Slim) 3) 3000 Series (Also known as PSP Brite) So why install Custom Firmware on a PSP? People install Custom Firmware so they can run Homebrew, programs developed by people that don’t have a contract with Sony. A PSP with Custom Firmware could also back up your games from the UMD to your computer; it also allows you to play those backups from your Memory Stick (MS). You could also do some serious customizations to your theme. Basically, you free your PSP from the hands of Sony. Why can’t I install Custom Firmware on my ...
Read more

Windows cannot start this hardware device because its configuration information (in the registry) is incomplete or damaged (code 19)

-
Image
Windows cannot start this hardware device because its configuration information (in the registry) is incomplete or damaged (code 19)- CD ROM Device Manager Error One of my client brought in a Dell Latitude laptop that has a problem with its CD ROM. According to the owner he can't access his CD. The model of his CD Rom is Samsung CD ROM SN-124. Upon inspection, I found out that the device (CD ROM drive) is missing from his My Computer (as you can see on the image below) At first, I thought that the problem lies with the connection of the CDROM because I had it disassembled a week before due to display problem. The CD Rom is snap in type, so I easily took it out and back in without hassle. Upon logging in to windows, the problem still persist. Next, I checked the Device Manager (right-click My Computer, choose Properties, then Hardware and click on Device Manager). As you can see on the picture below, there is a problem with the CD ROM because there is a yellow exclamation mark befor...
Read more

How to: Repair Chinese Apad - Android Tablet

-
Image
Problem: Chinese Android tablet hangs on boot. Android logo appears and then freezes. It shuts down after few seconds. Reason: The Android installation is corrupted. Solution: Reflash / install a new android firmware / OS. Applies to: Flytouch Android Tablet, Epad, Apad, Iped The one I repaired has the following specifications: VIA chipset 8505 / 300 mhz 256 mb memory 2 GB storage with camera vibrates at startup (unique for flytouch model) Pics: What you need: At least 128 mb microSD card Step-by-step Guide: 1. Download this file if you have the 256 mb version: http://www.filefront.com/17277089/EPAD256.1.988.3k.7z For 128mb, download this: http://www.filefront.com/17277251/EPAD128.1.988.3k.7z 2. Extract the script folder to your memory card. If your memory card is drive e, it should look like these: e:\script\ 3. While the tablet is off, insert the card to the card reader /slot at the bottom of your tablet. 4. Turn it on and wai...
Read more