ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   in an Excel table how do I set cell internal margins??? (https://www.excelbanter.com/excel-discussion-misc-queries/216940-excel-table-how-do-i-set-cell-internal-margins.html)

Brit in US

in an Excel table how do I set cell internal margins???
 
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...

Bernard Liengme

in an Excel table how do I set cell internal margins???
 
Excel is not a word-processing package.
The only place 'margins' have meaning for Excel is in Page Setup
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brit in US" <Brit in wrote in message
...
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...




Brit in US[_2_]

in an Excel table how do I set cell internal margins???
 
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?


"Bernard Liengme" wrote:

Excel is not a word-processing package.
The only place 'margins' have meaning for Excel is in Page Setup
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brit in US" <Brit in wrote in message
...
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...





Bernard Liengme

in an Excel table how do I set cell internal margins???
 
Insert a column to the left and another to the right
Make these columns narrow
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brit in US" wrote in message
...
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?


"Bernard Liengme" wrote:

Excel is not a word-processing package.
The only place 'margins' have meaning for Excel is in Page Setup
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Brit in US" <Brit in wrote in message
...
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...







Socko

in an Excel table how do I set cell internal margins???
 
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

Gord Dibben

in an Excel table how do I set cell internal margins???
 
OP wants less space<g


Gord

On Sun, 25 Jan 2009 22:49:18 -0800 (PST), Socko
wrote:

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




All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com