padding around column headers

  • Thread starter Thread starter Kevin
  • Start date Start date
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?
 
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
 
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
 
Back
Top