Excel question when working with large spreadsheets

M

MIke

When working with a large horizontal spreadsheet, is it
possible to have column A's header still visible when all
the way to the right of the spreadsheet (for example, when
scrolling to the right of the spreadsheet, still being
able to see column A's heading)?

Any assistance is appreciated!

Thanks
Mike
 
T

Trevor Shuttleworth

Mike

Look at Freeze Panes under Window. Suggest you select cell B2 and then
Window | Freeze Panes. That "locks" the top row and the leftmost column.

Regards

Trevor
 

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

Top