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


When a table is formatted with banded rows what does it mean?

Banded rows in a table refer to a formatting style where alternating rows are shaded with different colors or patterns. This technique enhances readability by helping users easily distinguish between rows, making it easier to track information across the table. Banded rows are commonly used in spreadsheets and reports to improve visual clarity and organization.


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.


The command that adjusts the height of the rows in a table so that they are equal is called what?

The command that adjusts the height of the rows in a table so that they are equal is called "Distribute Rows." This feature ensures that all rows in the selected table have the same height, providing a uniform appearance. It can typically be found in the table formatting options of word processing or spreadsheet software.


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.