Cómo ajustar el texto en una celda de Excel para que se ajuste al contenido

Microsoft Excel’s AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can’t change the size of a cell to fit the text, this tip shows how you can resize the text to fit within the cell.

When text is too long to display in a cell, that text is visible until you enter content in the adjacent cell. If this happens, Excel offers several options that allow you to see the contents in both cells. Let’s take a look at these options and how each changes the view.

Method 1: Use AutoFit

You can use Microsoft Excel’s AutoFit feature to enlarge a cell enough to display the full contents of a cell. But first, let’s review the problem. As you can see in Figure A, the content in column C obscures the content in column B.

To apply AutoFit, hover over the right border of the column B header cell and double-click, or click the Format dropdown (in the Cells group on the Home tab) and choose AutoFit Column Width (Figure B).

Cómo calcular las horas trabajadas en Excel: guía paso a paso y consejos

Either way, Excel expands the width to accommodate the longest entry in the column, as shown in Figure C.

For better or worse, this option results in too much white space in some cells in column B.

To bypass the interface, or if the double-click method doesn’t work, you can select the cell or column you want to resize and press Alt, H, O and I. However, you can also use this method to reduce the size of a column that is much too wide.

Method 2: Resize the content

Rather than fitting the cell to the content, Excel also lets you resize the content to fit the cell. Follow these steps to resize your content:

¡Mejora tu flujo de trabajo con Microsoft Office

1. Select the cell with text that’s too long to fully display, and press [Ctrl]1. Alternatively, you can click the Number group’s dialog launcher.
2. In the Format Cells dialog box, click the Alignment tab.
3. Check the Shrink to fit option on the Alignment tab (Figure D).

Click OK.

Sometimes the Shrink to fit method shrinks text to the point of sacrificing legibility, as shown in Figure E. It’s worth noting this option only applies to the selected cell(s), whereas the AutoFit option applies to the entire column.

To bypass the ribbon interface to apply Shrink to fit, press Alt, H, F and A. Doing so will open the Format Cells dialog shown in Figure D.

Method 3: Wrap text

An alternate method to AutoFit and Shrink to fit is to wrap text within the selected cell by selecting the Wrap Text option on the Alignment tab of the Format Cells dialog box (Figure F).

Paycom vs. ADP: Cuál es la mejor solución de gestión de capital humano para tu negocio

Keep in mind that this method will increase the height of the cell, as shown in Figure F. In this case, wrapping makes a bit of a mess, but it comes in handy in the right circumstances.

The option you use to display text will depend on your needs at the time. Fortunately, Excel is flexible enough to handle long text in several ways.To bypass the ribbon interface to apply Shrink to fit, press Alt, H, F and A. Doing so will open the Format Cells dialog shown in Figure D.

En Newsmatic nos especializamos en tecnología de vanguardia, contamos con los artículos mas novedosos sobre Software, allí encontraras muchos artículos similares a Cómo ajustar el texto en una celda de Excel para que se ajuste al contenido , tenemos lo ultimo en tecnología 2023.