Excel - Insert Dotted Lines ...
ouiabsurfer
Posted messages
32
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I would like to know if it is possible to insert dotted lines in a cell that already contains text right before a cell that contains numbers to help improve the readability of the data?
This function is possible in Word with the decimal tabulation function and trailing dots.
It gives a result similar to this
Textetextetextetextetextetextetextetextetexte.....................................................................123.45
Thank you in advance.
I would like to know if it is possible to insert dotted lines in a cell that already contains text right before a cell that contains numbers to help improve the readability of the data?
This function is possible in Word with the decimal tabulation function and trailing dots.
It gives a result similar to this
Textetextetextetextetextetextetextetextetexte.....................................................................123.45
Thank you in advance.
Configuration: Windows XP Firefox 2.0.0.7
9 réponses
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
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!
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.
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.
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.
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
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
