Printing Excel Spreadsheets.

geeman

Member
Feb 21, 2001
106
0
0
Can I get rid of the spacings between cells and print out spreadsheets so they look like a word document?
 

bub

Senior member
Oct 9, 1999
239
0
71
If you mean print without gridlines, goto File>PageSetup>Sheet and remove checkmark next to Gridlines.
 

geeman

Member
Feb 21, 2001
106
0
0
I wasn't talking about the gridlines, I was wondering if you can print
several cells together and have the spacings between to cells disapear
so it looks like a continuous line. For instance say in one cell
you have the word "the" and the next cell has the word "space".
and because of the spacing limitations of cells above and below them
it prints as the ------------- space. Can you have Excel remove spaces when
it prints cells without changing the cell width, just like a word processor would do.
 

geeman

Member
Feb 21, 2001
106
0
0
I figured out mostly how to merge cell with the concatenate function,
but I was wondering if there is anyway for this function to understand the formating of cells with dates and times or a fixed number of digits past the decimal.