深度阅读

How to Indent in Excel

作者
作者
2023年08月22日
更新时间
13.46 分钟
阅读时间
0
阅读量

By default, Excel aligns numbers to the right in a cell.

Text and Number alignment in Excel

And if you don’t like these numbers/texts are too close to the cell border.You can indent in a cell.

Indent using a Keyboard Shortcut

Below is the keyboard shortcut you can do.

ALT + H + 6 (to indent to the right)
ALT + H + 5 (to indent to the left)

Indent using Ribbon Options

If you prefer using the mouse instead, excel has the options in the ribbon.

Select the cells where you want to apply.

Click the Home tab

In the Alignment group, click on the indent icons (based on whether you want to indent left or right)

Note that the indentation is applied to the whole cell content.

Indenting Individual Lines in the Same Cell

In case you have multiple lines in the same cell, you may want indent only some of the cells .

This, can be done with a work-around .You can do this by manually adding the space characters .

博客作者

热爱技术,乐于分享,持续学习。专注于Web开发、系统架构设计和人工智能领域。