Freeze and Unfreeze Rows and Columns: MS Excel
When your spreadsheet has labels in the top row or left column to describe the data in the cells, you can freeze those rows and columns so that they always appear on screen even when you scroll down or to the right.
Open MS Excel and in the first row type your headings (i.e. Category, Title, Author, Quantity, Costs, etc.) In the left-most column, type other data labels (i.e. Fiction, Non-Fiction, Sci-Fi., etc.)
When you use the Window | Freeze Panes command, everything above the current row or to the left of the current column is frozen in place. This way, it's always visible to you, even after your spreadsheet has grown so large that ordinarily you wouldn't see those headings as you scroll down the page.
When you have a large worksheet that contains more rows or columns than you can see on the screen at one time, you find yourself scrolling left and right or up and down to see the cells, which can become a pain.
To freeze cells, follow these steps carefully:
- Set up the screen the way you want it to appear when it is frozen. If necessary, scroll up or down, left or right, so that the correct rows and columns appear on the left and top of the screen.
- Place the active cell in the specific location so that everything you want frozen is above it or to its left.
- Choose Windows | Freeze Panes.
Excel places a thin, dark line above and to the left of the active cell. As you move around the worksheet, the columns and rows slide "behind" the frozen ones, so they always remain in place.
Visit Carol's web site to learn more tips like this one!
Most popular articles
- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- Scammed by Smart PC Experts? Here's What to Do
- Scammed by Right PC Experts? Here's What to Do
- Scammed by PC / Web Network Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?

I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.
Most popular articles
- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- 5 Best Anti Ransomware Software Free
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- Scammed by Smart PC Experts? Here's What to Do
- Scammed by Right PC Experts? Here's What to Do
- Scammed by PC / Web Network Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Explained: VPN vs Proxy; What's the Difference?
- Explained: Difference Between VPN Server and VPN (Service)
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
- How to: Use a Firewall to Block Full Screen Ads on Android
- Explained: Absolute Best way to Limit Data on Android
- Explained: Difference Between Dark Web, Deep Net, Darknet and More
- Explained: If I Reset Windows 10 will it Remove Malware?