Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - fill white space in cells
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. |
#2
|
|||
|
|||
Excel - fill white space in cells
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] -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Juliette UK/NZ" <Juliette wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create custom fill colors (for cells) in Excel 2002? | Excel Discussion (Misc queries) | |||
Extra White Space Between Cells | Excel Discussion (Misc queries) | |||
Extra White Space Between Cells | Excel Discussion (Misc queries) | |||
Extra White Space Between Cells | Excel Discussion (Misc queries) | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |