Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2015, 06:25 AM
kcvinu kcvinu is offline How to make left most column and top most row visible when i scroll Windows 8 How to make left most column and top most row visible when i scroll Office 2007
Novice
How to make left most column and top most row visible when i scroll
 
Join Date: Jan 2015
Location: Vaikom(Keralam, India)
Posts: 20
kcvinu is on a distinguished road
Default How to make left most column and top most row visible when i scroll

Hi there,
My Excel file contains Two many columns(25) and rows(55). So i need to scroll vertical for seeing last Row and scroll horizontal for seeing last Column. When i scroll vertical, i want to see the top most row visible. And when i scroll horizontal, i need to see the left most column visible. How can i do it. Please help. Thanks in advance.
Reply With Quote
  #2  
Old 01-19-2015, 06:30 AM
kcvinu kcvinu is offline How to make left most column and top most row visible when i scroll Windows 8 How to make left most column and top most row visible when i scroll Office 2007
Novice
How to make left most column and top most row visible when i scroll
 
Join Date: Jan 2015
Location: Vaikom(Keralam, India)
Posts: 20
kcvinu is on a distinguished road
Default

Hi there,
I have got a solution. Freeze Panes from View menu. But it only works for either row or column at a time. I need my top row and left column visible every time. How is that possible ?
Reply With Quote
  #3  
Old 01-19-2015, 07:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to make left most column and top most row visible when i scroll Windows 7 64bit How to make left most column and top most row visible when i scroll Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,570
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Select B2 and apply "Freeze Panes" ( unfreeze the present sitaution before trying).
Then have a look at how Freeze Panes works in MS Excel Help ( F1)
__________________
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
  #4  
Old 01-19-2015, 07:32 AM
kcvinu kcvinu is offline How to make left most column and top most row visible when i scroll Windows 8 How to make left most column and top most row visible when i scroll Office 2007
Novice
How to make left most column and top most row visible when i scroll
 
Join Date: Jan 2015
Location: Vaikom(Keralam, India)
Posts: 20
kcvinu is on a distinguished road
Default

Hi Pecoflyer,
Thanks a lot. It works.
Reply With Quote
Reply

Tags
columns, rows, scroll

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to scroll to the rigjht or to teh left of the screen gvcastro Excel 0 11-01-2014 12:09 PM
Circle visible in top left corner when saving page with a 'flow-text box as PDF Clover_Creative Word 0 05-30-2014 05:03 AM
Columns. How to move the left column so it's to the right of the 'right' column ? Vit Word 9 11-21-2012 12:57 PM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
Scroll Bar appearing left side aligahk06 Word 2 10-20-2009 04:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:32 PM.


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