Excel - fill white space in cells

J

Juliette UK/NZ

I am creating a spreadsheet that contains a column of text followed columns
of figures.

I have a lot to fit into one page, the font is small, and the description in
the text field varies in length. How can I fill the following white space
with dots to make it easier to determine which figure follows the text in the
preceding column?
Shading or colour is not appropriate to aid reading along the row as the
spreadsheet will be photocopied.
It is not appropriate to create the file in Word, because the figures are
updated from other cells on the spreadsheet.
 
M

Max

Select the text column
& format it as Custom, Type: @*.

[Don't miss out the repeating character in the above,
i.e. a period "." in this instance]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top