Type and move around a Word document. Moving and copying cells, rows and columns How to move a line down in a word document

Instruction

Most text entry and editing programs use the Enter key to move to the next line. If you need to go one term down, press the specified key once, if two (three, ten) - keep pressing the key until you go down to the desired line.

Line number in Microsoft Editor Office Word can be seen in the status bar, which is located below the work area. Right click on it and select context menu item "Line number" with the left mouse button to track the statistics of the document.

A regular line break does not always mark the beginning of a new paragraph, since a paragraph is usually indented. To mark a paragraph, press the Space key several times, or type desired parameters in settings. To do this, select desired fragment text and right-click on it.

In the context menu, select the "Paragraph" item - a new dialog box will open. Go to the "Indents and Spacing" tab in it and set the "Indent" value in the "First Line" field in the "Indent" group. If necessary, set your own indent width and click the OK button. The dialog box will close automatically and the settings will be applied to the selected text fragment.

To move to a new line in other applications, sometimes you need to use a keyboard shortcut. The Enter key remains the main key; the Ctrl, Shift or Alt keys can be used as an additional one. So, for example, a simple single press of the Enter key in an application Microsoft Office Excel will cause the cursor to move to the next cell. To continue entering text from a new line in the same cell, use the combination of Alt and Enter.

In ICQ and QIP applications, everything depends on the selected settings. Sending a message can be done with the Enter key, then to go to a new line, use the combination of Ctrl and Enter. If, on the contrary, sending text is displayed on the designated keys, then the transition to a new line will be carried out by pressing the Enter key once.

How to move a row in Excel?

To move a row in Excel, you can move the mouse cursor to the border of the selection marker until small arrows appear in four different directions, press the left mouse button and hold it to move the row up or down. In this case, the contents of the end cells will be replaced. Such a movement can only be carried out within the active sheet.

In the general case, to move a line, you need to cut it and paste it in the right place. For this you need:

1) select the line to be moved (move the mouse cursor to the line number and click on it with the left button);

2) cut the selected line with any convenient way(via main menu, via context menu, hot keys Ctrl+X)

3) on the desired sheet, select a line, or the leftmost cell of the line into which the insertion will be made;

4) insert the cut out cells.

It should be noted here that in the context menu (by pressing the right mouse button) two items related to pasting are available - "Paste" and "Paste cut cells".

When you select the first of these items, the cut line will be placed on top of the line selected for insertion, and when you select the second item, the line will be placed between the lines, that is, without losing any data.

If several lines that are not adjacent to each other are selected, then the border of the selection marker disappears and such a set of lines cannot be moved. Also, if you try to cut multiple non-contiguous lines at the same time, the application displays the message "This command not applicable for disconnected ranges. Select one range and select the command again."

A similar message appears when trying cut a group of cells at the same time not included in the same range.

After receiving such a message, it remains either to drag lines one at a time, or look for other tools.

How to quickly move rows to a new Excel sheet?

One such tool is an Excel add-in based on Visual Basic for application.

When using the add-in, monotonous manual labor is replaced by software data processing. Searching for the desired rows, checking for compliance with the given conditions, and moving the rows to new leaf Computer technology itself is already involved, which is faster and more convenient.

With this add-on you will be able to:

1. With one click of the mouse, call the macro dialog box directly from the Excel toolbar;

2. Set the search value;

3. Set multiple search values through a delimiter character ";" semicolon;

4. Consider or ignore the case when searching for given values;

5. Select a range of cells to search for given values;

6. Choose one of eight conditions for the selected cells:

a) matches the desired value;

b) does not match the desired value;

c) contains the desired value;

d) does not contain the desired value;

e) starts with the desired value;

f) does not start with the desired value;

g) ends with the desired value;

h) does not end with the desired value.

7. Set additional restrictions for the selected range.

Did you know that all sheets of a workbook can bequickly turn into separate files?

In addition, you can

Word has powerful document formatting features. After the text is entered into the document, it can be supplemented, changed, deleted, copied.

Typing

Text can be entered in any open document word.

Let's do the following:

Open Word. Usually, when you open the program, an empty document is automatically created. If your Word is configured differently, then create new document by selecting the command "File" - "Create ...".

Type this text:

Speed skating brings great benefits: it improves the activity of the lungs and heart, increases metabolism, strengthens muscles, especially the legs and torso.

As you type, Word moves the cursor from the end of one line to the beginning of the next, and wraps words to a new line if they don't fit on the current line. If you made a typo, fill in the erroneously entered character with the backspace key (the rightmost one in the number row with the image of an arrow), and enter the correct one.

Press the Enter key. Word will complete the paragraph and move the cursor one line down.

Enter the second paragraph:

In addition to the development of general endurance, static endurance of the back muscles is brought up during speed skating. This is necessary for the painter, and the turner, and the field grower.

As a result, we have typed two paragraphs of text, which will be useful to us in the future to develop text editing skills.

Insert text

A blinking cursor in the document area indicates where the typed text will be displayed. Using the mouse, the cursor can be placed anywhere in the document.

Line break at random

Word breaks lines within a paragraph by inserting "soft" characters on the right side of each line. When you change the format or edit the text, "soft translations" of the lines change according to the nature of the text, which prevents incorrect line breaks.

Sometimes it becomes necessary to break a line without starting a new paragraph. To do this, press the key combination Shift + Enter. At the same time, Word inserts a "hard translation" character into the text of the document and ends the current line, regardless of whether the right margin is reached or not. "Hard translation" does not create a new paragraph. The Ctrl+Enter combination makes a page break.

Insert and replace modes

By default, typing in Word is done in insert mode, in which text entered in the middle of a line shifts the characters to the right of it. However, it is possible to type in replacement mode, where the characters you enter replace the text you typed earlier rather than shifting it to the right. This mode is enabled/disabled by pressing the Insert key on the keyboard. Find out which mode is on this moment can be in the status bar of Word.

scrolling

The scrollbars in the document window are one way to move around the document so that the author can view different parts of his creation.

Each scroll bar has a slider and arrow buttons at both ends of the bar.

to move in small increments, click on the scroll buttons located at the ends of each of the scroll bars. For fast scrolling, you can press and hold the button;
to scroll the document screen by screen, click on any section of the scroll bar above or below the slider;
to move smoothly through the document, drag the scroll bar slider up or down. As you drag the slider, a tooltip is displayed next to it showing the current page number.

Depending on how far you want to jump, the mouse can be used in three ways:

Note that the position of the cursor does not change when scrolling. Before you start typing after scrolling, you must click the mouse at the intended insertion point. If this is not done, Word will automatically scroll to the area of the document where the cursor is located.

Navigation buttons at the bottom vertical stripe scrollbars allow you to jump to specific sections of the document. The main difference from scrollbars is the fact that when using the navigation buttons, the cursor is moved.

By default, the navigation buttons navigate to the previous or next page document. The "Select Object" button located in the middle serves to change this option. Clicking this button displays the Transition Objects Palette, allowing you to specify which object to navigate to when you click the transition buttons. There are 12 options in total:

page navigation;
transition through sections;
navigation through notes;
transition through footnotes;
following endnotes;
transition through the fields;
navigation through tables;
transition according to the schedule;
heading navigation;
transition through corrections;
transition with an explicit indication of the object;
search.

When you move the mouse pointer over each of the buttons in the Transition Objects Palette, a description of the corresponding object is displayed at the bottom of the palette. When the button is clicked, the corresponding object is selected as the transition object. When you select any object other than the page, the buttons are colored blue, indicating that a non-standard transition object was selected.

Navigating with the keyboard

If you use the keyboard to move around the document, the cursor moves along with scrolling. Below are the keyboard shortcuts that are used to move around the document.

Keys Jump "up" or "down" One line up or down "left" or "right" One character left or right Ctrl+"left" One word left Ctrl+"right" One word right Home, End Go to beginning/end of current line Ctrl +Home Go to beginning of text Ctrl+End Go to end of text PageUp, PageDown Screen up or down Ctrl+PageUp Move document page up Ctrl+PageDown Move document page down Shift+F5 Move to last edit

"Go" command

If you need to go to a specific place in the document, then using the "Go to" command can be done much faster.

Select the command "Edit" - "Go" (Ctrl+G or F5). The following window will appear.

Select the transition object type from the left list.

In the "Enter page number" field, you must enter the exact number of the page, note, or other item if you know the exact page number.

The buttons at the bottom right are used to move to the next/previous document object and to close the dialog box.

When you move or copy rows and columns, Excel moves or copies all the data they contain, including formulas and their result values, notes, cell formats, and hidden cells.

If the cell has a formula, the cell reference does not change. Thus, the contents of a moved or copied cell, and cells pointing to them, may display #REF! #VALUE! error value. In this case, you will have to set up the links manually. For more information, see Detect errors in formulas

You can use the command Cut or Copy to move or copy selected cells, rows and columns, but you can also move or copy them with the mouse.

To move or copy cells, do the following:

Moving and copying rows and columns with the mouse

Moving and copying cells

Note: Dragging or pasting cells to a new location will overwrite the original data in Excel.

Moving and copying rows and columns

Convert columns to rows and rows to columns

Table offset

Since we have allocated the first six lines of the worksheet as the input area, we need to move the table we created earlier down by this number of lines. We will describe different methods solution to this problem.

Adding Cells

The most time consuming method is to move the table area down and add cells to the top of the worksheet. It is implemented as follows:
1. Select cells A1:K6(range corresponding to the input area).
2. Click right button mouse and in the context menu activate the command Add Cells.
3. In the opened dialog box Adding Cells(fig. 3.9) select radio button cells, shifted down and press the button OK.

NOTE: This dialog box is also invoked via the command Insert/ Cells.

Inserting rows

The second way (less time consuming) is to add six lines on top:
1. Select lines 1-6 with the mouse.
2. Press the right mouse button and select the command in the context menu Add Cells.

Rice. 3.9. Add Cells Dialog Box

Table dragging

The third, easiest way is to select the entire table and drag it down. This operation can be compared to cutting a range of cells and pasting it to a new location. Select the range of cells where the table is located. Move the cursor to the end of the range and when the cursor changes to an arrow, drag the table down while holding down the left mouse button.