Excel+-+Indenting+Function

=**__Indenting Contents of a Cell__**= It's a great function. The first time I learned about it was through the First Advantage Training Link and on today's exam.

I create a lot of financial spreadsheets for work. I wish I knew about the indenting cell data early on. The indenting function would be a great tool for me when I'm creating an Income Statement and Balance Sheet. Certain headings/titles need to be indented. I would hit the space bar as many times to get the headings aligned differently in order to read the statement clearly...

Example:
 * ~ Elisa's Inc. ||~  ||~   ||
 * Operatng Income: ||  || [[image:http://www.wikispaces.com/i/editor/insert_table.gif]] ||
 * Sales ||  || 100,000 ||
 * Total Operating Income: || 100,000 ||
 * Operating Expenses: ||  ||   ||
 * Office Salaries ||  || 25,000 ||
 * Payroll Taxes ||  || 10,000 ||
 * Net Income ||  || 65,000 ||
 * Net Income ||  || 65,000 ||
 * Net Income ||  || 65,000 ||

The schedules I create are more complex then the one above this is a very short example. Creating this table I had to use the space bar to indent the line items. The very easy way is by selecting the cells I want indented (at times I could have over 30 operating expense accounts) Click on Format on the Ribbon (Home-Cells) in the protection area click on Format Cells choose the alignment tab and click the down arrow on the Horizontal you could choose from Left (Indent) or Right (Indent) or Distributed (Indent). Then click on the Indent box and choose how many spaces you want indented. This beats using the space bar and trying to even out headings and descriptions. The money part is no problem the normal alignment (left, center, right) function used is right justification.

This is a great, efficient (time-saving) tool to use especially if you are creating financial reports like I do. it's a great function.

The above is not the only way to choose the indent function there's a shortcut: select the cells, right click and choose format and then follow the part of the alignment tab and one other way choose the alignment tab on the ribbon and follow the same steps.

I hope this was very helpful to everyone or at least some of you.

Enjoy your evening. I have to go watch my show NCIS.....

Elisa