Leader Dots Between Cells
 

I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Leader Dots Between Cells
 

I get no gap when using the @*. with text and a gap using *.# with numerics
only when the first digit is a 1.

I don't think you can prevent that.


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 23:36:54 -0600, Ty wrote:

I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Leader Dots Between Cells
 

Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Leader Dots Between Cells
 

If you would be able to use 2 helper columns, in an out-of-the-way location,
say Columns Y and Z, enter your text and numbers there.

Then in say Columns A and B,
Format A to Left Justify,
And B to Right Justify.

Then in Column A:

=Y1&REPT(".",255)

And in Column B:

=REPT(".",255)&Z1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I
would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Leader Dots Between Cells
 

I still can see a "seam" between the columns in some of the rows.

You might try putting your 2 columns of text into a *single* presentation
column to eliminate any seams.

Set A1 to the desired (estimated) width to accommodate both entries.
Now, just enter dots to fill the entire cell.
In B1, count the dots with this formula:
=Len(A1)

Say you get a count of 75.

Enter this in A1:

=Y1&REPT(".",75-LEN(Y1)+LEN(Z1))&Z1

Copy down a few rows and see if all the data is visible.

If not, just play with the "75" to get the display you need.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
If you would be able to use 2 helper columns, in an out-of-the-way
location, say Columns Y and Z, enter your text and numbers there.

Then in say Columns A and B,
Format A to Left Justify,
And B to Right Justify.

Then in Column A:

=Y1&REPT(".",255)

And in Column B:

=REPT(".",255)&Z1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I
would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Leader Dots Between Cells
 

Darn ... forgot the parens:

=Y1&REPT(".",67-(LEN(Y1)+LEN(Z1)))&Z1

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RagDyer" wrote in message
...
I still can see a "seam" between the columns in some of the rows.

You might try putting your 2 columns of text into a *single* presentation
column to eliminate any seams.

Set A1 to the desired (estimated) width to accommodate both entries.
Now, just enter dots to fill the entire cell.
In B1, count the dots with this formula:
=Len(A1)

Say you get a count of 75.

Enter this in A1:

=Y1&REPT(".",75-LEN(Y1)+LEN(Z1))&Z1

Copy down a few rows and see if all the data is visible.

If not, just play with the "75" to get the display you need.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
If you would be able to use 2 helper columns, in an out-of-the-way
location, say Columns Y and Z, enter your text and numbers there.

Then in say Columns A and B,
Format A to Left Justify,
And B to Right Justify.

Then in Column A:

=Y1&REPT(".",255)

And in Column B:

=REPT(".",255)&Z1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"RagDyer" wrote in message
...
Just enter text in the left column and right justify it.
Format your dots *only* in the right column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"Ty" wrote in message
...
I am trying to make leader dots between cells as seamless as possible
and
right now there is a gap showing up.

The custom format I used was @*. and *.# and they worked fine, now I
would
just like to eliminate the gap between the two and I'll be set.

Here is a screenshot of what I am trying to say:
http://i10.tinypic.com/7xnpbeu.png

Leader Dots Between Cells
 

Oh man, you are awesome, this is exactly what I was hoping for, I couldn't
get the "75" to be consistent, every cell had to be a different number and
it finally dawned on me to use a monospace font, such as courier. Once I
did that, it was smooth sailing.

Once again RD, I can't thank you enough. This is awesome.

"RagDyer" wrote:

Darn ... forgot the parens:

=Y1&REPT(".",67-(LEN(Y1)+LEN(Z1)))&Z1

Leader Dots Between Cells
 

Once again, thanks RD.

I got this bad boy done, one more thing that would make things just a tid
more fluid that I can't figure out:

how do you link an absolute reference (ex: $A$1) from the header/footer
areas?

Leader Dots Between Cells
 

Don't quite follow exactly what you're asking.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Ty" wrote in message
...
Once again, thanks RD.

I got this bad boy done, one more thing that would make things just a tid
more fluid that I can't figure out:

how do you link an absolute reference (ex: $A$1) from the header/footer
areas?

Leader Dots Between Cells
 

Basically, I have one worksheet that is just a list of all the items and
the aisles they go on. That way I can add to it and what not and then sort
it alphabetically and be done with it.

Then I have a second worksheet that is formatted for print that just points
to all of the items in the first worksheet. Nothing on that worksheet is
hardcoded, it all just points to the first worksheet.

From the footer area of the worksheet formatted for print I was trying to
point to a cell in the first worksheet that contains some misc information,

Right now, I have it hardcoded in and it works fine, I was just hoping that
I could keep the editing to one worksheet and the others for printing.

I photoshopped what I was trying to say:
http://i4.tinypic.com/6uo9im8.jpg

Leader Dots Between Cells
 

AFAIK, can only be accomplished with code.

There's a little trick, if you would need to put it at the *top* of your
sheets, in a "pseudo" header.

<File <Page Setup <Sheet tab,
Under "Print Titles", there's an option to repeat the printing of a row/rows
at the top of every page.
You could link your cell(s) into this row(s), and have it repeat on every
page.
However, there's *no* option for rows to repeat at the *bottom* (footer).

BTW, what version of XL are you using?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ty" wrote in message
...
Basically, I have one worksheet that is just a list of all the items and
the aisles they go on. That way I can add to it and what not and then sort
it alphabetically and be done with it.

Then I have a second worksheet that is formatted for print that just
points
to all of the items in the first worksheet. Nothing on that worksheet is
hardcoded, it all just points to the first worksheet.

From the footer area of the worksheet formatted for print I was trying to
point to a cell in the first worksheet that contains some misc
information,

Right now, I have it hardcoded in and it works fine, I was just hoping
that
I could keep the editing to one worksheet and the others for printing.

I photoshopped what I was trying to say:
http://i4.tinypic.com/6uo9im8.jpg

Leader Dots Between Cells
 

Office 2004 for Mac. Still getting accustomed to the mac stuff. I took one
of the screens in windows, bc I don't have photoshop on the mac yet. It
sure didn't look the same on the windows one. I ended up just outputting to
a pdf to ensure that it looked the way I wanted on all the computers,
regardless of office version or os. Many of the computers just have excel
viewer, so the pdf file works well.

"RagDyer" wrote in:

BTW, what version of XL are you using?