Question

rohit is preparing monthly sales report with help of spreadsheet. While typong the text is not accomodated within the column width. What should he use to make the text appear properly?
​

Answer 1

Rohit should resize the column width along with text wrapping, and formatting so that text is accommodated.

• Microsoft Excel is a powerful spreadsheet application that is commonly used to organize, store, and manipulate data.
• If the text in a spreadsheet is not fitting within the column width, Rohit can try the following options to make the text appear properly:

Increase the column width

1. Rohit can increase the column width by dragging the right boundary of the column header to the right.
2. This can also be done by double-clicking on the boundary to auto-fit the column to the width of the longest text in the column.

Wrap text

1. Rohit can wrap the text within the cell by selecting the cell and then going clicking on the Wrap Text button in the "Alignment" group.
2. This will make the text wrap to the next line within the cell to fit within the column width.

Reduce font size

1. Rohit can also try reducing the font size of the text to make it fit within the column width.

#SPJ1