Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2016, 11:33 AM
gogreen gogreen is offline Freeze first column not working Windows 10 Freeze first column not working Office 2010 32bit
Advanced Beginner
Freeze first column not working
 
Join Date: Aug 2015
Posts: 67
gogreen is on a distinguished road
Default Freeze first column not working

In my Excel 2010 document, I'm highlighting the first column, selecting View, and then freeze first column, but it's not working--the first column doesn't appear on the second page in print preview. What am I missing? Thanks.
Reply With Quote
  #2  
Old 12-23-2016, 12:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Freeze first column not working Windows 7 64bit Freeze first column not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

I don't know if the way you tried works, but selecting B1 and clicking " Freeze panes" should freeze all raws above the selection ( in this case none) and all columns to the left of the selection ( col A)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-23-2016, 07:55 AM
gogreen gogreen is offline Freeze first column not working Windows 10 Freeze first column not working Office 2010 32bit
Advanced Beginner
Freeze first column not working
 
Join Date: Aug 2015
Posts: 67
gogreen is on a distinguished road
Default

Thanks, Pecoflyer. I tried this, but it's not working, not even in a new document I created. It worked in previous documents for me, so as a workaround, I copied a document in which freezing column A works, erased all the data, and added what I wanted. I can't imagine why freeze columns isn't working for me. Any suggestions on how to get it to work in a new document? Thanks again.
Reply With Quote
  #4  
Old 12-23-2016, 08:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Freeze first column not working Windows 7 64bit Freeze first column not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Are you using XL 2010 starter? Freeze panes is not available there.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 12-23-2016, 09:48 AM
gogreen gogreen is offline Freeze first column not working Windows 10 Freeze first column not working Office 2010 32bit
Advanced Beginner
Freeze first column not working
 
Join Date: Aug 2015
Posts: 67
gogreen is on a distinguished road
Default

Quote:
Are you using XL 2010 starter? Freeze panes is not available there.
I don't think so because it's worked for me before--it's just not working lately. How would I identify the XL 2010 starter installation on my computer?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to filter column by last working day in excel AC PORTA VIA Excel Programming 17 02-20-2017 06:07 PM
Freeze first column not working Freeze top row and column in the same sheet. village Excel 3 11-26-2016 08:40 AM
Freeze first column not working 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
Freeze first column not working 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 05:40 PM.


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