In this article we will learn how to decrease and increase the text towards the cell border you can use “Indent” option in Microsoft Excel 2010. It is a part of “Format Cells”, in “Alignment” tab in “Text Alignment”. There are two types of Indent one is “Increase Indent” and second is “Decrease Indent”.
Here are the steps to add indentation to list items: Select the entire column which has the indentation (in this example, it’s column A). To do this, click on the top of the column label (where it says A) Right-click and select ‘Insert 1 left’. The easiest way to indent is to use the the Indent buttons in the alignment group on the home tab of the ribbon. One button increases the indent by one step, and the other button decreases the indent by one step. Once you reach zero, clicking decrease indent has no further effect.
“Decrease Indent is used to move the content closer to the cell border”
“Increase Indent is used to move the content further away from the cell border”
To understand Changing the Indentation in Microsoft Excel 2010/2013,let’s take an example and understand:-
Wrap Text by using the shortcut command
I have text in cell A1 to A12, to change the indentation in a cell follow the below mentioned steps:-
Step 1: Select the list of expenses below each division for example: select the cells A2:A6 (a group of expenses for Department 1).
Step 2: Go to “Home” tab in the group of “Alignment” click on the “Increase Indent” icon on the formatting tool bar several times until you reach the desired indentation.
Step 3: To go back the position click on “Decrease Indent” icon on the formatting toolbar several times until you reach the desired indentation.
OR
Step 1: Select the range A2:A7 and Press the key “CTRL + 1”.
Step 2: Format Cells dialog boxwill appear, select the “Alignment” tab and in the Indent box change the number of characters to Indent.
Step 3: Select the Right (Indent) in Horizontal.
Step 4: Type 5 in indent.
Click on Ok.
What is Excel VBA Indentation?
Indentation represents some spaces at the beginning of a new row of sentence. Indentation is not a word reserved for VBA, it is a word that also appears in Microsoft Word, Excel spreadsheet and even Powerpoint. Indentation is also used for all kinds of computer programming.
In VBA coding, indentation is not mandatory, which means it does not cause compile error if you miss it, but it is definitely a good practice for you or for others to follow your code easily. There is no black and white rule for what code needs to be indented, but there are generally acceptable rules.
Why do you need Excel VBA Indentation?
I will show an example below for you to understand more easily. The below code has no indentation.
Now with indentation
The first code is difficult to read because it looks like a mess, all codes combine together.
The second code is easier because codes are in different layers.
Rules of Excel VBA Indentation
There are some generally acceptable rules for indentation
1) For each set of code that has an starting and ending keyword such as IF…End If, indent the lines of code between. Use “Tab” key for indentation, Shift+Tab to undo the Tab effect.
2) Do not need to indent code that has starting keyword but no ending keyword in separate line, such as Dim xxx As Integer
2) Double line spacing is optional, just use it if it makes you easier to read
3) Do not worry about spacing within each line of code, it will be adjusted automatically
Example 1
Indent the codes between Sub and End Sub
Example 2
How To Increase Indent Excel
Indent the codes between If and End If
Example 3
Indent the codes between For /Next and nested IF / Else / End IF
Just ignore what the code means, focus on the indentation.
VBE Option – Auto Indent
VBE (Visual Basic Editor) has an option called Auto Indent, but it does not automatically indent all lines of code. Auto Indent functions when you press Enter key to start a new line, if the code before you press Enter has indentation, the new line will begin at the position of the previous indentation. If you don’t turn on the Auto Indent function, the next line will start on the left.
In VBE, navigate to Tools > Options >Editor Tab
Check the box Auto Indent to enable the option, you can also specify Tab width, the default value is 4, you can leave it as is.