Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to open worksheet with preset columns displayed?
I have an Excel 2003 spreadsheet with 8 columns, A-H.
I have "frozen" the first two columns, A & B, so that I may scroll back and forth between columns C-H, while columns A& B remain on the screen. For some reason, each time I open the worksheet, columns C-H are all shifted over one column to the left, so that column C is not visible. What I see are these three columns like this: A | B | D But what I want to see are the first three columns like this: A | B | C So each time I open the worksheet I have to manually scroll columns C- H to reveal column C. Even if I save the worksheet with column C displayed, and then exit, the next time I open the worksheet, column C is again shifted over to the left and not visible. How may I tell Excel to open the worksheet each time with Column C visible? Will in Seattle a.k.a. "Clueless" |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to open worksheet with preset columns displayed?
Hi,
Try this. Alt + f11 tp open VB editor Double click 'This workbook' Paste this in on the right. Private Sub Workbook_Open() Sheets("Sheet1").Range("C1").Select End Sub Change the sheet name to your sheet name Mike "Clueless in Seattle" wrote: I have an Excel 2003 spreadsheet with 8 columns, A-H. I have "frozen" the first two columns, A & B, so that I may scroll back and forth between columns C-H, while columns A& B remain on the screen. For some reason, each time I open the worksheet, columns C-H are all shifted over one column to the left, so that column C is not visible. What I see are these three columns like this: A | B | D But what I want to see are the first three columns like this: A | B | C So each time I open the worksheet I have to manually scroll columns C- H to reveal column C. Even if I save the worksheet with column C displayed, and then exit, the next time I open the worksheet, column C is again shifted over to the left and not visible. How may I tell Excel to open the worksheet each time with Column C visible? Will in Seattle a.k.a. "Clueless" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how files are displayed in the open file window | Excel Discussion (Misc queries) | |||
How do I set which columns are displayed in File:Open? | Excel Discussion (Misc queries) | |||
Is there anyway to add more than the preset 265 columns in Excel? | Excel Discussion (Misc queries) | |||
Can I create a new worksheet in excel with preset formating? | Excel Discussion (Misc queries) | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel |