#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 ? |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
Hi Pecoflyer,
Thanks a lot. It works. |
Tags |
columns, rows, scroll |
|
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 |