What is general table formatting? Formatting cells

Techniques for entering and editing table cell values ​​are described in table. 4.1.

Table 4.1.

Operation	Actions
Entering a cell	Select a cell, enter a value, press Enter Select a cell, enter a value in the input line field, press Enter
Switching to cell editing mode	Select a cell and click on it with the mouse Select a cell, press F2
Exit cell editing mode	Press Enter Select another cell Press Escape to cancel changes made to a cell
Editing a cell	Edit the cell value in the input line and click to confirm the changes Go to cell editing mode, change the value, press Enter

Methods for selecting table fragments are given in Table 4.2.

Table 4.2.

Fragment	Actions
	Mouse click on a cell Place a marker on a cell using the cursor keys
Adjacent cell block	While holding down the left mouse button, move the mouse diagonally across the selected block Select the first cell of the block. Hold down the Shift key and use the cursor keys to move the pointer to the last cell of the block
Row or Column	Click on a row or column header
Adjacent rows (columns)	While holding down the left mouse button, move the mouse over the headers of the selected rows (columns)
Non-contiguous mixed fragment	While holding down the Ctrl key, select cells, blocks of cells, rows, or columns one by one
Entire table	Click on the selection area of ​​the entire table (the empty square at the intersection of the row and column headings)

To deselect any of the listed fragments, simply click on any table cell or press any cursor key.

Formatting a table allows you to change its appearance, add and remove rows (columns), and change the size of rows and columns. A description of formatting techniques is contained in Table 4.3.

Table 4.3.

	Action
Inserting a line (multiple lines)	Select the line before which you want to insert a new line. Select the menu item Insert/New task (Insert/Resource from the following source) or press the Insert key. As many empty lines as were allocated will be added Select the context menu item of the selected line New task (New resource)
Deleting a line (multiple lines)	Select the rows to be deleted and select the Edit/Delete task (Delete resource or Delete row) menu item, select Delete task (Delete resource or Delete row) from the context menu of the selected rows, press the Delete key
Adding a Column	Select the column to the left of which you want to add a new column. Select the menu item Insert/Column (or Insert Column from the context menu of the selected area). In the dialog that opens, in the Field name field, select the database parameter whose value should be displayed in the column, click Ok
Change the data displayed in a column	Double-click on the column header. In the dialog that opens, change the contents of the Field Name field and select the database parameter whose value should be displayed in the column
Delete a column	Select the column and select the Edit/Hide Column menu item (or Hide Column from the context menu)
Move a row (column)	Select a row (column). Hover your mouse over the row (column) heading. Press the left mouse button and, without releasing it, move the horizontal (vertical) bar indicating the new location of the row (column). Release the mouse
Copying a line (multiple lines)	Select the lines to be copied. Select the menu item Edit/Copy task (Copy resource, Copy line). Place a marker in the line before which you should paste the copied lines and select the Edit/Paste menu item
Changing Row Height (Column Width)	Move the border of a row (column) with the mouse
Font formatting	Select the table fragment to be formatted and set the font parameters using the Format/Font item or using the Formatting toolbar
Formatting styles	Select the menu item Format/Text Styles. In the dialog that opens, in the Editable element field, select the type of tasks, resources or presentation fragments whose text will be formatted, then assign the font format and click Ok

An example of formatting styles on a Gantt chart. Here the font format of the row and column headings has been changed (bold italic with underlining), the font color is green for milestones, blue for phases, and red for critical tasks. In addition to table text, formatting styles allows you to change the format of some portions of views. This is how the format of the inscriptions on the time scale has been changed: the middle level of the scale is crimson, and the lower level is olive (the upper level of the scale is not shown in the figure).

Highlighting different table elements

Before you can use commands to edit or format tables, you need to learn how to highlight the different elements of a table. There are two ways to select: using the mouse and using commands.

Task 2. Selecting table elements using the mouse. Using the information in table. 1, using a 4x4 table as an example, apply a selection to all table elements listed in this table.

Table 1.

Using the mouse to select table elements

Selectable element	Action
Cell	Click with the left mouse button in the cell selection area, which is located on the inside of the left border of the cell in front of the text; when the cursor enters this area, it will take the form of a thick black arrow pointing to the right and up.
Cell range	Select the first cell, then, without releasing the left mouse button, drag the pointer to the last cell of the selected area or, while holding down the Shift key, click on the last cell
Line	Click the left mouse button in the text selection area located opposite the selected line to the left of the table. If you need to select multiple rows, drag your mouse along the table in the selection bar
Column	Left-click on the top line of the column (the mouse pointer will take the form of a thick black arrow pointing down). If you need to select multiple columns, drag your mouse along the top border of the table
Table	Left-click on the table marker located in the upper left corner of the table

Task 3. Selecting table elements using menu commands. For this:

1. Place the mouse cursor in a cell belonging to the row or column that you want to select.

2. On the tab Layout In chapter Table click on the command Select(see Fig. 10). A drop-down menu will appear, which is shown in Fig. 16.

3. Consistently execute all the commands suggested in the menu, first deselecting them before executing the next command.

Rice. 16. Cell selection drop-down menu

Adding and removing cells

Very often you need to change the table structure by adding or removing individual cells, rows or columns. With one command you can remove or add several table elements at once. To do this, you need to select an area of ​​cells, after which any adding or deleting command will cause the appearance or disappearance of exactly the same number of cells, rows or columns as were contained in the selected area. In this case, an automatic shift of table elements occurs, reflecting ongoing changes in its structure.

You can add rows and columns anywhere in the table. Columns can be inserted to the left or right of the selection, and rows can be inserted at the top or bottom.

Task 4. Adding rows and columns to a table. To do this, follow these steps:

1. Select the first three rows of a 4x4 table.

2. Run the command Paste on top or Insert from below located on the tab Layout In chapter Columns and Rows(see Fig. 11). As a result, the table size will change and three rows will be added.

3. Select two columns.

4. Run the command Insert Left or Paste on the right located on the tab Layout In chapter Columns and Rows(see Fig. 11). This will change the size of the table, adding two columns by reducing the width of existing columns.

Task 5. Removing rows and columns from a table. To do this, follow these steps:

1. Select the first two rows of the table.

2. Run the command Delete located on the tab Layout In chapter Columns and Rows(see Fig. 11).

3. In the drop-down menu that appears, shown in Fig. 17, select team Delete rows. As a result, the table size will change and two rows will be deleted.

Rice. 17. Dropdown menu Removal

4. Select one column.

5. Run the command Delete located on the tab Layout In chapter Columns and Rows(see Fig. 11).

6. In the drop-down menu that appears, shown in Fig. 17, select team Remove columns. As a result, the table size will change and one column will be deleted.

7. The final table will be 5x5 in size.

Formatting tables

In MS Word, there are several ways to improve the appearance and ease of reading of tables by formatting them. You can set the formatting of any table element manually; you can use ready-made design layouts.

Task 8. Apply automatic formatting to the finished table. For this:

2. Set the courses inside the finished table.

3. On the tab Constructor In chapter Table styles (see Fig. 8) select any style and left-click on it.

4. In the section Table Style Options (see Fig. 7) you can customize existing styles by unchecking or checking the boxes next to the corresponding commands.

5. As a result of applying the style, the table may take the form shown in Fig. 20.

Rice. 20. Applying a ready-made style to a table

Task 9. Apply manual formatting to the finished table. For this:

1. Make a copy of the previous table.

2. Using a group of commands Draw borders (see Fig. 9), located on the tab Constructor, Select line type, assign color.

3. Select the first two rows of the table header.

4. Using the command Borders on the tab Table styles(see Fig. 8), assign All borders(Fig. 21) to the selected lines.

Rice. 21. Dropdown menu Borders

5. Select the table summary row.

6. Using the same command All borders assign a new frame.

7. Select the cells between the header and summary rows.

8. Assign a new frame using the commands External boundaries And Inner vertical border.

9. Without removing the selection, select another line type - thin, in order to draw dividing lines between the lines using the command Inner horizontal borders A.

10. As a result, the table will take the form shown in Fig. 22.

Rice. 22. Manually formatting a table

11. Save the document in your personal folder with the name Exercise 8.

12. Close MS Word editor.

Questions for self-control

1. What is a table?

2. What is a cell?

3. List ways to create tables?

4. In what ways can you create a simple table?

5. How can you create a table of complex shape?

6. Is it possible to apply formatting techniques intended for a paragraph to the text of a table?

7. Is it possible to apply a background fill and custom border design to table elements (cells, rows, columns)?

8. Is it possible to make calculations in a table?

9. Name a simple way to add rows to a table.

10. Is it possible to change the direction of text in a table?

Test

1. Which of the following methods of creating a table is the most effective (fast):

A. Graphic method

B. Insert, Table, Insert Table

C. Insert, Table, Draw Table

D. Insert, Table, Convert to Table

2. Which tabs are intended for working with tables:

B. Constructor

C. Insertion

D. Home

Creating and formatting tables

Table Word is a tool that provides rich options for arranging text in rows and columns. In other words, a table is a collection of cells arranged in rows and columns

Cell is the data entry space formed by the intersection of a row and a column in a table. Cells can be filled with free text, formulas, and graphics. Simple tables and spreadsheets can be inserted into the document text Excel. IN Word 2007 There is a collection of built-in templates for tables, similar to collections of headers and footers and title sheets.

A graphic illustration of the table elements is shown in Fig. 1.

Rice. 1. Table elements: 1 - column, 2 - row, 3 - cell

It is most convenient to use tables to present well-structured data, for example, lists, schedules, financial information.

A single cell can be treated as a separate document: text input, editing, and formatting operations are available for it. When you enter long text, the cell usually stretches vertically, but its width does not change.

Tables make it easy and quick to format the data they contain, sort it, and perform some calculations. Using tables, you can place text in several columns, change the direction of the text (for example, position it vertically), and align text paragraphs and pictures.

Tables have many advantages over tabulation. For example, if the text doesn't fit on one line, Word automatically increases the height of the table cell and places the text on two or more lines. In addition, when you use a table, you can easily align the sizes of rows and columns, and highlight individual table elements using borders and shading.

Tools for creating a table are on the tab Insert button Table, which allows you to create a table in six ways (Fig. 2):

Rice. 2. Dropdown menu Table

- Graphic method. When using this method, you need to select the required number of squares with the mouse, and you will get a table the width of the entire page with a given number of rows and columns, for example, a 4x4 table, as shown in Fig. 2.

- Insert table... When you select this command, a panel appears (Fig. 3), on which you can specify the number of rows and columns, the width of the columns in centimeters (automatic width adjustment). If several tables of the same type are created, you can check the box Default for new tables after that all you have to do is press OK to create a table with the same parameters.

Rice. 3. Dialogue menu Inserting a table

- Draw a table. Tables are built from arbitrary rectangles. With this method, you can also draw a table and erase unnecessary partitions.

- Convert to table... Using this command, you can convert a selected text fragment into a table (Fig. 4). The horizontal separator between cells is a tab sign, and the end of a paragraph is a transition to another line.

Rice. 4. Dialogue menu Convert to table.

- Excel table. When inserting a spreadsheet Excel and working in it, the Word menu is replaced with a menu Excel, all spreadsheet functions become available.

- Express tables. They allow you to create tables by selecting from a ready-made list (Fig. 5). You can add your table to the list by highlighting it and selecting Save the selected fragment to the express tables collection.

Rice. 5. Dropdown menu Express tables

Exercise 1. Creating a simple table of size 4x4 graphically. To do this, follow these steps:

1. Launch MS Word editor.

2. On the tab Insert click on the button Table. A drop-down menu will appear (see Figure 2).

3. Moving the mouse pointer over the layout, select the required number of rows and columns in the table, thereby determining the size of the future table.

4. Click the left mouse button when 4 rows and 4 columns are highlighted. After this, an empty table will appear in the document, shown in Fig. 6.

Rice. 6. Table size 4x4

Note! If you need to interrupt the table creation process, just click outside the layout.

The second way to create a simple table is to use the command Insert table... in the dropdown menu Table(see Fig. 2).

5. Using a command Insert table... create another simple table of size 2x2. In the dialog box that appears Inserting a table(see Fig. 3) enter in the field Number of columns: – 2, in the field Number of lines: – 2.

Note! In this dialog box, you can set the width of the columns of the future table in advance. By default, the column widths will be the same and the columns will be distributed across the width of the page.

Technology of working with tables

Moving around the table is done using the mouse or cursor or key control keys Tab.

One or more of the first rows of tables can be defined as a header. These lines are automatically repeated at the beginning of pages when the table is split or moved to other pages.

After creating a table, tabs appear Constructor And Layout, and at the very top there is a tab WORKING WITH TABLES. If the cursor is placed outside the table, then these tabs are not available.

On the tab Constructor There are three groups of commands:

- Table style options. This group of commands includes table parameters related to the visual highlighting of certain areas of the table (Fig. 7).

Rice. 7. Group teams Table Style Options

- Table styles. This group of commands includes table styling parameters (Fig. 8).

Rice. 8. Group teams Table styles

- Draw boundaries. This group of commands includes commands for selecting the thickness, type, and color of table borders (Fig. 9).

Rice. 9. Group teams Draw borders

Tab Layout contains commands for editing the table structure; it contains the following commands:

- Table. Contains commands for selecting rows and columns in the table, displaying the grid and table properties (Fig. 10).

Rice. 10. Group teams Table

- Columns and rows. This group of commands includes commands that are designed to delete/add rows and columns, and delete a table (Fig. 11).

Rice. 11. Group teams Columns and Rows

- Merge. This group of commands includes commands for splitting and merging cells in a table (Fig. 12).

Rice. 12. Group teams Merge

- Cell size. This group of commands includes commands that allow you to change both the height and width of the cell (Fig. 13).

Rice. 13 Teams of the group Cell size

- Alignment. This group of commands includes commands for interaction between text and cells (Fig. 14).

Rice. 14. Group teams Alignment

- Data. This group of commands includes commands for sorting fields in a table and inserting formulas (Fig. 15).

Rice. 15. Group teams Data

The table is split into parts when moving to a new page automatically. Using the command Split table groups Merge you can force a row-by-row table split, the cursor must be in the insertion line of the break. To connect different parts of a table, you remove the text between the parts of the table and the end of paragraph marker. Moreover, if the rows of the table were numbered, the numbering starts over at the break point; When connecting different parts of the table, sequential numbering is restored by clicking on the yellow lightning bolt icon that appears next to the number.

Selecting table fragments

To perform any action on a group of cells, you must first select them. In this case, the background of all cells except the first one will be painted black. But the unshaded cell will also be highlighted.

• · To select one row, place the mouse pointer on the row number on the coordinate column. To select several rows, move along the coordinate column without releasing the left key.
• · To select one column, place the mouse pointer on a letter on the coordinate line. To select several columns, move along the coordinate line without releasing the left key.
• · To select several cells, move around the table while pressing the left key.
• · The selection can be removed by clicking anywhere on the screen.

Resizing Cells

In real tables, as a rule, all columns have different widths. There are several ways to change cell sizes.

If you need to resize several cells at once, you must first select them.

• 1. Place the mouse pointer on the coordinate line or column (they are highlighted in gray and located at the top and left); Without releasing the left mouse button, move the cell border in the desired direction. The mouse cursor will change its appearance.
• 2. Team Format - String - Height and team Format - Column - Width allow you to determine the cell dimensions very accurately. If dimensions are determined in points, then 1pt = 0.33255 mm.
• 3. Double-clicking the cell border will determine the optimal size of the cell based on its contents.

Formatting cell contents

Team Format - Cell is designed to perform basic operations with cells. The action will be performed on the active cell or on a group of selected cells. The command contains the following submodes:

Number - allows you to explicitly define the data type in a cell and the form of representation of this type. For example, for a number or currency format, you can specify the number of decimal places.

Alignment - determines the way data is located relative to the cell boundaries. If the mode is enabled "translate according to words", then the text in the cell is split into several lines. The mode allows you to position text in a cell vertically or even at a selected angle.

Font - defines the font parameters in the cell (name, size, writing style).

Gganitsa - frames the selected cells, and you can determine the thickness of the line, its color and location.

View - paints the background of cells using a selected color or pattern.

Protection - protection for changes is established.

The command is applied to the selected or currently active cell.

Exercise 2.1

• 1. Enter text 1 - 3 in any cell and press the key Format - Cell to define a "Text" type in a cell, this will allow you to enter any set of characters into the cell.
• 2. Select any three cells. Frame the cells in blue with a dotted line. Color the background of the cell yellow.
• 3. Enter any word into the cell. Mode Format - Cell - Border position the text at a 45 degree angle.

Rice. 3. Command window view Format - Cell

Practice 2

Create a table like the following on the first worksheet.

Table 2.

When creating a table, apply the following settings:

• · the main text of the table is in Courier font, size 12;
• · the text is centered relative to the cell boundaries;
• To make the text occupy several lines in a cell, use the mode Format - Cell - Alignment ;
• · Frame the table in blue, for this use the mode Format - Cell - Border .

Save the finished table in the Users folder in a file fossils.xls .

Changing the table structure

Main menu command Insert allows you to add rows, columns, or cells to a table. In this case, the required number of rows, columns or cells must be selected. Keep in mind that new rows will be added above the selected rows, and new columns will be added to the left of the selected columns. When adding cells, a dialog box will appear in which you need to determine what to do with existing cells.

Exercise 2.2

• 1. Add two empty rows above the created table.
• 2. Add a new column between the first and second columns.

Table title

To center the header relative to the table borders, there is a special icon called “Merge and Center.” A group of cells above the table is first selected; when you click on this icon, they are combined into one and the text typed in it is centered.

Exercise 2.3

Above the created table, type the heading “Minerals” in size 14, in bold italics.

In Microsoft Office Word 2007, you can format a table after you create it in several ways. Using table styles allows you to set the format for the entire table at once, and you can also preview it to see in advance what the table will look like with the selected formatting style.

Tables can be modified by splitting or merging cells, adding and removing columns and rows, and drawing. When working with large tables, you can set the table header to appear on each of the pages on which it appears. To prevent unexpected breaks in the data flow in a table, you can specify where page breaks should appear.

In this article

Use table styles to format an entire table

After you create a table, you can format it using table styles. By hovering your mouse over one of the predefined table styles, you can preview what the finished table will look like.

Adding or removing frames

You can add or remove borders to give your table the look you want.

Adding borders to a table

In chapter Working with tables open the tab Layout.

In Group Table click the button Select and select a team Select table.

In chapter Working with tables open the tab Constructor.

In Group Table styles click the button Borders And

• Select one of the built-in border sets.

  In Group Borders and Shading click the button Borders and select the desired option.

Removing borders from an entire table

In chapter Working with tables open the tab Layout.

In Group Table click the button Select and select a team Select table.

In chapter Working with tables open the tab Constructor.

In Group Styles click the button Borders and select an option without border.

Add borders to individual cells

Remove borders in specific cells

Show or hide grid lines

Gridlines represent the boundaries between cells in a table that has no borders. If you hide the grid in a table with borders set, the changes will not be noticeable because the grid lines follow the border lines. To see the grid lines, you must remove the boundaries.

Unlike borders, gridlines appear only on the screen and do not appear when the table is printed. If you turn off the grid, the table will appear as it would be printed.

Note: Gridlines are not displayed in the web browser or in preview mode.

Show or hide table gridlines in a document

In chapter Working with tables on the tab Layout in Group Table click the button Show grid.

Add a cell, row, or column

Inserting a cell

Click the cell to the right or above where you want to insert the new cell.

In chapter Working with tables open the tab Layout and click the dialog box button Rows and Columns.

Select one of the following options:

Adding a line

Click the cell in the row above or below which you want to add a new row.

In chapter Working with tables open the tab Layout.

Do one of the following:

• To add a row above the selected cell, in the group rows and columns click the button Paste above.

  To add a row below the selected cell, in the group rows and columns click the button Paste below.

Adding a Column

Click a cell in the column to the right or left of where you want to insert the column.

In chapter Working with tables open the tab Layout.

Do one of the following:

• To add a column to the left of the selected cell, in the group rows and columns click the button Insert Left.

  To add a column to the right of the selected cell, in the group rows and columns click the button Paste on the right.

Delete a cell, row, or column

Merging and splitting cells

Merging cells

Two or more cells in the same row or column can be merged into one. For example, you can combine multiple cells in one row to create a table header that is shared across multiple columns.

To select the cells that you want to merge, click the left border of one of them and drag the pointer, while holding down the mouse button, across the desired cells.

In Group Working with tables on the tab Layout in Group Merger select team Merge cells.

Splitting cells

Select one or more cells that you want to split.

In Group Working with tables on the tab Layout in Group Merger select team Split cells.

Enter the number of columns and rows into which you want to split the selected cells.

Repeat table title on subsequent pages

When working with very long tables, you have to break them into parts at page breaks. In this case, you can configure the table so that the table title is repeated on each page.

Repeating table headings appear only in markup mode and in the printed document.

Select the line(s) that make up the title. The selection must include the first row of the table.

In chapter Working with tables on the tab Layout in Group Data select team Repeat header lines.

Note: In Microsoft Word, table headings are repeated at automatic page breaks. If a page break is manually inserted into a table, the header is not repeated.

Managing table splitting

When working with very long tables, you have to break them into parts at page breaks. If the page break happens to be on a long line, part of that line wraps to the next page by default.

To present the data contained in a table that spans several pages, make appropriate changes to the table.

Print an entire table row on one page

Click anywhere in the table.

In chapter Working with tables open the tab Layout.

In Group Table click the button Properties and open the tab Line.

Uncheck Allow lines to wrap to next page.

Specifying where to force a table break into pages

Highlight the line that should be printed on the next page.

Press CTRL+ENTER.

TABLE PROCESSOR EXCEL. TABLE FORMATTING TOOLS. USER FORMATS.

CONDITIONAL FORMATTING Formatting a Worksheet

• - this is the design of tabular data located on a worksheet in order to increase their visibility and improve visual perception. Formatting a worksheet comes down to formatting its cells, i.e., determining the formatting parameters for the worksheet cells.
• The following formatting options are available:
• data format;
• font format.
• A font is a typeface, a design of numbers and symbols;
• aligning cell contents;
• cell framing.

A border is a line that outlines a cell or highlights one of its sides;

palette. A palette is a set of colors used for decoration;tions in accordance with the number format General. Values ​​are displayed as they were entered using the keyboard. In this case, Excel analyzes the values ​​and automatically assigns them the desired format, for example, 100 is the number 100, and 10:52 is a numeric date and time format.

The choice of data format is carried out on the Number tab of the dialog box of the Cells command of the Format menu.

The Number Formats list box contains categories of formats.

To format fractions and numbers with a decimal point, the formats use the following wildcard characters:

# - the symbol indicates that only significant digits are displayed in this position, insignificant zeros are not displayed. For example, ###,# 123.46 => 123.5; 0.12=>.1;

0 (zero) - the symbol indicates the display of non-significant zeros. For example, #.00 1.2=>1.20;

1=>1.00;

When this character is used before or after the decimal point, spaces are displayed instead of leading zeros. For example, ???,??? 1.2 => 1.2;

(space) - the symbol indicates the need to insert a space as a separator for groups of digits of a number. For example, # ### 10000=>10,000;The symbol determines the position of the decimal point.

The number of pattern characters in the format determines the rules for rounding the number during output. If the fractional part of a number contains more digits; than pattern characters in the format, the number is rounded so that the number of digits corresponds to the number of characters in

template.<1000]0;[синий][>If the integer part of a number contains more digits than the number of characters in the pattern, then all significant digits are displayed. If the integer part of a number format contains only # characters and the number is less than 1, then the number begins with a decimal point.

In a numeric format, you can specify a color representation of values. In this case, the first element in the template should be the color code. For example, [blue]# ##0.00;[red]-# ##0.00.==> all positive values ​​will be displayed in blue, all negative values ​​in red.

In a number format, you can specify a format that is used only for numbers that meet a specified condition. The condition must consist of a comparison operator and a value, enclosed in square brackets. For example, [red][

M - to display the month: M - 1-12; MM - 01-1 12; MMM - Jan - Dec; MMMM - January - December;

MMMMM is the first letter of the month.

G - to display years: YY - 00-99; YYYY - 1900-9999.

H - to display the hours: h - 0-23; hh - 00-23.

M - to display minutes: m - 0-59; mm - 00-59. ,

C - to display seconds: s - 0-59; cc - 00-59.

0 (zero) - to display fractions of seconds: h:mm:ss.00.

AM/RM - to display the twelve-hour system.

To display time intervals. Allows you to display values ​​greater than 24 hours, 60 minutes, or 60 seconds.

• Formats can be composite, that is, have a numeric and text part. The text part is always the last in the format. Pattern symbols:
• "" \ - double quotes or backslashes indicate the need to insert, starting at the pattern position, the text characters that follow it in the format. For example, 0.00 rub. “Surplus”;[red]-0.00 rub.
• "Flaws";
• @ - indicates that starting from this format position any characters (text) can be output;

* - indicates that, starting from the character position in the format, it is necessary to repeatedly print the character following the * (until the column is filled in width); _ - underscore character, used to align cell contents; Instead, a space is inserted, the width of which is equal to the character following it.

Custom number, date and time formats

. If none of the output formats from the standard set suit the user, he can create his own custom format, save it and apply it. A custom number format is created by describing it using pattern symbols to display data: number, date, time, text. The custom format can consist of four parts (sections), which are separated by the “ ; "

Polar number format;negative number format;zero format;textYou can specify an empty section if there is no format for this type of value. To do this, immediately enter the sign “;”.Conditional formatting is formatting youdivided cells based on conditions specified by numbers andformulas.

Designed to highlight data. If

<что сравниваем>these cells satisfy the specified conditions, then to<с чем сравниваем>

The What to compare parameter can be specified by the value of the selected cell, the formula of the selected cell (the formula must begin with the “=” symbol, the result of the formula must be the logical value TRUE or FALSE).

The What we compare to parameter can be specified by a constant or a formula. The formula should start with"=" symbol and can contain absolute and relative references.

Comparison operations, in addition to all known operations, also contain the Between operation - to specify the range of values ​​within which the value of the What to compare parameter may fall, and the Outside operation to indicate the interval outside which the value of the What to compare parameter may lie.

In Excel, you can search for cells that have a conditional format. To do this you should:

1. Select any cell or cell that has a conditional format;
2. execute the command Go to the Edit menu;
3. select the Select button;
4. in the Select a group of cells dialog box, select and select the Conditional formats radio button;
5. to select all sheet cells for which conditional formats are specified, select the All radio button;
6. To select sheet cells with the same conditional formats as the active cell, select the Same radio button.