Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Label positions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Beemer - 18 Sep 2006 11:41 GMT
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 Phillips - 18 Sep 2006 12:29 GMT
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

Signature

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
[quoted text clipped - 8 lines]
>
> Beemer
Beemer - 18 Sep 2006 12:52 GMT
| Does this article address what you are saying?
|
[quoted text clipped - 14 lines]
| >
| > Beemer

Bob,  Your link does not work says  "The system canoot find the file
specified"

Beemer
Ian - 18 Sep 2006 13:13 GMT
Try this one:
http://support.microsoft.com/kb/838910/en-us

If this doesn't work directly, go to http://support.microsoft.com and use
the Search Support (KB) box to search for 838910.
Signature

Ian
--

>
> | Does this article address what you are saying?
[quoted text clipped - 25 lines]
>
> Beemer
Andy Pope - 18 Sep 2006 13:14 GMT
http://support.microsoft.com/?kbid=838910

> | Does this article address what you are saying?
> |
[quoted text clipped - 20 lines]
>
> Beemer

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Beemer - 18 Sep 2006 13:30 GMT
| http://support.microsoft.com/?kbid=838910
|
[quoted text clipped - 22 lines]
| >
| > Beemer

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
Beemer - 18 Sep 2006 13:40 GMT
|| http://support.microsoft.com/?kbid=838910
||
[quoted text clipped - 33 lines]
|
| 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.