home › Installation and configuration › How to remove the end of a cell in Word. Invisible formatting marks in Microsoft Word. Inserting, deleting, or replacing cell contents

How to remove the end of a cell in Word. Invisible formatting marks in Microsoft Word. Inserting, deleting, or replacing cell contents

One of the basic rules for correctly creating documents in Word is spelling. Don't take this the wrong way, as this has nothing to do with grammar or writing style.

If you want Word to align text nicely and maintain proper spacing between paragraphs, then you must make sure that you do not put extra spaces between words and in cells, that paragraphs start correctly and indents are adjusted so that the document appears correctly formatted.

It would be very difficult to identify specific spaces or places in a document where random double tap TAB instead of one if there were no formatting marks. These characters are non-printing characters and show us where the SPACE, TAB, ENTER keys were used, or where hidden text is located.

Without them, it would be almost impossible to create a properly formatted document: it would take a very long time to correct errors that prevent text and objects from aligning correctly.

Typically, formatting marks are hidden until you make them visible by pressing ¶ on the " tab home» in Word (Fig. 1).

Rice. 1

Additionally, you can use keyboard shortcuts Ctrl + * or Ctrl + Shift + 8 to toggle “Show\Hide” formatting symbols. Switching the display of formatting characters has two positions:

ON – turns on displays all formatting characters.

OFF – disables display formatting characters behind except those that you decide to leave visible until you change the settings. Where can you choose which formatting symbols should remain visible/hidden after pressing the ¶ button?

Click the "File» , and then click "Options"(Fig. 2).

Fig.2

Click " Screen"and withleft, under " Always show these formatting marks»select which formatting marks you want to make visible always, even after disabling (Fig. 3).

Rice. 3

There are various formatting marks, or sometimes called non-printing characters, in Word. Let's look at the main ones.

Space character

Dots are formatting marks for spaces between words. One press on the spacebar – one dot (Fig. 4).

Rice. 4

Paragraph symbol

The symbol (¶) represents the end of a paragraph. After this character, Word begins new paragraph and moves the cursor to a new line (Fig. 5).

Rice. 5

A paragraph mark is placed in the document when a key is pressed Enter on your keyboard. Text between these two characters is defined as a paragraph and has a number of properties that can be adjusted independently of the rest of the text (or paragraphs), such as alignment (left and right, centered, and justified), spacing before and after paragraphs, and line spacing , numbering, etc.

Tab character

Pressing tab (TAB) is indicated by an arrow pointing to the right (Figure 6):

Rice. 6

Line translation

A line feed or represents a place where a line breaks and the text continues on a new line. You can insert a newline by pressing Shift+Enter.

The function of the line feed is much the same as the paragraph sign and has a similar effect, except that new paragraphs are not defined when a line feed occurs (Figure 7).

Rice. 7

Hidden text

Hidden text is a dotted line underneath text that is designated as hidden (Figure 8).

Rice. 8

When you turn off formatting marks, the above text will look like this (Fig. 9):

Rice. 9

Hidden text is not printed. BUT! How to hide text? It's very simple ;)

Select the text you want to hide

Right-click on the selected text and click Font (Fig. 10)

Rice. 10

Press " Hidden"(Fig. 11)

Rice. eleven

Why do we need to hide the text? Primarily for customizing a document or text template to meet specific requirements. You can also hide text if you don't want to print it in this moment, but don't want to delete it.

Let's return to formatting marks.

Anchor

An anchor represents a place in text where some objects in the document have been changed and the anchor object has an effect on behavior of this object in the text. In other words, the anchor object, like a hook or ring, is on back side paintings that are used to hang a picture on the wall.

The anchor is a small icon in the form of a ship's anchor (Fig. 12).

Rice. 12

It has been established that in cells this sign means the end of the last paragraph in the cell or at its end. It reflects the formatting of the cell (Fig. 13).

Compliance with spelling standards is one of the key rules when working with text documents. It's not just about grammar or writing style, but also about proper formatting of the text as a whole. Hidden formatting marks or, more simply, invisible characters will help you check whether you have placed the spacing between paragraphs correctly and whether you have added extra spaces or tabs in MS Word.

In fact, it is not always possible to determine the first time where in the document an accidental repeated keystroke was used "TAB" or pressing the spacebar twice instead of once. It is precisely non-printable characters (hidden formatting marks) that allow you to identify “problem” places in the text. These characters are not printed or displayed in your document by default, but enabling them and customizing display options is easy.

To enable hidden formatting marks in the text, you only need to press one button. It's called "Show all characters", and is located in the tab "Home" in the tools group "Paragraph".

You can enable this mode not only with the mouse, but also with the help of keys "CTRL+*" on keyboard. To turn off the display of invisible characters, simply press the same key combination or button on the panel again quick access.

Setting the display of hidden characters

By default, when this mode is active, all hidden formatting marks are displayed. If you disable it, all those symbols that are marked in the settings of the program itself will be hidden. At the same time, you can make some of the signs always visible. Hidden symbols are configured in the Options section.

1. Open the tab on the Quick Access Toolbar "File" and then go to the section "Options".

2. Select an item "Screen" and check the necessary boxes in the section "Always show these formatting marks on screen".

Note: Formatting marks that have a check mark next to them will always be visible, even when the mode is disabled "Show all characters".

Hidden formatting marks

In the MS Word options section discussed above, you could see what invisible characters there are. Let's take a closer look at each of them.

Tab characters

This non-printing character allows you to see the location in the document where the key was pressed. "TAB". It is displayed as a small arrow pointing to the right. For more details, see the tabulation in text editor from Microsoft you can in our article.

Space character

Spaces are also non-printable characters. When enabled "Show all characters" they look like miniature dots located between words. One dot - one space, therefore, if there are more dots, an error was made during typing - the space bar was pressed twice, or even more times.

In addition to a regular space, you can also use a non-breaking space in Word, which can be useful in many situations. This hidden sign looks like a miniature circle located at the top of the line. More details about what this sign is, and why it might be needed at all, are written in our article.

Paragraph mark

The “pi” symbol, which, by the way, is depicted on the button "Show all characters", represents the end of a paragraph. This is the location in the document where the key was pressed "ENTER". Immediately after this hidden character, a new paragraph begins, the cursor pointer is placed at the beginning of the new line.

The fragment of text located between two pi signs is a paragraph. The properties of this piece of text can be adjusted independently of the properties of the rest of the text in the document or other paragraphs. Such properties include alignment, spacing between lines and paragraphs, numbering, as well as a number of other parameters.

Line translation

The newline character appears as a curved arrow, just like the one on the key "ENTER" on keyboard. This symbol indicates the place in the document where a line breaks and the text continues on a new (next) one. Forced line feed can be added using keys "SHIFT+ENTER".

The properties of the line feed mark are similar to those of the paragraph mark. the only difference is that when new lines are translated, new paragraphs are not defined.

Hidden text

You can hide text in Word; we previously wrote about this. In mode "Show all characters" Hidden text is indicated by a dotted line located under this very text.

If you turn off the display of hidden characters, the hidden text itself, and along with it the indicating dotted line, will also disappear.

Snap objects

The object anchor symbol, or anchor as it is called, indicates a location in a document where a shape or graphic object has been added and then modified. Unlike all other hidden formatting marks, it is shown in the document by default.

End of cell

This symbol can be seen in tables. When in a cell, it marks the end of the last paragraph within the text. Also, this symbol denotes the actual end of the cell if it is empty.

That's all, now you know exactly what hidden formatting marks (invisible characters) are and why they are needed in Word.

You can change the contents of a cell directly in the cell. You can also change the contents of a cell by entering text in the Formula Bar box.

When editing content Excel cells works in edit mode. Some Excel functions work differently or are not available in edit mode.

When Excel is in edit mode, in the lower left corner of the window Excel programs appears Edit Word as shown in the image below.

How does Excel work differently in Edit mode?

In edit mode, many commands are not available. For example, when Excel is in edit mode, you cannot apply conditional formatting or change the alignment of cell contents.

Also, if Excel is in edit mode, the arrow keys work differently. Instead of moving the cursor between cells in Edit mode, the arrow keys move the cursor into the cell.

Turning Edit Mode On or Off

If nothing happens when you try to use Edit mode, it may be disabled. You can turn edit mode on or off by changing an Excel option.

Switching to edit mode

To get started in edit mode, do one of the following:

Double-click the cell containing the data you want to change.

Editing mode starts and the cursor is placed in the cell at the location you double-clicked. The contents of the cell are also displayed in the formula bar.

Click the cell that contains the data you want to change, and then click anywhere in the formula bar.

Editing mode will start and the cursor will be placed in the formula bar at the selected location.

Click the cell that contains the data you want to change, and then press F2.

Editing mode will start and the cursor will be placed at the end of the cell contents.

Inserting, deleting, or replacing cell contents

To insert characters, click the cell where you want to insert, and then enter the new characters.

To delete characters, click the cell you want to delete and then press the BACKSPACE key, or select the characters and then press the DELETE key.

To replace specific characters, select them and enter new characters.

To enable replace mode, so that existing characters are replaced with new ones as you type, press the INSERT key.

Note: Replace mode can only be turned on or off in edit mode. When Replace mode is enabled, the character to the right of the insertion point is highlighted in the formula bar, and it will be overwritten as you type.

To start a new line of text at a specific point in a cell, click where you want to break the line, and then press Alt+Enter.