Cell margins ?

[Blue Max]

Our cell margins (indents) are too big, even set to 1 for a single
character. Being able to reduce the left column margins a hair would let us
fit more columns on a printed page without decreasing the font size. How do
we get smaller margins?

We have tried adding spaces to the number/text format, which helps some, but
the left space does not affect wrapped lines in the cell.

Ironically, Microsoft Word appears to have more flexibility in this area
than Excel. In Word you have unlimited flexibility in that you can set the
table cell margins (left, right, top, bottom) in fractions of an inch.
Moreover, other popular spreadsheet programs also provide a margin feature.
So why would Excel, whose main focus is tables (or worksheets), have less
flexibility than Word? Have we missed a feature in Excel for setting
internal cell margins? If not, Microsoft really needs to consider
implementing margins (left, right, top, bottom) for cells!

Thank you for any help,

Richard

 

[Gord Dibben]

Cannot be done in Excel which has limited word processing features.

Indents are not adjustable.

Excel's main focus is crunching numbers.


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

You can always sqeeze more on a printed page by using Fit to x wide y tall
in the page setup dialog box, first tab.

However, it is possibe to bring the text right up to the left border of the
cell. I'm not saying you will want to do it but here goes

1. Enter the data in a cell
2. Click Increase Indent until the text flows just over the edge on the right.
3. Click the Left Align button - the text will now flow over the left
4. Now widen the column just wide enough so the text directly abutts the
left grid line.

 

[Blue Max]

Thanks, Gord, we appreciate the confirmation of this limitation. However,
we feel it is an unfortunate limitation. In our humble estimation, when you
inhibit the presentation aspects of the numbers analysis then you also
inhibit the value of the 'number crunching' capability.

Thanks,
Richard

***************