If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup Table Dilemma | Karen | Worksheet Functions | 2 | June 10th, 2005 08:22 PM |
Truncated Text Box on Report | neenmarie | Setting Up & Running Reports | 15 | April 20th, 2005 07:10 PM |
Return Count for LAST NonBlank Cell in each Row | Sam via OfficeKB.com | Worksheet Functions | 12 | April 17th, 2005 10:36 PM |
up to 7 functions? | ALex | Worksheet Functions | 10 | April 12th, 2005 06:42 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |