Home |
Search |
Today's Posts |
#1
|
|||
|
|||
leave left column in place as you scroll to the right
I've noticed on spreadsheets that have been sent to me that there is a way to
be able to leave the left-hand column (column A usually) showing even as you scroll right through a very wide sheet. The obvious benefit is that it leaves the ROW definition showing at all times. Can someone tell me how this is done? Thanks |
#2
|
|||
|
|||
Select cell B1 and choose Freeze Panes from the Window menu.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "AccessNewbie" wrote in message ... I've noticed on spreadsheets that have been sent to me that there is a way to be able to leave the left-hand column (column A usually) showing even as you scroll right through a very wide sheet. The obvious benefit is that it leaves the ROW definition showing at all times. Can someone tell me how this is done? Thanks |
#3
|
|||
|
|||
Hi
Place your cursor in Cell B2 WindowsFreeze Panes This will keep column A visible as you scroll across, and row 1 visible as you scroll down. Regards Roger Govier AccessNewbie wrote: I've noticed on spreadsheets that have been sent to me that there is a way to be able to leave the left-hand column (column A usually) showing even as you scroll right through a very wide sheet. The obvious benefit is that it leaves the ROW definition showing at all times. Can someone tell me how this is done? Thanks |
#4
|
|||
|
|||
To leave column 'A' in view:
Select cell 'B1' Window Freeze Panes. HTH George Gee AccessNewbie wrote: I've noticed on spreadsheets that have been sent to me that there is a way to be able to leave the left-hand column (column A usually) showing even as you scroll right through a very wide sheet. The obvious benefit is that it leaves the ROW definition showing at all times. Can someone tell me how this is done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right column doesn't change when sorting left column. | Excel Discussion (Misc queries) | |||
Keep the left column revealed | Excel Worksheet Functions | |||
On an Excel Worksheet I want to view column headings as I scroll . | Excel Discussion (Misc queries) | |||
Help: Scroll wheel toggles between up and down, and left and right - is driving me crazy | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel |