Microsoft Office Forums How do I freezes The rows

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2019, 09:07 AM
melvin1942 melvin1942 is offline How do I freezes The rows Windows 10 How do I freezes The rows Office 2007
Advanced Beginner
How do I freezes The rows
 
Join Date: Apr 2016
Posts: 36
melvin1942 is on a distinguished road
Default How do I freezes The rows

I want to freezes the the first 3 rows on my Excel spreadsheet. I highlight the rows I want to freezes. I go to View and then freeze panes and then freeze panes, but it keeps freezing only row 1. What I'm I doing wrong.

Melvin1942
Reply With Quote
  #2  
Old 05-23-2019, 11:18 AM
ArviLaanemets ArviLaanemets is offline How do I freezes The rows Windows 8 How do I freezes The rows Office 2016
Expert
 
Join Date: May 2017
Posts: 446
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

To freeze top 3 rows only:
Scroll the sheet up, so top rows are visible;
Celect cell A4;
Freeze Panes.

To freeze e.g. Top 3 rows and left 2 columns:
Scroll the sheet up and left, so top rows and left columns are visible;
Select cell C4;
Freeze Panes.
Reply With Quote
  #3  
Old 05-23-2019, 05:15 PM
melvin1942 melvin1942 is offline How do I freezes The rows Windows 10 How do I freezes The rows Office 2007
Advanced Beginner
How do I freezes The rows
 
Join Date: Apr 2016
Posts: 36
melvin1942 is on a distinguished road
Default freezes rows

Thank you for your help. It worked . I did not go down far enough.

Melvin1942
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I freezes The rows Word 2013 freezes Roysyboy Word 2 04-30-2016 04:19 AM
How do I freezes The rows Outlook freezes jparnold Outlook 5 07-23-2015 03:16 PM
PgUp freezes weamish Word 6 08-15-2014 06:43 AM
How do I freezes The rows Scanpst freezes while repair wainwright Outlook 0 01-10-2012 08:14 AM
How do I freezes The rows Outlook freezes retep Outlook 0 03-19-2011 11:09 AM


All times are GMT -7. The time now is 06:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft