Word - what kind of program is it? Basic and undocumented features. Quickly select a large piece of text. Inserting a new page

All text capabilities Microsoft editor it is not necessary to know and use. You can successfully complete work tasks by occasionally switching between the Home and Insert tabs. But you will work even more efficiently if you equip yourself with even a few tricks from this review.

Here is a simple example familiar to webmasters. Some experts, before transferring text from Word document in the CMS editor, copy the content into Notepad. This clears the text from Word formatting, which may conflict with the template formats of the engine. So, you don't need Notepad. To solve the problem, just select the text in Word and click the “Remove All Formatting” button.

Please note that the review was written for the 2013 version of Word. Current stable version The program is MS Word 2016, released in September 2015. However, this version of the program has not yet become the main one.

How to create and save a MS Word document

To create a document, open working folder. Right-click and select the "New - Microsoft Word Document".

To easily find a document, name it.

You can also launch MS Word from the Start menu. Pay attention to the illustration.

When launched through the start menu, you created new document with default name. Give it a name and save it in a folder of your choice so you don’t lose it. To do this, click on the “Save” icon or use the key combination Shift+F12.

Name the document and save it to the selected folder.

You have created and saved the document. Get to work.

How to use the Home tab features

Tools in the MS Word control panel are combined using thematic tabs. This type of interface is called a ribbon. By default, the main toolbox opens, highlighted in the Home tab.

Below are the tasks that you can perform using the tools on the Home tab.

Tool block "Clipboard"

You can copy, cut and paste content. To use the Cut and Copy options, select the desired piece of text.

Please note the insert options. You can keep the original formatting, merge the formats, or save the text without formatting. You can also use special modes inserts.

Why do you need a special insert? For example, imagine that you need to work with text copied from another document or website. The original formatting may not match the formatting in your document.

This problem is solved using special insert. Use the appropriate menu. In the window that opens, select the “Unformatted Text” option.

Now it will be more convenient for you to format the copied content.

Using the Clipboard menu, you can select previously copied content and paste it into a document. To open the clipboard, click on the arrow marked in the illustration. Select the desired item. Using the drop-down menu, select the "Insert" option. You can also delete the copied element from the clipboard.

You can customize the default paste options. To do this, use the “Insert – Default Insert” menu.

Specify the appropriate settings and save the changes. Pay attention to the options for pasting into another document. Most users can replace the default "Keep original formatting" with "Keep text only".

Font toolbox

To change the default font, use the drop-down menu marked in the illustration. Please note that in order to change existing text, the fragment must be selected before selecting the font.

Using the corresponding menu you can select suitable size font. Pay attention to the ability to increase or decrease the font of the selected fragment. Mark the text and use the buttons marked in the illustration.

You can select the appropriate register using the corresponding menu. Select the desired piece of text, use the button marked in the illustration and select the desired option.

You can highlight a piece of text with bold, italics, or underlining. To do this, select the content and use the marked buttons. Using the drop-down menu, you can choose how you want to underline your text.

To cross out a piece of text, select it and use the corresponding button.

Using the X 2 and X 2 buttons you can add subscript and superscript text.

Using the marked buttons, you can change the color, highlight the text with a marker, or apply effects to it.

Please note that advanced font options can be configured. To enter the menu, press the button marked in the illustration.

On the Font tab, specify suitable parameters body text and headings. Using the “Default” button you can return the default settings, and using the “ Text effects" choose additional effects.

Paragraph tool block

To create a bulleted, numbered, or multilevel list, use the drop-down menus shown in the illustration.

To create a bulleted or numbered list, place the cursor on new line and click on the corresponding button. Use the drop-down menu to select the appropriate marker symbol.

You can use additional characters using the Define New Marker menu.

To create a multi-level list, select the “Change List Level” option from the corresponding drop-down menu.

You can select the appropriate list style in the library. And the menu “Define a new multi-level list” and “Define a new style list" will help you create custom template list.

You can choose suitable way text alignment using the appropriate menu. To ensure text readability, use left alignment.

Change the line spacing if necessary. In most cases, the standard spacing of 1.15 will work for you. If you are preparing a document for children or older people, increase the spacing to 1.5 or 2.0. Further increase in spacing will reduce the readability of the text.

Using fill, you can highlight a piece of text with color. For example, you can select a paragraph or a table cell. To add a background, select a piece of text and choose a color from the Fill drop-down menu.

You can use the Borders menu to control the borders of cells in tables. Select the cells you are interested in. Use the drop-down menu to select the appropriate action.

Toolbox "Styles"

Use the Styles menu to select the appropriate text style. If you want to apply it to existing content, select the appropriate fragment and define a style. To use the style for created content, place the cursor on a blank line and select the appropriate design option. For example, you can use the appropriate style for headings.

Editing tool block

Using the Find menu, you can quickly search for content that interests you. Note the drop-down menu access to advanced search settings.

The Replace function is convenient to use when editing text. For example, you can automatically replace the word “copyright” with “copywriting” in the text. To do this, use the “Replace” menu, specify the desired words in the “Find” and “Replace with” fields.

Click the Replace All button. After processing the request, the program will report the number of replacements performed.

Use the Highlight feature to quickly highlight content. For example, you can select all text, select arbitrary objects, or select fragments with the same formatting in two clicks.

Using the Collapse Ribbon function, you can hide program management tools. Only tabs will remain on the panel.

To return the tools to the panel, expand any tab and use the “Pin the Ribbon” option.

How to use the Insert tab features

The Insert tab contains tools that you can use to insert various objects into a MS Word document.

Toolbox "Pages"

You can select a template from the Cover Page menu title page for the document.

Using the functions " Empty page" and "Page Break" options can create a blank page or move to a new page. For example, if you need to insert a blank page between paragraphs, place the cursor between them and use the Blank Page function.

Toolbox "Tables"

Using the Table drop-down menu, you can insert or draw a table in your document. This can be done in several ways.

To quickly add a table, use graphical tool. Select with the mouse cursor required amount cells in the table. After this, place the cursor on the selected area and click left button mice.

The Insert Table feature allows you to manually specify the number of rows and columns. You can also choose how you want to define the width of the columns.

The “Draw Table” function allows you to perform the corresponding action. Use it to create custom tables. For example, you can draw a table with different numbers cells in rows.

To define the properties of the drawn table, use the appropriate menu.

Using the menu " Excel tables"You can insert tables from MS Excel into a MS Word document. In the Express Tables menu you will find table templates.

Tool block "Illustrations"

Using the Pictures feature, you can insert an image into a document with hard drive computer. The “Images from the Internet” menu allows you to find suitable photos on the Internet.

Search results give priority to photos distributed under a Creative Commons license.

The Shapes feature helps you add a template shape to your document, such as a heart, star, or arrow. To use the tool, use the drop-down menu to open the catalog and select the appropriate shape.

Use your mouse cursor to determine the size and location of the shape in your document.

Decorate the shape using the Fill, Outline, and Effects functions.

SmartArt allows you to insert into your document graphic objects. Use the drop-down menu to select the type and appropriate pattern.

Place the cursor on the elements of the picture and add text.

Note the ability to change the color of SmartArt objects.

Using the Chart menu, you can add charts to your document. Please note that you can select the graph type.

Insert the required values ​​into the data table.

Using the Capture menu, you can take a snapshot of an area of ​​the screen and insert it into a document. To do this, use the drop-down menu to select the “Screen Clipping” option, and use the mouse cursor to select the area you want to capture.

Tool block "Add-ins"

In add-ons you will find a store Office applications. It contains paid and free tools for solving special problems. To select the appropriate application, click on the “Store” button and use the search. You can also browse tools by category.

For example, with the MailChimp for MS Word application, you can create Email campaigns right in the document. To use the application, click the “Trust” button. The tool's capabilities will become available after authorization.

The My Applications menu displays a list installed applications. You can remove unused ones and add new ones.

The Wikipedia function allows you to search for information on a corresponding resource directly from a MS Word document. You can also quickly insert images from Wikipedia into a document.

To use the tool, click the button marked in the illustration and highlight the word or term whose meaning you want to find. Internet access is required for the tool to operate.

To insert an image, click on the plus sign marked in the illustration.

You can also insert a text quote from Wikipedia into the document. To do this, select the desired fragment and click the plus sign.

Multimedia Tools

Using the Internet Video tool, you can insert relevant objects into your document. To use the feature, click the "Internet Video" button, search for the video using YouTube or Bing, select and paste the item.

The video can now be viewed in a MS Word document. To do this you will need access to the Internet.

You can watch videos in Word

Links feature

Using the Links drop-down menu, you can insert hyperlinks, bookmarks, and cross-references into your document. To insert a hyperlink, copy the web page URL to your clipboard. Then select a piece of text that will become the anchor of the link.

The Bookmark feature allows you to quickly jump to marked sections of text. To add a bookmark, select the desired piece of text, and in the “Links” drop-down menu, select the “Bookmarks” option. Give the bookmark a name and click Add.

To quickly jump to bookmarked content, select the Bookmark menu, select the bookmark you want, and click Go.

Note function

The Notes function is convenient to use when working with a group on a document. To add a note to the text, select a piece of text and click the marked button.

To edit, delete, or mark a note as ready, place the cursor on it and open the context menu using the right mouse button. Select the required option.

Header and Footer tool block

Using the tools in the "Header and Footer" group, you can add headers and footers, and also number the pages of the document.

To add page header, use the appropriate menu. Select a footer template.

Enter text. To save changes, close the Header and Footer window.

To remove or change a header, use the appropriate options in the Header menu.

You can work with the footer in a similar way.

Using the Page Number function, you can number the pages of a document. To do this, use the drop-down menu to select a location and numbering template.

Text tool block

Using the Text Box function, you can select a piece of text in a document. Use it if you need to create a sidebar, quote, or definition. To use the tool, use the drop-down menu to select a text field template.

Add text and save changes.

The View Quick Blocks feature allows you to insert autotext, document properties, or a field. For example, you can insert the date of publication, name, address and phone number of the organization and other data.

Using the Add WordArt menu, you can add visually appealing text to your document. To do this, use the menu marked in the illustration. Select the appropriate object and add text.

The “Add Drop Cap” feature allows you to design paragraphs using a prominent capital letter. Place the cursor at the beginning of the paragraph. Use the appropriate menu to select the location of the capital letter. Pay attention to the ability to change the parameters of the drop cap. You can choose the font, height and distance from the text.

Add a line to your document for digital signature. To do this, use the menu marked in the illustration. In the window that opens, specify necessary information and save the changes.

The Date and Time function will help you add the current date and time to your document. Click on the appropriate button, select the date display format and click OK.

The Object function allows you to insert objects or text from a file into a document. To paste text from a file, select the appropriate option from the drop-down menu. Find the file on your hard drive whose text you want to insert into the document and click “Insert.”

Toolbox "Symbols"

The “Equation” function will help you insert into a document mathematical formula. Use the drop-down menu to select a standard formula or go to the designer. Add the required values ​​and save the changes.

Using the Symbol menu, you can insert symbols that are not available on your keyboard into your document. Please note the option to insert additional characters from the dialog box.

How to use the Design tab features

Using the tools in the Design tab, you can change the design of your document. If you want to change standard settings, start by choosing a topic.

To undo changes, use the "Restore Template Theme" option or select the "Standard" theme.

In the styles menu, select the style that suits you.

The Colors feature allows you to manually adjust the font color of body text, headings, and hyperlinks. You can choose standard set colors or specify colors for different style elements yourself.

Using the Fonts menu, you can quickly customize the font for headings and body text. You can choose standard pairs or specify the font manually.

You can use the Paragraph Spacing menu to change the related settings. It is possible to delete an interval, select standard ones or set your own values.

Using the Effects menu, you can select additional design effects. The Default feature is useful if you want to apply design settings to new documents.

“Page Background” tool block

The Background feature allows you to select a standard or customize the background. To set the parameters manually, use the “Custom Underlay” option.

You can use the Page Color function to change the corresponding setting. Pay attention to the “Fill methods” option. With it, you can add texture, pattern, and design to your pages.

The Page Borders feature allows you to add borders to pages. Use templates or your own settings.

How to use the Page Layout tab features

Tab tools allow you to change the layout of document pages.

“Page Options” tool block

The "Margins" function allows you to choose standard or specify your own margin options. To set custom values, use the Custom Fields option.

The Orientation feature allows you to select portrait or landscape orientation document sheets. Using the "Size" menu, you can change the size of sheets. The default size is A4.

In the Columns menu, you can specify the number of columns per sheet. The Breaks and Line Numbers functions allow you to set page breaks and add line numbering accordingly. The “Hyphenation” menu allows you to enable hyphenation of words from line to line by syllable. By default this feature is disabled. Do not change this setting unless necessary.

Paragraph tool block

With the Indent feature, you can adjust the left or right margin of a paragraph. To use the function, place the cursor at the beginning of the selected paragraph and set the indent value.

You can use the Spacing feature to change the spacing between selected paragraphs. To do this, place the cursor in front of the selected paragraph and set the values.

Arrangement toolbox

The Position function allows you to set the position of an object in the text. To use the tool, select the selected image and use the drop-down menu.

The Text Wrap feature lets you choose how text wraps around an object. To test the tool, select the drawing and use the drop-down menu.

Using the “Selection Area” button, you can display a list of objects in the task area. Using the Align, Group, and Rotate functions, you can perform appropriate actions on selected objects.

How to use the Links tab

Tool block "Table of Contents"

The Add Text function allows you to add or remove the current heading from the table. The Update Table function allows you to include new sections in the table of contents.

Footnotes toolbox

Using the Insert Footnote menu, you can add a corresponding element. Select the fragment of text that the footnote refers to and click the button marked in the illustration.

The Insert Endnote feature allows you to add a footnote to the end of your document. Use the Next Footnote drop-down menu and the Show Footnotes feature to quickly navigate between footnotes.

Tool block “Links and references”

Using the Insert Link menu, you can link to a source of information, such as a book. Place the cursor next to the text fragments that the link refers to. Click the appropriate button, enter the required information in the window that opens and save the changes.

Using the "Manage Sources" function, you can edit the list, sort and delete sources.

The Style drop-down menu allows you to select a link style. Using the Bibliography function, you can insert relevant information into a document.

Tool block "Names"

The Insert Title feature lets you add a title or caption to images, tables, and formulas in your document. To use the tool, highlight desired object and press the button marked in the illustration. Add information and save changes.

Using the Illustration List feature, you can add relevant information to your document.

Tool block “Subject index”

The "Mark Item" function allows you to add objects to the index. To use the tool, select an object, such as a piece of text or a picture, use the appropriate menu and fill in the information.

Use the "Index" menu to customize the display subject index in the document.

Tool block “Link table”

How to use the features of the "Mailouts" tab

The tab tools will help you organize physical and electronic mailings.

Create tool block

The “Envelopes” function allows you to correctly add information to paper envelopes. To use the tool, click the marked button and add the required information. Now you can print the information on the envelope. Pay attention to the "Feed" field. This shows how to feed the envelope into the printer.

The “Stickers” function will help you correctly print information on stickers for parcels, envelopes, and CDs.

Tool blocks “Start Merge”, “Compose Document and Field List”, “View Results” and “Complete”

The Start Merge feature allows you to send a message to multiple recipients. For example, you can send a letter or electronic message. To do this, click the “Start Merge” button and select the “ Step by step wizard mergers." Follow the prompts in the task pane.

The Step-by-Step Merge Wizard combines tools from the Start Merge, Build Document and Field List, View Results, and Finish groups.

Use the Review tab to edit and evaluate the document.

Spelling tool block

Using the button marked in the illustration, you can start standard remedy MS Word to find errors and typos. Please note that the program does not “see” all errors, and sometimes offers corrections where there are no errors.

The "Determine" function will help you determine the meaning of unknown words. Please note that to use the tool, you must select a dictionary from the app store and install it. The Thesaurus menu allows you to find synonyms for selected words. The Statistics function shows the number of words, characters, paragraphs and lines in a document or its fragment.

Toolbox "Language"

The Translation menu allows you to automatically translate a selected word or phrase. Select the content you are interested in and use the button marked in the illustration.

The Language feature allows you to select your spelling language and configure language settings.

Note tool block

Using block tools, you can add, view, edit, and delete notes. Please note that notes can also be created from the Insert tab.

“Write corrections” and “Changes” tool blocks

You can use the Revisions feature to track changes made to a document. Pay attention to the "Scanning Area" menu. It allows you to choose how to display the list of changes: at the bottom or to the side of the document.

Tools in the Changes block allow you to accept or reject changes, and move to the previous or next revision.

The Compare feature allows you to compare versions of documents and combine revisions from multiple users. The “Block Authors” and “Limit Editing” functions protect your document from unwanted actions of other users.

How to use the View tab features

Tools on the View tab allow you to customize the display of your document.

Tool block “View modes”

Using the block tools, you can select the page viewing mode. For example, you can view the document structure.

“Show” tool block

Using group tools, you can enable the display of the ruler, grid, and navigation pane. Last function allows you to quickly jump to the desired section of the document.

The New Window function opens the current document in a new window. This is useful if you edit content and want to refer to the original. The Arrange All feature combines multiple documents into one window. The “Split” function is necessary to work with in different parts document.

With the Side by Side feature, you can place two documents next to each other in the same window. This is convenient when you need to compare content.

The Go to Another Window feature lets you quickly move to other open documents.

The Macros feature automates frequently performed tasks. To use the tool, you need to create a macro. For example, imagine that you often need to highlight portions of text in bold italics. To perform this action automatically, create a macro. Proceed like this:

  • Select a random piece of text. From the Macros drop-down menu, select the Record Macro option.

  • Choose how to run the macro: using a button on the toolbar or a keyboard shortcut.
  • Set the keyboard shortcut to activate the macro.

  • Click the Assign button and run the commands you want to include in the macro. To do this, go to the “Home” tab, select bold and italic.
  • Return to the Macros menu and stop recording.
  • Check if the macro works. To do this, select a piece of text and press the specified key combination.

Additional Tricks to Improve Your MS Word Efficiency

Below you will find a list of life hacks that you can use to quickly solve standard tasks when working with MS Word:

  • Use the context menu. It is called by right-clicking the mouse.

To select a paragraph, triple-click on any word with the left mouse button.

To insert placeholder text on a page, write the following characters: =lorem(2,2). Use the numbers in parentheses to determine the number of paragraphs and filler lines. If you replace "lorem" with "rand", random text will be used as a placeholder.

  • To quickly create a superscript or subscript, select the right word and press the key combination “Ctrl +” or “ Ctrl Shift+" accordingly.
  • To highlight a sentence, press Ctrl and place the cursor on any word.
  • Select the type of file to save. For example, you can save data to PDF format. To do this, select the "Save As" option and select desired type file.

  • To create horizontal line, type three consecutive hyphens and press Enter.
  • To print a dash, use the combination Alt keys + 0151.
  • To quickly move a piece of text, select it, press F2, place the cursor where you want to insert it, and press Enter.

Microsoft Word - application from the package Office programs, which is used to create and edit text documents.

Contents:

Definition

Microsoft Word– one of the most frequently used programs office suite. It has become widespread due to the fact that it has no analogues in functionality and convenience.

Can work not only with text itself, but also Notebook, but also with tables (although not on this high level, like Excel), formulas, media materials, images, charts and graphs (sometimes together with).

In standard package Microsoft Office programs included

Besides, full package Office programs weigh quite a lot and take up a lot of memory on the computer. At the same time, it so happens that Russian users do not use most of these programs at all, since there are more convenient and productive alternatives. And in fact, not everyone regularly uses Word. Thus, by downloading an official software package or even Word alone, the user receives mostly unused programs that take up a lot of space. For this reason, using them online versions may be more convenient.

Advantages of the online version

What are the benefits of using the online version?

She has several significant advantages Compared to the program for offline access:

However, this approach also has one obvious disadvantage.– availability only online and dependence on Internet speed, as well as connection stability.

Although the service quite often does automatic saves file, it is still possible to lose unsaved data if the connection is interrupted.

Usage

But to use it you will need an account in the system.

All users have such an account, since it must be created at the stage of downloading and initial authorization in the operating system.

Exceptions may be users of very old operating systems, for example, XP.

At the time of their release, it was not necessary to have an account in the system for authorization, so these users do not have an account.

In this case, it needs to be created additionally.

Work algorithm

Work with the online version of Word you can like this:

  • Follow the link provided above- you will get to home page service (by the way, at the top of it you will see a button for purchasing an installation version of programs for working offline);

  • Scroll down the page a little, and on the left side you will see tiles - buttons for accessing certain office programs in online mode;
  • Click on a tile the program you need;

  • After that you will be redirected to the login page– enter your phone number, login or address Email in the Microsoft system;
  • If you do not have an account, then click on the button Create an account and register;

  • After entering the data, click on the button Next;
  • Window in the center of the screen to change the content, it will require you to enter your password account – enter the same password you use to log in operating system on your computer;
  • Click Entrance;

  • If the system prompts – give confirmation that the credentials entered really belong to you;
  • You will be taken to a page where various layouts And templates for one purpose or another, as well as button to create a new document– select what you need and click on the tile;

  • The menu on the left shows your previously created documents, including those loaded from ;
  • Using the button on the right top corner you can immediately send the selected document;
  • After clicking on the desired tile, opens traditional text editor in exactly the same form as in the installed version;

  • After finishing working with it and setting up access go to the File tab and select Save as, then finish saving the file in the traditional way.

General access

One of the main distinctive features It is the online version that allows for joint editing and/or viewing of a document by several users who are logged in and have a link to the file.

It is the presence of this function that forces users to use the service even if they have it installed.

How to set up sharing and how to work with it?

  • Once you have completed creating the document, in the upper right corner of the screen, find the button General access and click on it;

Get the link . Here, choose what exactly you allow users to do with the document - view or make changes. Then click the Create link button and copy the text version of the link for editing and only viewing they will be different).

Working with Templates

The service offers quite a lot of templates, sometimes different from those available in installed version programs.

Working with them is quite simple, often just like with any other documents. To work with the template, do the following:

  • The selected template will open in which you can enter everything necessary changes;
  • Usually, changes can only be made to the text that is written in square brackets.

Templates can greatly facilitate and simplify the work with routine processes, such as scheduling, formal congratulations to colleagues and partners, etc.

Calculations and logical comparisons can be performed using formulas. Team Formula is in the section Working with tables on the tab Layout in Group Data.

In the application Word formulas are updated automatically when you open a document that contains them. Formula results can also be updated manually. additional information see section.

Note: Formulas contained in Word and Outlook tables are a type of field code. For more information about field codes, see the See Also section.

In this article

Inserting a formula into a table cell

    In chapter Working with tables on the tab Layout in Group Data click the button Formula.

    Using the dialog box Formula create a formula. You can enter a formula in the field Formula, select the number format in the field Number format, and also insert functions and bookmarks using lists Insert function And Insert bookmark.

Updating Calculation Results

In Word, the result of a formula is calculated when it is inserted and also when the document containing it is opened. In Outlook, the result of a formula is calculated only when you paste it, and the recipient of the message will not be able to change it.

In addition, it is supported manual update the following elements:

    results of individual formulas;

    results of all formulas in separate table;

    all field codes in the document, including formulas.

Updating individual formula results

    Select the formulas that need to be updated. To select multiple formulas, hold down the CTRL key.

    Do one of the following:

    • Click Formula right click mouse and select the command Update field.

      Press F9.

Update the results of all formulas in a table

    Select the table containing the results of the formulas you want to update and press F9.

Update all formulas in a document

Important: As a result of this procedure, not only the formulas will be updated, but all field codes in the document.

    Press CTRL+A.

    Press F9.

Examples: Adding numbers in a table using positional arguments

Positional arguments (LEFT, RIGHT, ABOVE, BELOW) can be used for the following functions:

As an example, consider the procedure for adding numbers using the SUM function and positional arguments.

Important: To avoid an error when finding a sum in a table using positional arguments, enter a zero (0) in the empty cells included in the calculation.

    Select the table cell in which the result should be located. If the cell is not empty, delete its contents.

    In chapter Working with tables on the tab Layout in Group Data click the button Formula.

    In the dialog box Formula Do one of the following:

    Click OK.

Available features

Note: Formulas that use positional arguments (such as LEFT) do not take into account the values ​​in the header row.

In the formulas located inside Word tables and Outlook, you can use the features listed below.

Action

Return value

Defines absolute value numbers in brackets

Determines whether all arguments inside parentheses are true.

AND(SUM(LEFT)<10;SUM(ABOVE)>=5)

1 if the sum of the values ​​to the left of the formula (in the same row) is less than 10 And the sum of the values ​​above the formula (in the same column, excluding header cells) is greater than or equal to 5; otherwise - 0.

Finds the arithmetic mean of the elements specified in parentheses.

The arithmetic mean of all values ​​to the right of the formula cell (in the same row).

Determines the number of elements specified in parentheses.

The number of values ​​to the left of the formula cell (in the same row).

Sets whether the argument is defined inside the parentheses. Returns 1 if the argument is defined and evaluates without errors, or 0 if the argument is not defined or returns an error.

DEFINED(gross_income)

1, if the element "gross_income" is defined and calculated without errors; otherwise - 0.

Has no arguments. Always returns 0.

Evaluates the first argument. If the first argument is true, returns the second argument; if false - third.

Note: All three arguments must be specified.

IF(SUM(LEFT)>=10;10;0)

10 if the sum of the values ​​to the left of the formula is greater than or equal to 10; otherwise - 0.

Rounds the value in parentheses to the nearest integer (smaller).

Returns highest value among the elements indicated in brackets.

The largest of the values ​​in the cells above the formula (excluding header row cells).

Returns the smallest value among the elements specified in parentheses.

The smallest of the values ​​found in the cells above the formula (excluding header row cells).

Has two arguments (numbers or expressions whose results are numbers). Returns the remainder when the first argument is divided by the second. If the remainder equal to zero(0), returns the value 0.0.

Has one argument. Determines the truth of the argument. If the argument is true, returns 0; if false - 1. Mainly used in the IF function.

Has two arguments. If at least one of them is true, returns 1. If both arguments are false, returns 0. Mainly used in IF function.

Calculates the product of the elements specified in parentheses.

The product of all the values ​​in the cells to the left of the formula.

Has two arguments (the first argument must be a number or an expression that results in a number, the second must be an integer or an expression that results in an integer). Rounds the first argument to the number of decimal places specified by the second argument. If the second argument is greater than zero (0), the first argument is rounded down to the specified number of decimal places. If the second argument is zero (0), the first argument is rounded down to the nearest integer. If the second argument is less than zero, the first argument is rounded to the left of the decimal point (down).

ROUND(123,456; 2)

ROUND(123,456; 0)

ROUND(123,456, -2)

Has one argument, which must be a number or an expression that results in a number. Compares the element specified in parentheses with zero (0). If this element is greater than zero, returns 1; if equal to zero - 0; if less than zero - -1.

Calculates the sum of the elements specified in parentheses.

The sum of the values ​​in the cells to the right of the formula.

Has one argument. Determines the truth of the argument. Returns 1 if the argument is true, 0 if false. Mainly used in the IF function.

Using bookmarks and cell references in a formula

You can insert a reference to a cell for which a bookmark has been created into a formula, using the name of the bookmark. For example, if a cell that contains a number or an expression that results in a number has a bookmark named gross income, formula =ROUND( gross income,0) will round the value of this cell down to the nearest whole number.

Note: Cells containing formulas are not included in calculations that use references. If the cell is part of a link, it is ignored.

RnCn format links

You can use the RnCn format to record a reference to a row, column, or table cell in a formula. Here Rn corresponds to the nth row, and Cn to the nth column. For example, reference R1C2 points to the cell in the first row and second column. The table below contains examples of writing links in this format.

A1 size links

You can use A1 format to record a reference to a cell, set, or range of cells. Here the letter corresponds to the column and the number to the row of the cell. The first column of the table is designated by the letter "A", and the first row by the number "1". The table below contains examples of writing links in this format.

Good day, dear readers!

I have been preparing this article for a long time and thinking about what might be useful to you in Everyday life. The thought came to mind that almost all of us work in Word, and I especially selected the most useful ones for you. Word functions. After reading this article, you will see how quickly and easily it is to work in Word.

I present to your attention a set of combinations that make working in Word easier.

1. If you need to insert a date into a document, just press Shift Alt D and a date in the format DD.MM.YY will immediately appear in the document. You can insert time in the same way, you just need to press Shift Alt T.

2. It happens that while working in Word, you accidentally press Caps Lock and type without looking at the screen in capital letters a long sentence or even a paragraph. And when you finally look up, you realize that you need to erase everything and write again normal font. But there is an easier way to solve this problem: select the text and press Shift F3, the case will automatically change from uppercase to lowercase.

3. If you move the cursor using the keyboard (arrow keys), then you can speed up the process if you simultaneously hold down Ctrl and the desired arrow.

4. Sometimes you need to highlight lines, paragraphs or other elements that do not follow each other. To select several elements at the same time, hold down Ctrl and select the elements you need.

5. Do you know about the advanced clipboard in Word? Oooh, what kind of abstruse words are these?! In fact, it is a memory device that is used when copying and pasting material. By clicking on the “Clipboard” button, you can see everything that you copied to the clipboard while working.

6. If you need to insert a screenshot of a window in Word, then click on the “Snapshot” button, and Word will show everything active windows. Click on any of them and get a screenshot of this window.

7. To reduce the volume of text and its readability, you can hyphenate words, but doing this manually is simply unrealistic when we're talking about let's say about a 30-page document. To help, there is a button in the “Page Layout” menu - “Hyphenation”; hyphens in Word will be placed automatically.

8. Do you want to protect your document from copying? Add a watermark to your document. Go to the “Design” menu and click on the “Background” section. Word has four standard template, but you can create your own.

9. To repeat the last command you worked with in Word, press F4. Perhaps you entered text, deleted several lines in succession, applied styles to different sections of text, or something else.

10. Do you want to put emphasis in Word? Where can I find this icon? You can place an emphasis in Word by placing the cursor after the letter on which you want to place the emphasis, and simultaneously hold down Alt 769. Important: numbers must be clicked on numeric keypad on right.

11. If you want to see the items you need on the toolbar and remove unnecessary ones, go to the menu “File” - “Options” - “Customize Ribbon”. So you can implement flexible setup elements, and even create your own tabs with functions.

12. To quickly select large text, place the cursor at its beginning and click with the mouse while holding Shift at the end of the desired fragment. This command is especially valuable when you need to select several sheets at once.

13. Fast travel according to the document
There are several combinations that greatly speed up document navigation:

Ctrl Alt Page Down - next page;
Ctrl Alt Page Up - previous page;
Ctrl Home - move to the top of the document;
Ctrl End - to the end of the text

14. Helps you speed up your work in Word Ctrl combination Enter, which instantly creates new leaf. No more holding Enter or clicking it 50 times.

15. By default, Word saves all files to the Documents folder. You can correct the situation if you go to the menu “File” - “Options” - “Save”. In the line "Location local files Default" select the folder you need. In the same menu, you can configure the default document format, autosave, and much more.

16. In order to return the text to its original formatting, you need to press the combination Ctrl keys Spacebar.

17. When working in Word, you can use it as a task manager. Right-click on the Features Ribbon at the top and select Customize Ribbon. In the right column, enable the only disabled tab “Developer”.

Go to the “Developer” tab that appears and find the “Checkbox” element, which shows a check mark (why not). Now, by clicking on the checkbox, you can create lists of tasks and mark them as completed. Very useful feature, is not it?

18. To make a vertical selection, hold Alt and drag the mouse cursor. This can come in handy if you accidentally mess up your list, for example.

19. I’m too lazy to talk about the importance of this command. To protect a document with a password, click “File” and select the “Protect Document” option. Now feel free to create a password, but be careful, because if you forget it, you will not be able to recover it.

20. In the end, I suggest you try to feel like an advanced user. If you used to open Word by creating a new document or searching for it in the Start menu, that's a thing of the past. Press combination Windows keys R and enter winword in the window that appears. If you don't use command line for other commands, the next time you press Windows R, the command to launch Word will automatically load and all you have to do is press Enter.

This is all that came to mind, of course, there are many more different tricks for working with Word, but using even this set, the efficiency of your work with Word will increase significantly! So feel free to try, use and be happy that you have learned something new.

What tricks do you know about working with Word? Write in the comments to the article.

Date: May 22, 2017 Category:

Hello, friends. Today we begin to consider working with Microsoft Office Word(I will tell you using version 2013 as an example). If you have already studied Excel work on my blog, it will be much easier for you to understand Word, since the management principles in most programs Office package identical.

What is Word and what to use it for

I think everyone knows that Microsoft Word is the most popular text editor that provides wide functionality to your users. And recently, it began to support “cloud” technologies, which made it possible to simplify sharing and make your documents accessible anywhere there is Internet access.

Word workspace

A Word workspace is a document that resembles a piece of paper. It's like you're sitting at a typewriter, and every keystroke is transferred to a sheet of paper. It’s the same here, only the sheet is on your screen. In addition, there are many buttons, icons, tools with which you can make professional text documents without much difficulty.

As for the contents of the Microsoft Word window, it consists of the following elements:

  1. Title bartop part a program window in which the file name is displayed and some controls are located:
    • Document's name, located in the center of the screen
    • Panel quick access – located in the upper left corner, contains the most frequently used commands. You can customize the Quick Access Toolbar to your liking;
    • Help button
    • Ribbon Display Options button. Here you can select the feed display modes;
    • Minimize and close buttons current window
  2. Ribbon– located below the title bar, contains all the main controls:
    • Ribbon Tabs– groups of tools combined in accordance with their purpose
    • Ribbon– an area with tools for customizing the document and its contents
  3. Workspace– a space that imitates a sheet of paper. This is where the results of your work are located - text, images, diagrams, etc.
  4. Status bar– displays supporting information about your document: active page, number of words in the document, spell check language and much more. The contents of the status bar can be customized;
    • View mode selection buttons– determine what your work area will look like;
    • Scale– slider for setting the scale for the work area
  5. Scroll bars(horizontal and vertical) – tools for scrolling through content that does not fit entirely on the screen;
  6. Rulers– help you navigate the layout of the sheet, as well as quickly adjust margins and indents.

In general, everything is organized in the traditions of Microsoft Office, thought out and polished. This workspace layout is unified; once you understand it, you won’t get lost in another product from the Microsoft Office suite.

I'm finishing this short introductory post, and in the next article I will talk about documents in Microsoft Word. Join us!