Excel - Insert Dotted Lines ...

Story of pretending:
Reserve a column out of sight for text entry, use the cell immediately to the right for the table
Out of sight again, fill a cell with an impressive number of dotted lines, (preceded by the sign ' if using minus.)
Create a simple macro:
"concatenate the cell at C-1 with the fixed cell containing the dotted lines"
In the table cell, the text appears followed by a constant number of dotted lines, limited anyway to the edge of the next cell if it, of course, contains information or a formula. (there, thanks Guitou)
So to achieve the result in A2 with a pre-installed row of dotted lines in X1 with this macro, which will concatenate A2 -1C and $X$1:
Enter the text in A1, move the cursor to A2, run the macro from the keyboard.
But it’s just for fun!
Best regards

Hello,
A solution is to enter the text, for example, in cell A8 and the dots (in large numbers) in cell A9.
Go to the cell where you want the text and enter the following formula =+A8&A9
There are also "Macros" solutions, but they don't seem essential...

See you!

Hello Guitou13,

Thank you for this tip, but I think that in the end, the grid will be simpler, because the dots will shift the text differently each time depending on the number of words, and the dotted lines will not all be perfectly aligned.

If someone can suggest how to do it with a macro, I would appreciate it.

Thank you in advance.

Hello,
No, the text doesn't change since it is to the left, but it is also possible with a Macro.

ActiveCell.Select
[Iv65000] = ActiveCell & "................................................................"
ActiveCell = [Iv65000]

If there aren't enough dots, add more in the Macro; they are in any case limited by the closest filled cell.

Hello, yesabsurfer, or rather re...
No, I don't have the solution there; even with a macro, I think it’s difficult to retrieve text from a cell, modify it, and put it back in the same one? Others may succeed, it's a good question!
However, when you say that the grid seems better to you, I think so too, especially if you integrate dashed borders to limit the cells as Excel allows.
Thus, I find that a table with horizontal dashes and no vertical separation generally looks good!
For screen viewing, I remind you that, like with the zeros, you can go to the tools/options menu and remove the grid display.
But it's just a compromise, and I’m keeping an eye on the topic to see if someone proposes a solution without adding an input column to the table.
Best regards.

Good evening,

At least use a fixed-width font like Courier New and ensure the strings are always the same length...
But it's so much easier to use cells, why complicate things ;-)
eric

Hello everyone!

It's not ideal because it only works on a Number cell
you can go to format, cell, number, custom, and in style
you put

"..........."00000

it helps with readability

between the ", you can put any label

--
xkristi
Life plus...

Thank you Eriiic

it doesn't happen to me often!!! (lol)
--
xkristi
Life even more...

Thank you again
"the first impression is always the best"
it's the one that is not distorted by society (not my words, Rousseau)

but we’re not at the café so I'll stop!!!!
--
xkristi
Life plus...