Freeze column and row

V

vapor77

Can someone please tell me how to freeze a column and a row at the sam
time?

Thank
 
P

Pete

If you want Row 1 and column A to be visible on screen all the time as
you scroll around, position the cursor in cell B2 and click Window |
Freeze Panes.

Hope this helps.

Pete
 
V

vapor77

Now that was a lot easier than I thought it would be. Thank you for th
help Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Unable to freeze panes 15
How can I freeze a pane... 8
Rows to repeat at top 3
Copy addition formula of non-consecutive horizontal cells 2
Freeze the Panes Row as well Column 2
Freeze at the top & split the side in Excel97? 2
Need Help with a VBA subroutine 0

Top