Leader Dots Between Cells

[Ty]

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

 

[Gord Dibben]

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

 

[RagDyer]

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

 

[RagDyer]

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

 

[RagDyer]

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.

 

[RagDyer]

Darn ... forgot the parens:

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

 

[Five]

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.

 

[Ty]

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?

 

[RagDyeR]

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

Regards,

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

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?

 

[Ty]

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

 

[RagDyer]

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?

 

[Five]

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.