FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.) Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Detailed explanation-2: -Formatting Cell as Wrap Text We can put multiple lines in a cell by formatting it as Wrap Text. This feature adjusts the width of the cell to make all content visible within a cell by displaying it on multiple lines.

Detailed explanation-3: -Wrap text in a cell or group of cells Select the cells that you want to format. On the Home tab, click Wrap Text. Text inside the cell wraps to fit the column width. When you change the column width, text wrapping adjusts automatically.

Detailed explanation-4: -Press Alt + Enter to add another line to the cell. Tip. Keep pressing Alt + Enter until the cursor is where you would like to type your next line of text. Type the next line of text you would like in the cell.

Detailed explanation-5: -You can put multiple lines in a cell with pressing Alt + Enter keys simultaneously while entering texts. Pressing the Alt + Enter keys simultaneously helps you separate texts with different lines in one cell. With this shortcut key, you can split the cell contents into multiple lines at any position as you need.