answersLogoWhite

0


Best Answer

I assume you mean in Excel, or similar spreadsheet programs. In Excel, you can use the "Word Wrap" option, which you find under cell format. In that case, if there is too much text in the cell the row height will grow to make more room below.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What formatting option can be used to stop text from going outside of it's cells borders?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the process of changing the appperance of cells and the overall layout of the worksheet?

It is called formatting. You first select the cells you want to format. Then you go to the Format menu and pick the formatting option you want to use.


Where can borders be added in a worksheet?

Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.Where, in the sense of what part can have borders, can be said to be anywhere. You can have borders around all cells or selected areas. Where in the sense of where you can do it from, you can do it from the Format menu and then picking Cells and Border. You can also do it through the Formatting toolbar.


What is the use of format cell dialog box?

It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.It allows you to apply a range of formatting to cells. It would include various number formats, date formats, colours, borders, patterns, alignments etc.


Can cell alignment be change in Excel?

You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.You can do it in a few places like on the Format menu or on the formatting toolbar. Right clicking on the cell and pick the Format Cells option and Alignment is another way.


What is the difference between font and border formatting?

Font formatting affects text changing things like text size, colour, font-face etc. Border formatting affects borders around boxes, cells, pictures etc. It will change things like style, colour, thickness and combinations of borders, like having different borders on different sides.


How do you create a border in Microsoft office Excel?

The cell borders, which you see when first opening an excel page will not appear on print preview or on paper. They are there by default, so you can tell which cell you are entering your data into. In order to see any borders, you have to create them yourself with the border tool.


Can format be applied between cells?

Format is applied to cells and ranges of cells. The only formatting between cells actually is to format the cell border, since all adjacent cells share the same borders with the cells they touch.


How will you set the border for only four cells in Excel?

Select the 4 cells. Open up the Formatting options, which you can do with Ctrl - 1, and then go to the Borders tab. From there you can choose the style of the borders you want, including things like colour and thickness, and then apply them to the selected cells.


What is used to combine cells together in the program excel?

You can use the Merge and Center icon on the formatting toolbar or do it through the Format menu by going to Cells and then picking the Merge cells option.


How do you show figure in thousand mode in Excel?

Go to the Format Cells option and to the Number option. Press Ctrl - 1 to access Format Cells. You can use Ctrl-Shift-1 to apply the thousands formatting too. Another option is to click on the comma icon.


how do you formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting?

That is known as conditional formatting. To apply it, select the cells you want and choose the Conditional Formatting option. You then need to set the rules that define your formatting and also what formatting you actually want. There are a broad range of options to choose from and different ways of applying it. It will depend on what you need.


What are 6 cell formats in Microsoft Excel?

Here are four specific formatting options for values:Percentage.Currency.General.Time.You can also have text formatting like Bold and Italics and Underline. You can have alignment formatting, like left, right and centred. You can change borders around cells and the colours of cells. You can change the font of a cell and the size of its text.