padding around column headers

K

Kevin

When I print out preliminary versions of my spreadsheets, I see
generous horizontal space around my column headers. However, when I
attempt to tighten the measure, I can't: words break over their last
letters, etc.

It's as though there is some invisible padding around the type in the
column headers. Anyone have an idea about what this is about, and how
to work around it?
 
C

CLR

Could be you have some extra "spaces" before and /or after the header
text..............try re-typing a header, without any spaces and see if it
will size down........this could easily be the case with imported
data/headers.

Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

If you've copied those headers from a web page, you could have some of those
HTLM non-breaking spaces, too.

=len(trim(substitute(a1,char(160)," ")))

might show you the problem.

If it turns out that you have spaces (or those non-breaking spaces), David
McRitchie has some code that will help clean this junk up:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top