How to Indent Cells in Microsoft Excel

If you’re trying to figure out how to indent cells in Excel, you’ve come to the right place. Want to indent from the right instead of the left? Need to indent more than one level? Here are four different ways to indent in Microsoft Excel.

Use the Ribbon to Indent Cells

One of the easiest ways to indent cells is using the Alignment section of the ribbon in Excel. This allows you to indent from the left side of the cell as many levels as you like.

  1. Select the cell containing the data you want to indent and head to the Home tab.
  2. In the Alignment group, use the Increase Indent button to indent one level.
  1. You can increase more than one level by continuing to select the Increase Indent icon.
  1. To decrease the indent, simply use the Decrease Indent button.

Use the Format Cells Feature to Indent Cells

If you prefer to indent a cell from the right side or want a larger level size, you can use the Format Cells dialog box.

  1. Select the cell you want to indent and do one of the following:
  2. Right-click and choose Format Cells.
  3. Use the small arrow in the lower right corner of the Alignment section on Windows.
  4. Select Format > Cells from the menu bar on Mac.
  1. When the Format Cells dialog box opens, confirm that you’re on the Alignment tab.
  2. Use the Horizontal drop-down box to choose one of the indent options from Left, Right, or Distributed per your preference.
  1. Enter a number or use the arrows in the Indent field to the right to specify the indent level.
  1. Select OK to save your change, and you should see your cell indented per those settings.

Use a Keyboard Shortcut to Indent Cells

Do you like using Excel shortcuts to perform actions quickly? You can use a keyboard shortcut to indent text in a cell on both Windows and Mac.

Windows: Use the key combination Alt + H + 6 to indent one level from the left or Alt + H + 5 to decrease the indent.

Mac: Use the keyboard shortcut Control + Option + Tab to indent one level left from the left or Control + Option + Shift + Tab to decrease the indent.

On either platform, you can hold the modifier keys and continue pressing the last key to increase or decrease the indent levels. For example, on Mac, hold Control + Option while you keep pressing Tab to increase the indent one level at a time.

Use Spaces to Indent Cells

This final method for indenting on Excel is using your Space key. While not necessary if you want to indent all cell contents, it is required if you want to indent individual lines in the same cell. This is useful if you have separate lines of text as list items or an outline.

As a refresher, you can insert line breaks in a cell using a keyboard shortcut. Place your cursor in front of the word for the new line. Then, on Windows, use Alt + Enter, or on Mac, use Command + Return.

  1. Select the cell with the lines you want to indent and place your cursor at the beginning of the line. You can do this in the cell itself or the Formula Bar at the top of the sheet.

Tip: If you don’t see the Formula Bar, go to the View tab and mark the Formula Bar checkbox.

  1. Then, use the Spacebar to insert as many spaces as needed at the start of the line. You can do the same for the other lines of text in the cell as needed.
  1. When you finish, use Enter or Return to apply the change.

Formatting in your Excel spreadsheet is a common action because you want to display your data in an easy-to-read way. If that means indenting a cell, we’ve shown you four simple ways to get it done.

Now that you know how to indent in Excel, why not look at how to fix a hanging indent in Microsoft Word.



Source : How to Indent Cells in Microsoft Excel

Comments

Post a Comment

Popular posts from this blog

How to Alternate Row and Column Colors in Microsoft Excel

Image
Alternating the colors of rows and columns in Excel , also known as banding, is one way to make the document easier to read. This practice is helpful when you have documents with lots of data , whether a school or work project. Microsoft Excel doesn’t have a dedicated button to alternate row and column colors, so you’ll have to be creative to achieve the result of banded rows. An Excel document offers several ways to alternate row and column colors. For example, you can select specific rows and columns and apply a color to each one of them. Although this might sound like a simple solution, manually applying row and column colors would be tedious if your Excel spreadsheet contains thousands of entries. Imagine having to do it to all the documents in a workbook. So, let’s see what you can do to alternate row and column colors in Microsoft Excel quickly. 1. Color Rows and Columns Using Table Style Banding Using the predefined table styles is a quick way to apply alternate colors to
Read more

How to Add or Remove a Secondary Axis in Microsoft Excel Charts

Image
When you have a chart with mixed data types or a dataset that varies broadly between series, consider using a secondary axis in Microsoft Excel. With it, you can display the data you need without overwhelming or confusing your viewers. When to Use a Secondary Axis As mentioned, if you have different data types or your series amounts widely vary, these are good times to use a secondary axis. For instance, you can see that the column chart below doesn’t accurately depict the visitors and sales in our dataset. There’s a large variance in the sales amounts, making it hard to get a decent picture of the number of visitors per month. Plus, the sales are in dollar amounts, whereas the visitors are basic number values . If your chart would benefit from a secondary axis like this one, here’s how to add one as well as remove a secondary axis later if you change your mind or your data. How to Add a Secondary Axis in Excel To add a secondary axis to your Excel chart, you’ll use the combo
Read more

How to Use and Customise the Status Bar in Microsoft Excel

Image
Excel’s status bar is one of the hidden gems (and an unsung hero) that makes it the default spreadsheet software you turn to. It quietly resides at the bottom of the Excel window, often overlooked but brimming with valuable information and customization options. In this article, we will look at it and show you how to take advantage of it. Excel Status Bar Default Options Even before you customize the Excel status bar, it’ll display some helpful information and give you access to some useful functionalities. The common Excel options you can find as default on the status bar are: Cell Mode Macro Recording Tool Accessibility Check Page Number Statistics/Mathematical Options Worksheet Views Zoom Options Let’s see what each of them does and how you can use them. Cell Mode At the leftmost side of the Excel status bar, you’ll find the cell mode indicator. It’ll inform you about the status of the currently selected cell. There are four different status modes: Ready . It
Read more