Label positions

B

Beemer

On an Excel 2003 spreadsheet which is much wider than any screen it is
inconvenient if cell labels do not stick in the position they are left. I
am finding that when I reopen the spreadsheet the labels may have moved
horizontally to the left hand side of the spreadsheet (not the LH side of
the screen but go to the screen which starts column A.

It is tedious to manually move these back to near each relative cell
especially when seemingly at random they return to the LH screen.

Can this be fixed?

Beemer
 
B

Beemer

| Does this article address what you are saying?
|
| http://support.microsoft.com/d­efault.aspx?kbid=838910
| Controls move to the left of the worksheet in Microsoft Excel 2002
|
| --
| HTH
|
| Bob Phillips
|
| (replace somewhere in email address with gmail if mailing direct)
|
| | > On an Excel 2003 spreadsheet which is much wider than any screen it is
| > inconvenient if cell labels do not stick in the position they are left.
| I
| > am finding that when I reopen the spreadsheet the labels may have moved
| > horizontally to the left hand side of the spreadsheet (not the LH side
of
| > the screen but go to the screen which starts column A.
| >
| > It is tedious to manually move these back to near each relative cell
| > especially when seemingly at random they return to the LH screen.
| >
| > Can this be fixed?
| >
| > Beemer
| >
| >
|
|
Bob, Your link does not work says "The system canoot find the file
specified"

Beemer
 
A

Andy Pope

http://support.microsoft.com/?kbid=838910
| Does this article address what you are saying?
|
| http://support.microsoft.com/d­efault.aspx?kbid=838910
| Controls move to the left of the worksheet in Microsoft Excel 2002
|
| --
| HTH
|
| Bob Phillips
|
| (replace somewhere in email address with gmail if mailing direct)
|
| | > On an Excel 2003 spreadsheet which is much wider than any screen it is
| > inconvenient if cell labels do not stick in the position they are left.
| I
| > am finding that when I reopen the spreadsheet the labels may have moved
| > horizontally to the left hand side of the spreadsheet (not the LH side
of
| > the screen but go to the screen which starts column A.
| >
| > It is tedious to manually move these back to near each relative cell
| > especially when seemingly at random they return to the LH screen.
| >
| > Can this be fixed?
| >
| > Beemer
| >
| >
|
|
Bob, Your link does not work says "The system canoot find the file
specified"

Beemer
 
B

Beemer

| http://support.microsoft.com/?kbid=838910
|
| Beemer wrote:
| > | > | Does this article address what you are saying?
| > |
| > | http://support.microsoft.com/d­efault.aspx?kbid=838910
| > | Controls move to the left of the worksheet in Microsoft Excel 2002
| > |
| > | --
| > | HTH
| > |
| > | Bob Phillips
| > |
| > | (replace somewhere in email address with gmail if mailing direct)
| > |
| > | | > | > On an Excel 2003 spreadsheet which is much wider than any screen it
is
| > | > inconvenient if cell labels do not stick in the position they are
left.
| > | I
| > | > am finding that when I reopen the spreadsheet the labels may have
moved
| > | > horizontally to the left hand side of the spreadsheet (not the LH
side
| > of
| > | > the screen but go to the screen which starts column A.
| > | >
| > | > It is tedious to manually move these back to near each relative cell
| > | > especially when seemingly at random they return to the LH screen.
| > | >
| > | > Can this be fixed?
| > | >
| > | > Beemer
| > | >
| > | >
| > |
| > |
| > Bob, Your link does not work says "The system canoot find the file
| > specified"
| >
| > Beemer
| >
| >
|
| --
|
| Andy Pope, Microsoft MVP - Excel
| http://www.andypope.info

Andy, thanks to you (and Ian) for the new link but Bob picked up my
question incorrectly. It is COMMENTS which are moving off the screen not
controls (which I don't use) . I do not see any property for Comments
which would make them sticky near its relative cell.

Beemer
 
B

Beemer

|
| || http://support.microsoft.com/?kbid=838910
||
|| Beemer wrote:
|| > || > | Does this article address what you are saying?
|| > |
|| > | http://support.microsoft.com/d­efault.aspx?kbid=838910
|| > | Controls move to the left of the worksheet in Microsoft Excel 2002
|| > |
|| > | --
|| > | HTH
|| > |
|| > | Bob Phillips
|| > |
|| > | (replace somewhere in email address with gmail if mailing direct)
|| > |
|| > | || > | > On an Excel 2003 spreadsheet which is much wider than any screen
it
| is
|| > | > inconvenient if cell labels do not stick in the position they are
| left.
|| > | I
|| > | > am finding that when I reopen the spreadsheet the labels may have
| moved
|| > | > horizontally to the left hand side of the spreadsheet (not the LH
| side
|| > of
|| > | > the screen but go to the screen which starts column A.
|| > | >
|| > | > It is tedious to manually move these back to near each relative
cell
|| > | > especially when seemingly at random they return to the LH screen.
|| > | >
|| > | > Can this be fixed?
|| > | >
|| > | > Beemer
|| > | >
|| > | >
|| > |
|| > |
|| > Bob, Your link does not work says "The system canoot find the file
|| > specified"
|| >
|| > Beemer
|| >
|| >
||
|| --
||
|| Andy Pope, Microsoft MVP - Excel
|| http://www.andypope.info
|
| Andy, thanks to you (and Ian) for the new link but Bob picked up my
| question incorrectly. It is COMMENTS which are moving off the screen not
| controls (which I don't use) . I do not see any property for Comments
| which would make them sticky near its relative cell.
|
| Beemer
|
|
Found another link http://support.microsoft.com/kb/211769/en-us

which led me to right right click on the edge of the comment and there I see
the same instruction which all your Controls link had, i.e. move with
cells. However it seems that I will have do this procedure every time I add
a new comment which is a pain.

Thanks,

Beemer
 

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