Solved

Modify (customize) size of indent in Excel

Posted on 2010-11-29
5
2,854 Views
Last Modified: 2012-05-10
Hello,

In Excel (2007), is there any way to change or customize the default size of indents?

I am not referring to the width of columns but rather, the indent inside a given cell which can be accessed in two different ways (that I know of):

1)  > Ribbon Home tab > Alignment section > Increase Indent or Decrease Indent buttons

2)  > Ribbon Home tab > Alignment section > bottom-right expansion button > Text alignment > Indent box

The second option allows you to set the number of desired indents, but unfortunately, not the width of each indent.  It is this width with which I am struggling.  If anyone knows how to reset or modify that, I would appreciate knowing.

Thanks
0
Comment
Question by:Steve_Brady
  • 2
  • 2
5 Comments
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 34235514
Hello Steve,

I don't think you can change the indent size. My empirical tests show that it remains the same, even for different font sizes. You can use code to set the indent level (between 1 and 15) but I have not found any indicator of setting the base size of the indent width.

cheers, teylyn

0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 34235523
With the macros we discussed a few questions ago you can set them to whatever you want. Then you can add them to the ribbon or a hotkey or both as we discussed then.
Sub IncreaseIndent()
    Selection.InsertIndent 3 'Can be anything (I suppose up to 15)
End Sub
Sub DecreaseIndent()
    Selection.InsertIndent -3
End Sub

Open in new window

0
 

Author Comment

by:Steve_Brady
ID: 34305173
Thanks for the responses.

>>...you can set them to whatever you want.
>>Selection.InsertIndent 3
>>Selection.InsertIndent -3


Tommy, please correct me if the following is wrong but I believe your code refers to the number of indents to be inserted rather than the width of each individual indent (e.g. it is not possible to have a width of -3).  Only the latter was the object of my question:

>>The second option allows you to set the number of desired indents, but unfortunately, not the width of each indent.  It is this width with which I am struggling.

0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 34305357
Ah, yes. Sorry. In that case, I agree with teylyn that the indent size is static. You can't change the width of the indent. Pressing the 'increase indent' button runs this line of code
Selection.InsertIndent 1
and just adds an indent. So you can't change the default size of the indent but you can change the number of indents that your custom button or hotkey makes.
If you press 'record macro' and change the indents in both the ways you mention, you'll see that it isn't changing the width, it's changing the number.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 34421966
Thanks for the grade, Steve.

However(/if at all) you celebrate the end of the year, I wish you a peaceful holiday season and a great start into a wonderful 2011.

Please keep posting your interesting questions, where you challenge the usability of MS Excel and prop the experts onto their toes.

It's been  very interesting working with you. I appreciate your drive to learn and understand. I'm absolutely amazed at your communication skills. I'm baffled at your sense of humour and how you've managed to drive finicky disagreements into clear-cut statements of what is important to the parties involved.

Steve, I'm pretty sure that without your questions and your feedback to experts, I would not have achieved the rank I have right now in the same time frame.

Maybe in the new year you could consider  answering questions, too. I believe that with your attitude and mindset you would be a great asset to EE.

From a warm NZ mid summer night, I send you my best wishes and hope you will continue to post your challenges at EE in the new year.  (Just remember to check the open questions from time to time. I'm sure you can answer quite a lot of them, and that will open up a completely new aspect of EE).

Kindest regards,

teylyn


0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now