Solved In Excel-2010, regarding INDENT?

March 1, 2013 at 17:30:03
Specs: Windows 7
Example: Column is formatted to NUMBERS, alignment RIGHT, indent 1.
Question: Is there any way to make this indent smaller?

In Indent settings the smallest number is 1 (no possibility for 0.5), I know that. However is there any other way to make it smaller? I would like my cell input numbers to come closer to the right line. I hate indent "0", it doesn't look good on printouts and indent "1" still gives a rather large gap between the data and the right line. I've tried few things and nothing worked so far. Perhaps you guys can give me some tips here.


See More: In Excel-2010, regarding INDENT?

Report •


✔ Best Answer
March 2, 2013 at 16:57:07
I assume you are printing the grid lines or cell borders.

Eliminate that and draw your own lines midway between the "Indent 1" location and the actual cell border.

It might be a lot of work to set up the first time, but if it allows you to get the document to look the way you want, it might be worth it the effort.

Just a thought.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.



#1
March 1, 2013 at 17:52:02
The only thing I can think of, is perhaps a different Font.

Something like Ariel Narrow.

MIKE

http://www.skeptic.com/


Report •

#2
March 1, 2013 at 18:03:48
Edwardian Script gives it a right tilt that get's it a bit closer.

MIKE

http://www.skeptic.com/


Report •

#3
March 1, 2013 at 18:07:50
Try Tilting the cell by one degree plus or minus, see if that helps.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
March 1, 2013 at 18:10:21
I've tried that already. Changed to Arial Narrow 8 (smallest poss) in General Settings and I've tried this same font in the column itself and the INDENT 1 spacing remained constant.

Tilting the cell + - 1 degree? I'm afraid I've never heard of that one before. Could you please elaborate on How can I do something like that?


Report •

#5
March 1, 2013 at 18:24:04
Sorry, I should have said Orientation

Select Format Cells
Select Alignment Tab

Orientation on the right side of window.

You can "tilt" the contents of the cell by degrees.
Try one or two degrees, plus or minus,
that may get it closer to the edge and should not
be really noticeable.

MIKE

http://www.skeptic.com/


Report •

#6
March 1, 2013 at 18:32:28
Hmm, I've just tried the "Tilting" option (+ and - 1, 2). Didn't work definitely, it sent the cell data number way off (couple of cells further to left or right with just + or - 1).

I thank you very much for your effort though. Seems there's no solution to this, will set your answer to "SOLVED".


Report •

#7
March 1, 2013 at 18:38:09
It should not have sent the cell data way off, it should have just titled the data within the cell.
What version of Excel are you using?

MIKE

http://www.skeptic.com/


Report •

#8
March 1, 2013 at 18:45:54
I'm using Excel-2010 v14.0.4760.1000 (32bit). However, I've tried your Tilting option just then on my Laptop with Win7-64bit. Will try your option later on my desktop with Win7-32bit and see if there's any diff (if that should make any difference?).

Report •

#9
March 1, 2013 at 18:55:41
Here is a link for 2010, which is the same for 2007.

http://www.addictivetips.com/micros...

The only other thing I can think of, is if you have selected an Indent of 1,
Applying any Orientation will force the Indent back to 0.

But it should not send the cell data number way off (couple of cells further to left or right
It should just Tilt the data.

MIKE

http://www.skeptic.com/


Report •

#10
March 1, 2013 at 19:04:10
Well you're correct in saying it should just tilt the text, but I'm getting totally dif outcome here. Mind you this is not exactly a legit soft, lol ... perhaps that makes some dif in behavior (in some areas anyway).

Report •

#11
March 2, 2013 at 16:57:07
✔ Best Answer
I assume you are printing the grid lines or cell borders.

Eliminate that and draw your own lines midway between the "Indent 1" location and the actual cell border.

It might be a lot of work to set up the first time, but if it allows you to get the document to look the way you want, it might be worth it the effort.

Just a thought.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#12
March 3, 2013 at 02:10:39
Well that's not bad idea at all, haven't thought of it. Thank you for this little tip DerbyDad03. As you say it'll take a little effort to set up the very first sheet, then after that is just copy-copy.

You have a good day Sir, and thank you kindly.


Report •

Ask Question