FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Wrap text automatically In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)

Detailed explanation-2: -To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2). Click the location inside the selected cell where you want to break the line.

Detailed explanation-3: -Select a cell and enter text; press and hold Alt. Press Enter and release Alt. For more than two lines of text, press Alt+Enter at each line’s end. Wrap existing text: Select the cell, press F2, place the cursor where you want the line broken.

Detailed explanation-4: -The Excel wrap text feature can help you fully display longer text in a cell without it overflowing to other cells. “Wrapping text” means displaying the cell contents on multiple lines, rather than one long line.