Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-05-2018, 06:25 AM
ArviLaanemets ArviLaanemets is offline Can I freeze top pane and first column simultaneously? Windows 8 Can I freeze top pane and first column simultaneously? Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

You select a cell, and then from menu Freeze Panes!

All rows what are above selected cell are freezed;
And all columns what are left at selected cell are freezed!

Obviously you selected A5 instead of B5!

And be sure you have scrolled the page to start (at top and at left), otherwise can happen, that you don't see some freezed columns/rows anymore unless you unfreeze page!

Another issue newbies sometime have is, that they scroll the sheet to start, but forget to select the cell, leaving the cursor active somewhere near AA100. And then can't understand, how they can't to scroll the page at all :-)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I freeze top pane and first column simultaneously? Freeze top row and column in the same sheet. village Excel 3 11-26-2016 08:40 AM
Can I freeze top pane and first column simultaneously? unfreeze command not in view freeze pane drop down menu almart Excel 1 01-24-2015 11:12 PM
Can I freeze top pane and first column simultaneously? Freeze Pane isn't working properly ep2002 Excel 1 07-27-2014 06:53 PM
Freeze more than just the top row, or first column Gary Drumm Excel 4 07-23-2013 11:34 AM
Can I freeze top pane and first column simultaneously? Possible to freeze both a column and a row? bryanarn Excel 2 03-11-2012 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:12 AM.


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