A detailed guide to using Microsoft Word. What is Word? Basic and undocumented features

It is not necessary to know and use all the features of the Microsoft text editor. You can successfully complete work tasks by occasionally switching between the Home and Insert tabs. But you will be even more efficient when armed with even a few of the tricks from this review.

Here's a simple example familiar to webmasters. Some professionals copy the content into Notepad before transferring text from the Word document to the CMS editor. This clears the text of Word formatting that might conflict with "engine" template formats. 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. The current stable version of 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 MS Word document

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

To easily find your document, name it.

Alternatively, you can launch MS Word from the Start menu. Pay attention to the illustration.

When launched from the start menu, you created a new document with a default title. Name it and save it to the folder of your choice so as not to lose it. To do this, click on the "Save" icon or use the Shift + F12 key combination.

Name the document and save it to the folder of your choice.

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

How to use the features of the Home tab

The 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, selected on the Home tab.

The following are tasks that you can accomplish using the tools on the Home tab.

Toolbox "Clipboard"

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

Pay attention to the insert options. You can keep the original formatting, combine formats, or keep the text without formatting. You can also use the special insert modes.

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

This issue is addressed with a 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 the document. To open the clipboard, click on the arrow marked in the illustration. Select the item you want. Use the drop-down menu to select the "Paste" option. You can also remove the copied item from the clipboard.

You can customize the default paste options. To do this, use the "Insert - Insert by default" menu.

Specify the appropriate settings and save your 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 the existing text, the fragment must be selected before choosing a font.

With the help of the corresponding menu you can choose the appropriate font size. Pay attention to the possibility to increase or decrease the font of the selection. Mark the text and use the buttons marked in the illustration.

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

You can make a piece of text bold, italic, or underlined. To do this, select the content and use the marked buttons. Using the drop-down menu, you can choose how the text is underlined.

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

Use the X 2 and X 2 buttons to 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.

Pay attention to the possibility of configuring advanced font parameters. Press the button marked in the illustration to enter the menu.

On the Font tab, specify the appropriate options for body text and headings. Using the "Default" button you can return to the default settings, and using the "Text Effects" button you can select additional effects.

Toolbox "Paragraph"

Use the drop-down menus shown in the illustration to create a bulleted, numbered, or tiered list.

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

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

To create a multilevel list, select the "Change list level" option in the corresponding drop-down menu.

You can choose the appropriate list style in the library. And the Define New Multilevel List and Define New List Style menus help you create your own list template.

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

Change the line spacing as needed. In most cases, the standard spacing of 1.15 will be fine. If you are preparing a document for children or the elderly, increase the spacing to 1.5 or 2.0. Increasing the spacing further will reduce the readability of the text.

Using a 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 select a suitable color using the Fill drop-down menu.

Using the Borders menu, you can control the borders of cells in tables. Highlight the cells of interest. Use the drop-down menu to select the appropriate action.

Styles toolbox

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

Toolbox "Editing"

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

The Replace function is useful 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 function to quickly highlight content. For example, you can select all text in two clicks, select arbitrary objects or select fragments with the same formatting.

With the "Minimize Ribbon" function you can hide the program management tools. Only the tabs will remain on the panel.

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

How to use the features of the "Insert" tab

The "Insert" tab contains tools with which you can insert various objects into a MS Word document.

Toolbox "Pages"

From the Cover Page menu, you can select a cover page template for your document.

You can use the Blank Page and Page Break features to create a blank page or navigate 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"

With the dropdown menu "Table" you can insert or draw a table in the document. This can be done in several ways.

Use a graphical tool to quickly add a table. Select the required number of cells in the table with the mouse cursor. After that, place the cursor on the selected area and press the left mouse button.

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

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

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

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

Illustrations toolbox

With the "Pictures" function, you can insert an image from your computer's hard disk into a document. The Internet Pictures menu allows you to find suitable photos on the web.

Photos licensed under Creative Commons are given priority in search results.

The Shapes feature can help 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 pointer to size and position the shape in your document.

Decorate the shape with Fill, Path, Effects.

SmartArt lets you insert graphics into your document. Use the drop-down menu to select the type and the appropriate drawing.

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

Note the ability to change the color of SmartArt objects.

You can add charts to your document using the Chart menu. Pay attention to the possibility of choosing the type of chart.

Insert the required values \u200b\u200binto the data table.

Using the Snapshot menu, you can take a screenshot of an area of \u200b\u200bthe screen and insert it into your document. To do this, use the drop-down menu to select the "Screen cutout" option, and with the mouse cursor select the area you want to capture.

Toolbox "Add-ins"

In add-ins, you'll find the Office app store. It has free and paid tools for solving special problems. To select a suitable 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 your document. To use the application, click the "Trust" button. The tool's capabilities will become available after authorization.

The My Apps menu displays a list of installed apps. You can remove unused and add new tools.

The Wikipedia function allows you to search for information on the 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 you want to find meaning. The tool requires Internet access.

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

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

Multimedia tools

With the Internet Videos tool, you can insert appropriate objects into your document. To use the function, click the Internet Videos button, search for the video by searching on YouTube or Bing, and select and paste the item.

The video can now be viewed in a MS Word document. This will require internet access.

You can watch video in Word

Links function

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

The Bookmark function allows you to quickly jump to marked sections of text. To add a bookmark, select the required piece of text, and in the "Links" drop-down menu, select the "Bookmarks" option. Name the bookmark and click Add.

To quickly jump to the pledged content, select the "Bookmark" menu, select the desired bookmark and click "Go".

Note function

The "Notes" function is useful for group work with 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 ready, place the cursor on it and open the context menu with the right mouse button. Select the required option.

Header and Footer toolbox

Using the tools in the Headers and Footers group, you can add headers and footers to your pages, and number the pages of your document.

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

Enter your text. Close the header and footer window to save your changes.

To remove or change a header or footer, 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 your document. To do this, use the drop-down menu to select the location and numbering template.

Toolbox "Text"

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

Add text and save your changes.

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

Use the Add WordArt menu to 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 lets you style paragraphs with an eye-catching 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 drop cap parameters. You can choose the font, height and distance from the text.

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

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

The Object function allows you to insert objects or text from a file into a document. To insert text from a file, select the appropriate option from the drop-down menu. Find the file on your hard disk, the text of which you want to insert into the document, and click "Insert".

Toolbox "Symbols"

The Equation feature helps you insert a mathematical formula into your document. Use the dropdown menu to select a standard formula or go to the constructor. Add the required values \u200b\u200band save the changes.

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

How to use the features of the "Design" tab

Using the tools of the "Design" tab, you can change the appearance of the document. If you want to change the default settings, start by choosing a theme.

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

From the Styles menu, select the style that suits you best.

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

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

The Paragraph Spacing menu can be used to change the appropriate settings. It is possible to delete the interval, select standard or set your own values.

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

Page background toolbox

The Matte function allows you to select a default or customize a custom matte. To set the parameters manually, use the "Custom Background" option.

Using the Page Color function, you can change the corresponding setting. Pay attention to the Fill Methods option. With it, you can add texture, pattern and drawing to pages.

The Page Borders feature allows you to add borders to pages. Use template or custom settings.

How to use the features of the Page Layout tab

Tab tools allow you to change the page layout of your document.

Page setup toolbox

The "Fields" function allows you to select standard or specify your own field parameters. Use the Custom Fields option to set custom values.

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

In the "Columns" menu, you can specify the number of columns per sheet. The Breaks and Line Numbers features let you customize page breaks and add line numbering accordingly. The hyphenation menu allows you to enable word wrap from line to line by syllables. This feature is disabled by default. Do not change this setting unnecessarily.

Toolbox "Paragraph"

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

Using the Spacing function, you can change the spacing between selected paragraphs. To do this, place the cursor in front of the selected paragraph and set the values.

Arrange toolbox

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

The Text Wrap feature allows you to choose how text flows around an object. To test the tool, select the picture and use the drop-down menu.

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

How to use the features of the Links tab

Toolbox "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 the corresponding item. Highlight the text fragment to which the footnote refers, and click the button marked in the illustration.

With the Insert Endnote feature, you can 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.

Toolbox "References and Bibliography"

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 to which the link refers. Click the appropriate button, in the window that opens, specify the required information and save the changes.

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

The drop-down menu "Style" allows you to select the style of links. Using the "References" function, you can insert relevant information into your document.

Toolbox "Names"

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

Using the "List of Figures" function, you can add relevant information to the document.

Toolbox "Subject Index"

The Mark Item feature 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 of the index in your document.

Link Table toolbox

How to use the capabilities of the "Mailings" tab

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

Toolbox "Create"

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 data on the envelope. Pay attention to the "Feed" field. This is how the envelope feeds into the printer.

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

Merge Start, Document and Field List Compose, Result View, and Finish toolboxes

The Start Mail Merge feature allows you to send a message to multiple recipients. For example, you can send a letter or email. To do this, click the "Start Merging" button and select the "Step by Step Merge Wizard" option. Follow the prompts in the task area.

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

Use the Review tab to revise and grade the document.

"Spelling" toolbox

Using the button marked in the illustration, you can launch the standard MS Word tool for finding errors and typos. Please note that the program does not “see” all errors, and sometimes offers fixes where there are no errors.

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

Language toolbox

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

The Language feature allows you to select the language for the spell checker and also to customize the language settings.

Toolbox "Note"

Using the block tools, you can add, view, edit, and delete notes. Note that you can also create notes from the Insert tab.

Record Changes and Changes Toolboxes

The Corrections feature allows you to track changes made to a document. Pay attention to the "Test area" menu. It allows you to choose how the list of changes is displayed: at the bottom or on the side of the document.

The 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 merge corrections from multiple users. The functions "Block Authors" and "Restrict Editing" protect the document from unwanted actions of other users.

How to use the features of the "View" tab

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

View Modes toolbox

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

Display toolbox

Group tools enable the display of the ruler, grid, and navigation pane. The latter 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 are editing content and want to check the original. The Arrange All feature combines multiple documents into one window. The "Divide" function is necessary to work with different parts of the document in one window.

With the Side by side function, you can arrange two documents in one window next to each other. This is useful when you need to compare content.

With the Switch to Another Window function, you can quickly switch 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 have to highlight passages of text in bold italic type. To perform this action automatically, create a macro. Proceed like this:

  • Select an arbitrary 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 a keyboard shortcut to activate the macro.

  • Click the Assign button and run the commands that you want to include in the macro. To do this, go to the "Home" tab, select the bold and italic selection.
  • 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 with which you can quickly solve common tasks when working with MS Word:

  • Use the context menu. It is invoked by clicking the right mouse button.

To select a paragraph, left-click any word three times.

To insert placeholder text on the page, write the following symbols: \u003d lorem (2,2). Use the numbers in parentheses to specify the number of paragraphs and placeholder lines. If you replace "lorem" with "rand", random text is used as a placeholder.

  • To quickly create a superscript or subscript, select the word you want and press the key combination "Ctrl +" or "Ctrl Shift +", respectively.
  • To select a sentence, press Ctrl and position the cursor on any word.
  • Select the type of file to be saved. For example, you can save data in PDF format. To do this, select the "Save As" option and select the desired file type.

  • To create a horizontal line, enter three hyphens in a row and press Enter.
  • To type dashes, use the keyboard shortcut Alt + 0151.
  • To quickly move a piece of text, select it, press F2, position the cursor at the insertion point and press Enter.

Hello, friends! After reading today's "Cheat Sheet", you will see that calculating WORD tables is a fairly simple matter. We will learn how to perform all arithmetic operations with digital data of Word tables, find the average, calculate percentages. We will not deal with higher mathematics (I promise): we will send those who need integrals, derivatives or (forgive sirs) extrema of functions straight to Excel.

But before proceeding directly to the calculations, let's remember how it is customary to set cell addresses in tables. In fig. 1 shows a table with numbered rows and designated columns.

(pictures are clickable)

Here, to make it clear, the addresses of the numbers in it:

  • A5 - 12;
  • B2 - 34;
  • C3 - 47;
  • D6 - 61.

Moreover, it is not at all necessary to put down the letter designation of the columns or number the rows directly in the table itself: such addressing is assumed by default. Now you can start directly with the calculations. And we'll start with the most common case.

How to add column or row numbers in a Word table

We perform all mathematical operations with numbers in Word tables from the panel "Working with tables", which opens by clicking the left mouse button in the table field or by the move marker (cross at the top left). Next, go to the tab "Layout", section "Data", button "formula" (see fig. 2).

In order to add the numbers of one row, by placing the cursor in its last cell intended for the sum, click in the drop-down dialog box "Formula" by button "OK"... Is that so simple? In this case, yes. The fact is that by default the text editor offers to calculate exactly the amount, and the location of the cursor in the last cell will explain to the smart program that all the numbers in the given line need to be added (Fig. 3).

Of course, if you need to add not all the numbers in a row, but only from several columns, then this problem can be solved. Then just put the cursor in the column after the numbers to be added. Pay attention, friends, to the entry in the top line of the window "Formula": = SUM (LEFT) - this inscription just means: the sum of numbers to the left of the cursor. In the same way, the program can calculate for us the sum of the numbers to the right of the cursor - = SUM (RIGHT).

I would like to draw your attention, dear readers, that with its rather developed intellect, the Word does not tolerate emptiness, that is, it perceives an empty cell as a mistake. This means that all empty cells must be filled with zeros.

Similarly, you can sum up the numbers in a row by placing the cursor in its bottom cell. In this case, the entry in the line "formula" the window of the same name will look like this: = SUM (ABOVE)(see Fig. 3), which means the sum of the numbers in the cells located above. Accordingly, if necessary, add the numbers from the cells below the cursor, enter: = SUM (BELOW).

The words - LEFT (left), RIGHT (on right), ABOVE (over), BELOW (under) are called positional arguments. It is convenient to use them for operations in rows and columns, and Word does not take into account the numbers in the heading line.

So, friends, we have sorted out with you the simplest and most frequently used version of calculations in Word tables, when the program is running automatically. In all other cases, you will have to choose a formula and enter the initial data for each pair of cells. Now I will explain to you how this is done.

How to multiply, divide or subtract numbers in a WORD table

To perform these actions, the easiest way is to use the arithmetic operators: * - multiplication; / - division; - - subtraction. Here are examples of records that can be entered into a string "formula":

  • addition - \u003d A1 + B2;
  • multiplication - \u003d A5 * B5;
  • division - \u003d B4 / B1;
  • subtraction - \u003d A6-B6.

Please note that any formula starts with an equal sign (\u003d). And then, without any spaces, enter the cell addresses and arithmetic signs.

There is one more option for multiplication in the program - PRODUCT... This is a multiplication function like SUM - addition. In this case, the addresses of the cells must be entered in parentheses separated by semicolons (see Fig. 4). If we are talking about finding the product of a column or row, then you can not list all the cells, but set them using an interval separated by a colon, for example: = PRODUCT (A1: A8).

And now, friends, a little about the sad. You must have already realized that tables in Word are adapted only for the simplest calculations, the range of possible operations is small. Moreover, in the above arithmetic examples, changing one or both arguments (values \u200b\u200bin cells) will not automatically change the result. To obtain a new value, you will need to select the old one and press the key F9 or by clicking on the highlighted number with the right mouse button, select the line in the pop-up window "Update field".

Of the other mathematical functions for calculating in tables in Word, the following are available:

  • arithmetic mean in the range: = AVERAGE ();
  • determination of the maximum and minimum values \u200b\u200bin the specified cells: = MAX /MIN ();
  • remainder of the division: \u003d MOD ();
  • highlighting the integer part of a number: = INT ();
  • rounding to the specified digit: = ROUND ().

The rest of the functions - statistical and logical - will not be discussed in this article. From what we promised, we still have interest and the arithmetic mean. So we will deal with them.

How to calculate the arithmetic mean in the WORD table and calculate the percentages

  1. To calculate the arithmetic mean in a row or column, put the cursor in their last cell, open the window "Formula" ("Working with tables" - tab "Layout" - section "Data" - button "Formula"). In the top line of the window, enter the required formula: = AVERAGE (A1:A7) and in the last (eighth) cell of the first column we get the result (see Fig. 5).

  1. To calculate percentages in a window "Formula" we will have to record: \u003d [address of the cell with the number from which we will calculate the percentage] / 100 * [percentage]... Let's say we want to take 3% of 300. Enter: \u003d A3 / 100 * 3 or even simpler: \u003d A3 * 0.03. As a result, we get, of course, 9. But I deliberately took prime numbers, the result of the operation with which is easy to check in my head. You, my friends, having grasped the principle of this procedure, can now operate with any values.

To repeat and consolidate the material covered, I suggest watching a short video.

Hopefully, after watching the video, calculations in WORD tables are no longer difficult for you.

Goodbye friends. Your guide to WORD 2016 copywriter GALANT.

Have you read these articles yet? In vain ... This is also about tables:

Calculations and logical comparisons can be performed using formulas. Command Formula is in the section Working with tables in the tab Layout in a group Data.

In Word, formulas are updated automatically when you open the document that contains them. Formula results can also be manually updated. For more information, see.

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

In this article

Insert a formula into a table cell

    In chapter Working with tables in the tab Layout in a group Data press the button Formula.

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

Updating calculation results

In Word, the result of a formula is calculated when you insert it and also when you open the document that contains it. In Outlook, the formula is calculated only when you paste it, and the recipient of the message will not be able to edit it.

In addition, manual updates of the following items are supported:

    the results of individual formulas;

    results of all formulas in a separate table;

    all field codes in the document, including formulas.

Updating the results of individual formulas

    Highlight the formulas to be updated. To select multiple formulas, hold down the CTRL key.

    Do one of the following:

    • Right-click the formula and select the command Update field.

      Press the F9 key.

Refresh the results of all formulas in a table

    Highlight the table containing the formula results you want to update and press F9.

Update all formulas in the 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 the F9 key.

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 the sum in a table using positional arguments, enter zero (0) in the blank cells to be considered in the calculation.

    Select the cell of the table where the result should be. If the cell is not empty, delete its contents.

    In chapter Working with tables in the tab Layout in a group Data press the button Formula.

    In the dialog box Formula do one of the following.

    Click the OK button.

Available functions

Note: Formulas that use positional arguments (such as LEFT) ignore values \u200b\u200bin the header row.

You can use the following functions in formulas located inside Word and Outlook tables.

Act

Return value

Specifies the absolute value of a number in parentheses

Determines whether all arguments within parentheses are true.

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

1 if the sum of the values \u200b\u200bto the left of the formula (on the same line) is less than 10 andthe sum of the values \u200b\u200babove the formula (in the same column, excluding the header cells) is greater than or equal to 5; otherwise, 0.

Finds the arithmetic mean of the items in parentheses.

The arithmetic mean of all values \u200b\u200bto the right of the formula cell (in the same row).

Determines the number of items specified in parentheses.

The number of values \u200b\u200bto the left of the formula cell (in the same row).

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

DEFINED (gross_income)

1 if gross_income is defined and calculated without error; otherwise, 0.

Has no arguments. Always returns 0.

Calculates the first argument. If the first argument is true, the second argument is returned; if false - the third.

Note: All three arguments must be specified.

IF (SUM (LEFT)\u003e \u003d 10; 10; 0)

10 if the sum of the values \u200b\u200bto 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 the largest value among the items specified in parentheses.

The largest value in the cells above the formula (excluding header row cells).

Returns the smallest value among the items specified in parentheses.

The smallest value in the cells above the formula (excluding header row cells).

Has two arguments (numbers or expressions that produce numbers). Returns the remainder of the first argument divided by the second. If the remainder is zero (0), returns 0.0.

Has one argument. Determines whether the argument is true. If the argument is true, it returns 0; if false - 1. Mostly used in the IF function.

Has two arguments. If either of them is true, it returns 1. If both arguments are false, it returns 0. Mostly used in the IF function.

Computes the product of the items specified in parentheses.

The product of all the values \u200b\u200bin the cells to the left of the formula.

Has two arguments (the first argument must be a number or an expression that evaluates to a number, the second an integer or an expression that evaluates to 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 to the specified number of decimal places (down). If the second argument is zero (0), the first argument is rounded to the nearest integer (down). 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 evaluates to a number. Compares the item in parentheses to 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 items specified in parentheses.

The sum of the values \u200b\u200bin the cells to the right of the formula.

Has one argument. Determines whether the argument is true. Returns 1 if the argument is true, and 0 if false. Mostly used in the IF function.

Using bookmarks and cell references in a formula

You can insert a link to a bookmarked cell in a formula using the name of the bookmark. For example, if a bookmark is created for a cell containing a number or an expression that evaluates to a number gross income, formula \u003d ROUND ( gross income, 0) will round the value of this cell down to the nearest whole number.

Note: Formula cells are not counted in calculations that use references. If the cell is part of a link, it is ignored.

RnCn links

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

A1 links

You can use the 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 cell row. 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 how links are written in this format.

Good day, dear readers!

I have been preparing this article for a long time and thought about what might be useful to you in your everyday life. The thought came to my mind that almost every one of us works in Word, and I have specially selected for you the most useful functions of Word. After reading this article, you will see how fast and easy it is to work in a Word.

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

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

2. It happens that while working in a Word, you accidentally press Caps Lock and type a long sentence or even a paragraph without looking at the screen in large letters. And when you finally look up, you realize that you need to erase everything and write again in a normal font. But this problem can be solved easier, 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 one after another. To select several elements at the same time, hold down Ctrl and select the elements you need.

5. Do you know about the enhanced clipboard in Word? Ooo, what are the abstruse words ?! In fact, this is a memory apparatus that is used when copying-pasting material. By clicking on the "Clipboard" button, you can see everything that you copied to the clipboard during your work.

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

7. To reduce the volume of the text and its readability, you can arrange word hyphenation, but doing this manually is simply unrealistic when it comes to a 30-page document. To help the button in the "Page Layout" menu - "Hyphenation", hyphenations in the Word will be placed automatically.

8. Want to protect your document from copying? Add a watermark to your document. Go to the "Design" menu and click on the "Underlay" section. There are four predefined templates in Word, but you can create your own.

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

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

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

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

13. Fast movement through 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. To speed up work in the Word will help the Ctrl Enter combination, which instantly creates a new sheet. You no longer need to hold Enter or click it 50 times.

15. By default, Word saves all files to the Documents folder. You can fix the situation if you go to the menu "File" - "Options" - "Save". In the line "Default local files location" 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, press the Ctrl Spacebar key combination.

17. Working in Word, you can use it as a task manager. Right click on the Feature 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 that has a check mark (why not). Now, by clicking on the checkbox, you can create task lists and mark them as completed. A very useful feature, isn't it?

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

19. It's even 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 won't be able to recover it.

20. In the end, I suggest trying to feel like an advanced user. If earlier, in order to open Word, you created a new document or looked for it in the Start menu, now this is in the past. Press the Windows R key combination and enter winword in the window that appears. If you do not use the command line for other commands, then the next time you press Windows R, the command to start Word will automatically load and all you have to do is press Enter.

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

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

We have already written quite a lot about the capabilities of the advanced MS Word text editor, but it is simply impossible to list all of them. The program, which is primarily focused on working with text, is by no means limited to this.

Sometimes working with documents involves not only text, but also numerical content. In addition to graphs (charts) and tables, you can also add mathematical formulas to Word. Thanks to this feature of the program, you can perform the necessary calculations quite quickly, in a convenient and visual form. It is about how to write a formula in Word 2007 - 2016 that will be discussed below.

Why did we indicate the version of the program starting from 2007 and not from 2003? The fact is that the built-in tools for working with formulas in Word appeared in the 2007 version, before that the program used special add-ons, which, moreover, were not yet integrated into the product. However, in Microsoft Word 2003, you can also create and work with formulas. We will tell you how to do this in the second half of our article.

To enter a formula in Word, you can use Unicode characters, math autocorrect, replacing text with characters. A regular formula entered in a program can be automatically converted to a professionally formatted formula.

1. To add a formula to a Word document, go to the tab "Insert" and expand the button menu "Equations" (in versions 2007 - 2010 this item is called "Formula") located in the group "Symbols".

2. Select an item "Insert new equation".

3. Enter the required parameters and values \u200b\u200bmanually, or select symbols and structures on the control panel (tab "Constructor").

4. In addition to manually entering formulas, you can also use those contained in the arsenal of the program.

5. In addition, a large selection of equations and formulas from the Microsoft Office website is available in the menu item "The equation""Additional Equations from Office.com".

Add frequently used formulas or those that have been pre-formatted

If in working with documents you often refer to specific formulas, it will be useful to add them to the list of frequently used ones.

1. Select the formula you want to add to the list.

2. Click the button "The equation" ("Formulas") located in the group "Service" (tab "Constructor") and in the menu that appears, select "Save the selection to the collection of equations (formulas)".

3. In the dialog box that appears, provide a name for the formula that you want to add to the list.

4. In paragraph "Collection" choose "Equations" ("Formulas").

5. If necessary, set other parameters and click "OK".

6. The formula you saved will appear in the Word quick access list, which opens immediately after clicking the button "The equation" ("Formula") in a group "Service".

Adding general mathematical formulas and structures

To add a mathematical formula or structure in Word, follow these steps:

1. Press the button "The equation" ("Formula"), which is in the tab "Insert"(Group "Symbols") and select "Insert new equation (formula)".

2. In the appeared tab "Constructor" in a group "Structures" select the type of structure (integral, radical, etc.) you want to add, and then click on the structure symbol.

3. If the structure you selected contains placeholders, click on them and enter the required numbers (symbols).

Advice: To change the added formula or structure in the Word, just click on it with the mouse and enter the required numerical values \u200b\u200bor symbols.

Add a formula to a table cell

Sometimes it becomes necessary to add a formula directly to a table cell. This is done in the same way as with any other place in the document (described above). However, in some cases it is required that not the formula itself, but its result is displayed in the table cell. How to do it - read below.

1. Select an empty table cell where you want to place the result of the formula.

2. In the appeared section "Working with tables" open the tab "Layout" and click on the button "Formula"located in the group "Data".

3. Enter the required information in the dialog box that appears.

Note: If necessary, you can choose a number format, insert a function or a bookmark.

4. Click "OK".

Add a formula to Word 2003

As stated in the first half of this article, Microsoft's 2003 version of the text editor does not have built-in tools for creating and working with formulas. For these purposes, the program uses special add-ins - Microsoft Equation and Math Type. So, to add a formula to Word 2003, do the following:

1. Open the tab "Insert" and select item "An object".

2. In the dialog box that appears in front of you, select Microsoft Equation 3.0 and press "OK".

3. A small window will appear in front of you "Formula" from which you can select signs and use them to create formulas of any complexity.

4. To exit the mode of working with formulas, simply left-click on an empty space on the sheet.

That's all, because now you know how to write formulas in Word 2003, 2007, 2010-2016, you know how to change and supplement them. We wish you only positive results in your work and training.

Did you like the article? To share with friends: