Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Juliette UK/NZ
 
Posts: n/a
Default 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   Report Post  
Max
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create custom fill colors (for cells) in Excel 2002? rob653 Excel Discussion (Misc queries) 2 June 12th 05 03:25 PM
Extra White Space Between Cells Leesa Excel Discussion (Misc queries) 1 May 25th 05 07:00 PM
Extra White Space Between Cells Leesa Excel Discussion (Misc queries) 0 May 24th 05 08:46 PM
Extra White Space Between Cells Leesa Excel Discussion (Misc queries) 0 May 24th 05 08:30 PM
My excel 2003 wont let me fill cells with color or color the tabs. trizog New Users to Excel 2 February 22nd 05 07:43 PM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"