Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > Computer Support > Excel - Comments are out of alinement

Reply
Thread Tools

Excel - Comments are out of alinement

 
 
Richard
Guest
Posts: n/a
 
      12-21-2007
When I choose to show my comments they are all a
thousand rows down. I have about a hundred of them. Do I have to straighten
them all one at a time are is there someway I can straighten all of them to
be with the cell they belong too. I am trying to save myself about 2 or 3
hours of work.

Richard

 
Reply With Quote
 
 
 
 
why?
Guest
Posts: n/a
 
      12-21-2007

On Fri, 21 Dec 2007 15:26:23 -0700, Richard wrote:

>When I choose to show my comments they are all a
>thousand rows down. I have about a hundred of them. Do I have to straighten
>them all one at a time are is there someway I can straighten all of them to
>be with the cell they belong too. I am trying to save myself about 2 or 3
>hours of work.


This is where you mean that when you click on a cell wih a comment, the
comment box can be close/far above/below the cell.

Seen that, well well Excel 2003 seems to be different from earlier
versions, the same size box, sam eshort pointer and same angle.

There is a lot you can do, alter lines, text, size , box size, move.

That looks like a small macro to set the values you want to change.

Try the MS Excel ngs, via your

Usenet service,
MS web communities,
MS news server,
and Google groups.
http://groups.google.com/groups/dir?...07952&expand=1

Look in 24HSHD
http://groups.google.com/group/24hou...elpdesk/topics
for how to access via the MS methods.

In 2003 saved as HTML all the formatting is there

<v:shape id="_x0000_s1027" type="#_x0000_t202"
style='position:absolute;

margin-left:107.25pt;margin-top:-7.5pt;width:108pt;height:68.25pt;z-index:3;
visibility:visible' fillcolor="infoBackground [80]"
o:insetmode="auto">
<v:fill color2="infoBackground [80]"/>
<v:shadow on="t" color="black" obscured="t"/>
<vath o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>6</x:Row>
<x:Column>1</x:Column>
<x:Author>mstn</x:Author>
<x:Visible/>
</x:ClientData>
</v:shape></xml><![endif]--><![if !vml]><span
style='mso-ignore:vglayout'><![endif]>

If you want to script that and load / resave as XLS to see what happens.

>Richard


Me
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Comments get out of alinement Richard Computer Support 1 12-23-2007 03:06 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
A program to replace all JS comments with JSP comments in jsp files tungchau81@yahoo.com Javascript 4 06-03-2006 02:00 PM
A program to replace all JS comments with JSP comments in jsp files tungchau81@yahoo.com Java 0 06-02-2006 06:35 AM
Comments format: comments extending over multi-line Monk C Programming 10 04-20-2005 05:09 PM



Advertisments