answersLogoWhite

0

Initially all rows have the same formatting. As users enter data they can set different formatting for other cells, columns or rows. They can use Autoformatting, which is capable of picking up on regular data and formulas and apply different formatting to them. You can also use conditional formatting to change the format based on values in the cells or other conditions.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What causes adjacent rows to have different formatting so that each row in table is distinguished from surrounding rows?

You can do this by using the :nth-child() pseudo-class in CSS. Your CSS would look something similar to this: table { background-color:white;} table tr:nth-child(2n+1) { background-color:grey;} To see an example of this at work, check the related jsFiddle.


What check box in the Table style options group enables you to apply different formatting to the records in a table?

Banded Rows


What check box in the Table style options group enables you to apply different formatting to the records in a table?

Banded Rows


In Excel what key do you hold down if two rows are adjacent to one another to avoid selecting all the rows?

Pressing the Shift key while clicking on the row header will select rows that are adjacent, selecting all rows between the first and last row you select. Pressing the Ctrl key while clicking on the row header will select rows that are not adjacent.


What is range in a Excel document?

collection of adjacent cells, rows, or columns


How do you remove banded rows in Excel?

You can delete the actual row by selecting it and using the Delete rows option. That will also delete the data. If you just want to get rid of the actual banding and keep the data, you can select the rows and change the formatting, and set it to be the same as the other rows.


What is formatting in spreadsheet?

It is presenting the data in a way that is appropriate. If you are dealing with numbers, you may want them in currency or percent or fractions etc. You may want text to be different sizes or colours or fonts. You may want things underlined or bolded or in italics. You can have borders around cells. You can have different cells to be set to different colours. If you have a table of data laid out, you could have the different columns or the different rows in different colours. All of these and other things are ways of formatting data in a spreadsheet.


What is the largest server case available?

The 2U and 4U are about the same size -- 2U occupies two complete adjacent rows, while the 4U occupies four rows at half-width.


What is an alleyway?

An alleyway is a narrow street formed by the gap between adjacent buildings, or a passage between two rows of cabins in a ship.


What is Alleyway?

An alleyway is a narrow street formed by the gap between adjacent buildings, or a passage between two rows of cabins in a ship.


Is a range a seriers of two or more adjacent cells in a column or row or a rectangular group of cells?

Yes a range is two or more adjacent cells and they can be in rows or columns or both. A range is always rectangular in shape.


Are lat rows and horizontal rows the same thing in weightlifting?

No, they stretch different muscles.