in an Excel table how do I set cell internal margins???

  • Thread starter Thread starter Brit in US
  • Start date Start date
B

Brit in US

in an Excel table how do I set cell internal margins? I can do this in a
table in Word, but can't find it in Excel, I am using Office Professional
2007...
 
Excel is not a word-processing package.
The only place 'margins' have meaning for Excel is in Page Setup
best wishes
 
OK. When I print a table from an Excel spreadsheet, how can I put a margin
around the data in a cell to make it more readable?
 
Insert a column to the left and another to the right
Make these columns narrow
best wishes
 
You can use cell format dialogbox, GO to FORMAT >> CELLS & choose
ALIGNMENT tab. You can try using indent & row height to give more
space between characters and table borders. I think this should solve
your problem.

I hope this helps.

Selva V Pauspathy
HSBC Global Resourcing
For more on Excel, VBA, & other programming resources,
Please Visit: http://socko.wordpress.com
 
I found a novel way to achieve some padding around a cell without using the options above. If you're not restricted by the font you want to use then try using a different one as fonts have different spacing attributes. It may not be perfect and you cant adjust any values but it may make enough of a difference to have the desired effect.
 
Back
Top