Excel manual. Full information about Formulas in Excel. Use of various types of arguments

Anyone who uses in the daily work of the computer, one way or another came across an Excel office app, which is included in the standard Microsoft Office package. It is available in any version of the package. And quite often, starting familiarity with the program, many users are asked about in Excel on their own?

What is an Excel program?

To begin with, we will define what Excel is, and for which it is necessary for this application. Probably, many have heard that the program is a tabular editor, however, the principles of its functioning are found in the root differ from the same tables created in Word.

If in Word, the table protrudes the element in which the text or the sheet with the Excel table is displayed - it is essentially a unified mathematical machine that is capable of producing a wide variety of calculations based on the specified data types and formulas for which one or other mathematical or algebraic operation.

How to learn how to work in Excel yourself and can it be done?

As the heroine of the film "Service Roman", you can also teach a hare to smoke. In principle, there is nothing impossible. Let us try to understand the elementary principles of the application and focus on understanding its main opportunities.

Of course, the reviews of people who disassemble the specifics of the application, they say that you can, let's say, download some tutorial to work in Excel, however, as practice shows and especially comments from beginner users, such materials are very often represented in too increasing form, and It is difficult to figure out enough.

It seems that the best course of learning will be the study of the main possibilities of the program, and then their use, so to speak, "method of scientific tyk". It goes without saying, first you need to consider the main functional elements of Microsoft Excel (the lessons on the program indicate that this) to compile a complete picture of the principles of work.

The main elements to pay attention to

The very first thing that the user draws attention to the application when the application is started, this is a sheet in the form of a table in which cells are located in different ways, depending on the version of the application itself. In earlier versions, the columns were laid out with lines, and rows with numbers and numbers. In other releases, all marking is presented exclusively in digital form.

What is it for? Yes, only in order to always determine the cell number to specify a specific calculation operation by type of how the coordinates are specified in a two-dimensional system for a point. Later will understand how to work with them.

Another important component is a string of formulas - a special field, on the left having the "F X" icon. It is here that all operations are wondering. At the same time, the mathematical actions themselves are indicated in the same way as it is accepted in the international classification (the sign of equality "\u003d", the multiplication of "*" division "/", etc.). Trigonometric values \u200b\u200balso correspond to international designations (SIN, COS, TG, etc.). But this is the easiest. Operations will have to be discussed with the help of a reference system or specific examples, since some formulas may look sufficiently specific (exponential, logarithmic, tensor, matrix, etc.).

From above, as in other office programs, there is a main panel and the main menu sections with the main items of operations and the quick access buttons to a function or another.

and the simplest operations with them

Consideration of the question of whether it is impossible without a key understanding of the types of data entered in the table cells. Immediately, we note that after prescribing some information, you can press the input button, the Esc key or simply move the rectangle from the desired cell to another - the data will be saved. Cell editing is called by a double click or by pressing the F2 key, and upon completion of the data entry, the saving occurs exclusively when you press the ENTER key.

Now a few words about what can be entered into each cell. The format menu is caused by the right click on the active cell. On the left there is a special column with an indication of the data type (common, numeric, text, percentage, date, etc.). If a general format is selected, the program, roughly speaking, determines what exactly the entered value is similar to (for example, if you enter 01/01/16, the date on January 1, 2016 will be recognized).

When you enter the number, you can use and specify the number of decimal characters (one character is displayed by default, although when you enter the two program, it simply rounds the visible value, although the true does not change).

When using, say, a text type data type, which would be used, it will be displayed precisely in the form of what is scored on the keyboard, unchanged.

That's what's interesting: if you bring the cursor to the dedicated cell, in the lower right corner there will be a cross, pulling for which when the left mouse is shed, you can copy the data to the following code in order. But the data will change. If you take the same example with the date, the following value will be indicated on January 2, etc. Such copying is useful when specifying the same formula for different cells (sometimes even with cross-calculations).

If we talk about formulas, you can use a double approach for the simplest operations. For example, for the amount of A1 and B1 cells, which should be calculated in the C1 cell, you need to place a rectangle in the C1 field and set the calculation according to the formula "\u003d A1 + B1". You can do otherwise by setting the equality "\u003d amounts (A1: B1)" (such a method is used for large gaps between the cells, although you can use the automatic summation function, as well as the English version of the sum of the sum of Sum).

Excel: How to work with Excel sheets

When working with sheets, you can make many actions: add sheets, change their name, delete unnecessary, etc. But the most important thing is that any cells on different sheets can be interconnected by certain formulas (especially when large arrays of different type information are introduced).

How to learn how to work in Excel yourself in terms of use and computing? It's not so simple here. As user reviews show, at one time we have mastered this tabular editor, it will be quite difficult to do this without any help. You need to read at least the reference system of the program itself. The simplest way is to enter the same cells in the same formula by highlighting them (it can be done on one sheet, and on different. Again, if you enter the sum of several fields, you can register "\u003d sums", and then simply alternate when the Ctrl key is shed The desired cells. But this is the most primitive example.

Additional features

But in the program, you can not only create tables with different types of data. On their basis, in a couple of seconds, you can build all sorts of graphics and charts asking for automatic constructions or a dedicated range of cells, or specify it in manual mode when entering the corresponding menu.

In addition, the program has the ability to use special add-ons executed by Visual Basic scripts. You can insert any objects in the form of graphics, video, audio or something else. In general, there is enough opportunities. And here just a small tolika touched on everything that this unique program is capable of.

But what to say, it can calculate the matrices with the right approach, to solve all sorts of equations of any complexity, find the databases and bind them with other applications like Microsoft Access and much more - just do not list.

Outcome

Now, probably, it is already clear that the question of how to learn how to work in Excel on their own, is not so simple for consideration. Of course, if you master the basic principles of work in the editor, ask the simplest operations of labor will not be. User feedback Testimony that you can learn how to maximize this week. But if you need to use more complex calculations, and even more so, working with reference to databases, no matter how much of this, without special literature or courses here is simply not to do. Moreover, it is very likely to tighten even their knowledge of algebra and geometry from the school course. Without this, you can not even dream about the full use of the tabular editor.

Work with Excel: Tutorial. Excel is one of the basic Microsoft Office software package. This is an indispensable assistant when working with overhead, reports, tables.
Excel allows you to:
Program, store huge information
Build graphs and analyze results
To make calculations quickly
This program is an excellent choice for office work.
Getting Started with Excel (Excel)
1. Two times climbing the name of the sheet, we enter the edit mode. In this panel, you can add a new sheet into the book, remove unnecessary. Make it easy - you need to click on the right mouse button and select the "Delete" string.

2. Create another book simply - select "Create" a string in the "File" menu. The new book will settle over the old one, and an additional tab will appear on the taskbar.

Working with tables and formulas
3. An important feature of Excel (Excel) is a convenient work with tables.

Thanks to the tabular view of the data, the tables are automatically transformed into a database. Tables are customary to format, for this we highlight the cells and set them individual properties and format.

In the same window, you can make alignment in the cell, it makes the Alignment tab.

In the Font tab, there is an option to change the text font in the cell, and in the "Insert" menu, you can add and delete columns, strings and more.

Move the cells easily - the "Cut" icon on the Home tab will help.

4. No less important than the ability to work with tables, is the skill of creating formulas and functions in Excel.

Simple F \u003d MA is a formula, the force is equal to the product of mass and acceleration.

To burn such a formula in Excel (Excel), you must start from the "\u003d" sign.

Printing a document
5. And the main stage after the work performed is the printout of documents.

Within the first Excel 2010 material for beginners, we will get acquainted with the basics of this application and its interface, learn how to create spreadsheets, as well as enter, edit and format the data in them.

Introduction

I think I will not be mistaken if I say that the most popular application included in the Microsoft Office package is a test editor (processor) Word. However, there is another program, without which any office worker rarely cost. Microsoft Excel (Excel) refers to software products called spreadsheets. With Excel, in a visual form, it is possible to calculate and automate the calculations of almost all anything, starting from a personal monthly budget and ending with complex mathematical and economic and statistical calculations containing large amounts of data arrays.

One of the key features of the spreadsheet is the ability to automatically recalculate the value of any desired cells when changing the contents of one of them. To visualize the data obtained, on the basis of groups of cells, you can create various types of diagrams, summary tables and cards. In this case, the spreadsheets created in Excel can be inserted into other documents, as well as save in a separate file for subsequent use or editing.

To call Excel simply the "spreadsheet" will be somewhat incorrect, as there are huge opportunities in this program, and in its functionality and the circle of solved tasks, this application, perhaps, can exceed Word. That is why, within the framework of the Excel materials cycle for beginners, we will get acquainted with the key capabilities of this program.

Now, after the end of the introductory part, it's time to move on to business. In the first part of the cycle, for better assimilation of the material, as an example, we will create a conventional table, reflecting personal budget expenditures for six months of this type:

But before starting it to create it, let's first consider the basic elements of the interface and control of Excel, as well as let's talk about some basic concepts of this program.

Interface and Management

If you are already familiar with the Word editor, it will not be difficult to understand the Excel interface. After all, it is based on the same Tape, but only with another set of tabs, groups and teams. At the same time, to expand the workspace, some tab groups are displayed on the display only if necessary. You can also roll the tape at all by clicking on the active tab twice the left mouse button or by pressing the Ctrl + F1 key combination. Returning it to the screen is carried out in the same way.

It is worth noting that in Excel for the same command, several ways to call it can be provided immediately: through the tape, from the context menu or using a combination of hot keys. Knowledge and use of the latter can greatly speed up the work in the program.

The context menu is context-sensitive, that is, its content depends on the fact that the user does at the moment. The context menu is called by pressing the right mouse button almost on any object in MS Excel. This saves time, because it displays the most frequently used commands to the selected object.

Despite such a variety of management, the developers went further and provided users in Excel 2010 the ability to make changes to embedded tabs and even create their own with those groups and commands that are used most often. To do this, click right-click on any tab and select item. Setting tape.

In the window that opens, in the menu on the right, select the desired tab and click on the button Create tab or To create a group, and in the left menu, the desired command, then click the button Add. In the same window, you can rename existing tabs and delete them. To cancel erroneous actions there is a button Resetreturning the settings of the tabs to the initial one.

Also most frequently used commands can be added to Fast access panellocated in the upper left corner of the program window.

You can make it by clicking on the button. Setting the Quick Access Panelwhere it is enough to choose the desired command from the list, and in the absence of in it necessary, click on the item Other teams.

Entering and editing data

Created to Excel files are called workbooks and have an extension "XLS" or "XLSX". In turn, the workbook consists of several working sheets. Each work sheet is a separate spreadsheet, which, if necessary, can be interrelated. The active working book is the one with which you currently work, for example, in which enter the data.

After starting the application, a new book is automatically created with the name "Book1". By default, the workbook consists of three working sheets with names from "List1" to "List3".

Excel leaf work field is divided into many rectangular cells. The horizontal cells make up lines, and vertically - columns. For the ability to study a large amount of data, each work sheet of the program has 1,048,576 lines of numbered numbers and 16,384 columns designated by the letters of the Latin alphabet.

Thus, each cell is a place of intersection of various columns and lines on a sheet forming its own unique address consisting of the letter of the column and the number of the string with which it belongs. For example, the name of the first cell is A1, as it is at the intersection of the column "A" and the lines "1".

If the application is enabled Row of formulaswhich is located immediately under Ribbonthen to the left of it is Field namewhere the name of the current cell is displayed. Here you can always enter the name of the scholar cell, to quickly transition to it. This feature is especially useful in large documents containing thousands of rows and columns.

Also for viewing different areas of the sheet, the scroll strips are located downstairs. In addition, it is possible to navigate the Excel working area using the arrow keys.

To start entering data into the desired cell, it must be allocated. To go to the desired cell, click on it with the left mouse button, after which it will be surrounded by a black frame, the so-called active cell indicator. Now just start typing on the keyboard, and all the information entered will be provided in the selected cell.

When entering data into the cell, you can also use the formula string. To do this, highlight the desired cage, and then click on the Formula Row field and start printing. At the same time, the information entered will be automatically displayed in the selected cell.

After entering the data entry, press:

• The "Enter" key - the next active cell will be the bottom of the bottom.
• The "Tab" key - the next active cell will be the cell on the right.
• Click on any other cell, and it will become active.

To change or delete the contents of any cell, click on it two times the left mouse button. Move the flashing cursor to the desired place to make the necessary edits. As in many other applications, the arrows, "del" and "backspace" keys are used to delete and making corrections. If desired, all necessary edits can be made in the formula row.

The amount of data that you will be inserted into the cell is not limited to its visible part. That is, the working field cells of the program may contain both one digit and several text paragraphs. Each Excel cell is capable of accommodating up to 32,767 numeric or text characters.

Formatting data of cells

After entering the names of rows and columns we get a table of this type:

As can be seen from our example, several names of the costs of the costs "came out" beyond the boundaries of the cell and if the neighboring cell (cells) also contain some information, the introduced text partially overlaps to it and becomes invisible. Yes, and the table itself looks quite ugly and non-primable. At the same time, if you print such a document, then the current situation will be saved - to disassemble what it will be quite difficult to make sure that you can make sure of the figure below.

To make a tabular document more accurate and beautiful, often you have to change the size of rows and columns, the font of the cell content, its background, exercise text alignment, add borders and so on.

First, let's put the left column in order. Move the mouse cursor on the border of the columns "A" and "B" in the string where their names are displayed. When changing the mouse cursor to a characteristic symbol with two multidirectional arrows, press and hold the left key, drag the dotted line in the desired direction to expand the column until all the names are appropriate within the same cell.

The same actions can be done with a string. This is one of the easiest ways to change the size of the height and the width of the cells.

If you need to specify the exact dimensions of the rows and columns, then for this on the tab the main in a group Cells Select Format. In the menu that opens using commands String height and Column width You can set these parameters manually.

It is very often necessary to change the parameters in the rod of several cells and even a whole column or string. In order to select a whole column or string, click on its name from above or on its number on the left, respectively.

To highlight the neighboring cells, blaming their cursor, hold the left mouse button. If you need to highlight the scattered table fields, then press and hold the "Ctrl" key, then click the mouse over the necessary cells.

Now that you know how to highlight and format several cells at once, let's align the name of the months in our table in the center. Different content leveling commands inside the cells are on the tab. the main in a group with speaking name Alignment. At the same time, for a table cell, this action can be made both relative to the horizontal direction and vertical.

Circle cells with the name of months in the table header and click on the button Align in the center.

In a group Font On the tab the main You can change the type of font, its size, color and inscription: fat, rush, emphasized and so on. Also, there are buttons for changing the boundaries of the cell and the color of its fill. All these functions will use us for further changes in the appearance of the table.

So, for starters, let's increase the font of the names of the columns and columns of our table up to 12 points, as well as make it fat.

Now we highlight the top line of the table and install it a black background, and then in the left column cells with A2 by A6 - dark blue. You can do this using the button Color fill.

Surely you noticed that the color of the text in the top row merged with the color of the background, and in the left column, the names are read bad. Correct this by changing the color of the font using the button Text color on white.

Also with the help of a familiar team Color fillwe gave the background of even and odd rows with numbers a different blue tint.

So that the cells do not merge, let's define the borders. The definition of boundaries occurs only for the dedicated area of \u200b\u200bthe document, and can be done both for one cell and for the entire table. In our case, select the entire table, then click on the arrow next to the button Other borders All in the same group Font.

In the menu that opens, a list of fast commands is displayed, with which you can select the display of the desired boundaries of the selected area: lower, top, left, right, external, all, etc. Also here contains commands for drawing borders manually. At the bottom of the list there is a paragraph Other borders Allowing more detailed to set the necessary parameters of the boundaries of the cells that we use.

In the window that opens, first select the border line type (in our case, thin solid), then its color (choose white, since the background table is dark) and finally, those borders that will have to be displayed (we chose internal).

As a result, using a set of commands of just one group Fontwe transformed a non-pieces appearance of the table in quite presentable, and now knowing how they work, you can independently invent your unique styles to design spreadsheets.

Cell data format

Now, to complete our table, you must properly arrange the data that we enter there. Recall that in our case it is cash spending.

In each of the cells of the spreadsheet, you can enter different types of data: text, numbers, and even graphic images. That is why in Excel there is a concept as "cell data format", which serves for the correct processing of the information you enter.

Initially, all cells have General formatallowing them to contain both text and digital data. But you have the right to change it and choose: numeric, monetary, financial, interest, fractional, exponential and formats. In addition, there are date formats, postal index time, phone numbers and table numbers.

For the cells of our table containing the names of its rows and columns, the general format is quite suitable (which is set by default), as they contain text data. But for the cells in which budget expenditures are introduced more cash format.

Highlight in the cell table containing information on monthly costs. On the ribbon in the tab the main in a group Number Click on the arrow next to the field Numeric format, After that, the menu will open with the list of the main available formats. You can choose Monetary right here, but we will choose the lowest line for a more complete acquaintance Other numeric formats.

In the window that opens, the name of all numeric formats will be displayed in the left column, including additional, and in the center, various settings for their display.

By selecting a cash format, you can see the window on top, then how the value in the table cells will look like. Slightly below the mono set the number of decimal signs. To kopecks did not clutch the fields of the table, exhibit here a value equal to zero. Next, you can choose a currency and mapping of negative numbers.

Now our tutorial finally accepted the completed view:

By the way, all the manipulations that we have done with the table are higher, that is, the formatting of the cells and their data can be performed using the context menu by right-clicking on the selected area and selecting the item Format cells. In the window that opens for all operations considered by us, there are tabs: Number, Alignment, Font, The border and Fill.

Now at the end of the program, you can save or print the result. All these commands are in the tab. File.

Conclusion

Probably, many of you will look at the question: "Why create a similar kind of table in Excel, when all the same can be done in Word using ready-made patterns?". So it is so, just to produce all sorts of mathematical operations on cells in a text editor is impossible. You have the same information in cells, you almost always put on your own, and the table is only a visual view of the data. Yes, and the volumetric tables in Word are not entirely convenient.

In Excel, the same way is on the contrary, the tables can be as large, and the cell value can be entered both manually and automatically calculate with the help of formulas. That is, the table is here not only as a visual manual, but also as a powerful computational and analytical tool. Moreover, the cells among themselves can be interconnected not only within one table, but also contain values \u200b\u200bobtained from other tables located on different sheets and even in different books.

You will learn how to make the "smart" table in the next part, in which we will get acquainted with the main computational capabilities of Excel, the rules for constructing mathematical formulas, functions and many others.

Most Windows-based computer users with a Microsoft Office installed with the MS Excel application certainly faced. Beginner users have a program that causes some difficulties in mastering, nevertheless, work in "Excele" with formulas and tables is not so difficult, as it may seem at first glance, if you know the basic principles laid down in the annex.

What is Excel?

In fact, Excel is a full-fledged mathematical machine for performing a plurality of arithmetic, algebraic, trigonometric and other more complex operations, operating by several basic data types that are not always related to mathematics.

Working with Special tables implies the use of broader opportunities with association and computing, and ordinary text, and multimedia. But in its original form, the program was created precisely as the most powerful mathematical editor. Some, however, initially accept the application for some kind of calculator with advanced features. The deepest misconception!

Work in "Excele" with tables for beginners: first acquaintance with the interface

First of all, after opening the program, the user sees the main window in which there are basic controls and tools for work. In later versions, at the start of the application, a window appears in which you are proposed to create a new file, the default is called "Book 1" or select a template for further actions.

Working with the "Excel" tables for beginners at the first stage of acquaintance with the program should come down precisely to the creation of a blank table. While we consider the main elements.

The main field is the table itself, which is divided into cells. Each has a numbering, thanks to two-dimensional coordinates - the row number and the letter designation (for example, we take Excel 2016). Such a numbering is needed in order for the dependency formula to clearly determine exactly the cell with the data, the operation over which will be made.

From above, as in other office applications, there is a main menu panel, and a little lower to the toolkit. Under it there is a special string in which formulas are introduced, and a little left you can see the window with the coordinates of the currently active cell (which is located a rectangle). The bottom of the sheet panel and the horizontal movement slider are presented, and the type and scaling buttons are located below it. On the right there is a vertical band to move along a sheet up / down.

The main types of data entry and the simplest operations

At first, it is assumed that work in the "Excele" with the tables of the novice user will be mastered by acquaintances to him operations, for example, in the same text editor Word.

As usual, in the table, you can perform copying, cutting or inserting data, enter text or numeric data.

But the input is somewhat different from the one that is produced in text editors. The fact is that the program is initially configured to automatically recognize the fact that the user prescribes in the active cell. For example, if you enter a line 1/2/2016, the data will be recognized as the date, and in the cell instead of the entered digits will appear in a simplified form - 01.02.2016. You can simply change the display format (let's stop at this later).

The situation is the same in the same way. You can enter any numeric data even with an arbitrary number of semicolons, and they will be displayed in the form in which all of them are used to seeing them. But if an integer is introduced, it will be represented without a mantissa (decimal places in the form of zeros). You can change it too.

But at the end of the data entry, many novice users try to go to the next cell using the keyboard arrows to do this (by type of how can this be done in Word tables). And it does not work. Why? Yes, just because working with the "Excel" tables differs from the Word text editor is quite noticeable. The transition can be performed by pressing the ENTER key or installing the active rectangle on another cell using the left mouse click. If after writing something in the active cell to press the ESC key, the input will be canceled.

Actions with sheets

Working with sheets at the first time does not cause difficulties. On the bottom panel there is a special button of adding sheets, after clicking on which a new table will appear with an automatic transition to it and the name of the name ("Sheet 1", "Sheet 2", etc.).

Double-click you can activate the renaming of any of them. You can also use the right click menu to call the additional menu in which there are several basic commands.

Formats of cells

Now the most important thing is the cell format is one of the basic concepts that determines the type of data that will be used to recognize its contents. You can call format editing through the right click menu, where the corresponding string is selected, or by pressing the F2 key.

In the left window, all available formats are presented, and on the right shows the data display options. If you look at an example with the date shown above, the "date" is selected as a format, and the desired view is set to the right (for example, February 1, 2016).

To carry out mathematical operations, you can use several formats, but in the simplest case, choose a numeric. On the right there are several types of input, a pointer to the number of characters in the mantissa after the comma and the field of setting the separator of the discharge groups. Using other numeric formats (exponential, fractional, monetary, etc.), you can also set the desired parameters.

By default, a general format is installed for automatic data recognition. But when entering a text or several liter, the program can convert it spontaneously into something else. Therefore, to enter text for an active cell, you need to set the appropriate parameter.

Work in "Excel" with formulas (tables): example

Finally, a few words about formulas. And for beginnings, consider an example of the sum of two numbers in cells A1 and A2. The appendix has an automatic summation button with some additional functions (calculating the average arithmetic, maximum, minimum, etc.). It is enough to install the active cell located in the same column below, and when the amount is selected, it will be counted automatically. The same works for horizontally located values, but the active cell for the amount must be relevant.

But you can enter the formula and manually (work with the "Excel" tables assumes this possibility when automatic action is not provided). For the same amount, in the formula line, put a sign of equality and register an operation as A1 + A2 or amounts (A1; A2), and if you want to specify the range of cells, this view is used after the sign of the equality: (A1: A20), after which it will be The sum of all numbers in the cells from the first to twentieth are considered increasing.

Construction of graphs and charts

Working with the tables "Excel" is also interesting because it implies the use of a special automated tool for constructing graphs of dependencies and charts based on the dedicated ranges.

This provides a special button on the panel, after clicking on which you can select any parameters or desired views. After that, the diagram or schedule will be displayed on a sheet as a picture.

Cross-links, import and export data

The program also contains links for data on different sheets, use other format files or objects on the Internet on the Internet, and many other add-ons.

In addition, Excel files can be exported to other formats (for example, PDF), copy data from them, etc. But the program itself can open files created in other applications (text formats, databases, web pages, XML Documents, etc.).

As you can see the ability of the editor almost unlimited. And, of course, describe them all just not enough time. Here are only the initial basics, but the interested user will have to read the reference information in order to master the program at the highest level.

Microsoft Excel is convenient for tableware and the work of calculations. The workspace is a variety of cells that can be filled with data. Subsequently - format, use to build graphs, diagrams, summary reports.

Working in Excel with tables for novice users may at first glance seem challenging. It differs significantly from the principles of building tables in Word. But let's start with small: with the creation and formatting of the table. And at the end of the article you will understand that the best tool for creating tables than Excel will not come up with.

How to create a table in Excel for dummies

Working with tables in Excel for dummies does not tolerate hurry. You can create a table in different ways and for specific purposes each method has its advantages. Therefore, first visually assess the situation.

Look carefully on the working sheet of the tabular processor:

This is a variety of cells in columns and lines. In fact, the table. Columns are indicated by Latin letters. Rows are numbers. If you bring this sheet to print, we get a clean page. Without any borders.

First, let's learn how to work with cells, rows and columns.



How to highlight columns and string

To highlight the entire column, click on its name (Latin letter) with the left mouse button.

To highlight the string - by the name of the line (according to the figure).

To highlight a few columns or rows, click the left mouse button by name, keep and drag.

To highlight the column using hot keys, we put the cursor to any cell of the desired column - press Ctrl + space. To highlight the string - Shift + space.

How to change the boundaries of the cells

If the information when filling out the table does not fit, you need to change the boundaries of the cells:

To change the width of the columns and the height of the rows, in a certain range, we highlight the area, increase the 1 column / string (manually moving) - the size of all selected columns and rows will automatically change.

Note. To return the previous size, you can press the "Cancel" button or a combination of Ctrl + Z hotkeys. But it works when you do right away. Later - will not help.

To return the strings to the source boundaries, open the tool menu: "Home" - "Format" and choose "Row height"

For columns, this method is not relevant. Click "Format" - "Default Width". I remember this figure. We highlight any cell in the column, the boundaries of which you need to "return". Again the "format" - the "column width" - enter the specified program (as a rule it is 8.43 - the number of Calibri font characters with a size of 11 points). OK.

How to insert a column or string

We highlight the column / string to the right / below the place where you need to insert a new range. That is, the column will appear to the left of the selected cell. And the string is higher.

Press the right mouse button - select in the drop-down menu "Paste" (or press the combination of hot keys Ctrl + Shift + "\u003d").

We celebrate the "column" and click OK.

Council. To quickly insert the column, you need to highlight the column in the desired place and press Ctrl + Shift + "\u003d".

All these skills will be useful when drawing up a table in Excel. We will have to expand borders, add strings / columns during operation.

Step-by-step creating table with formulas

Now when printing the boundaries of columns and lines will be visible.

Using the "Font" menu, you can format Excel Table data as in Word.

Change, for example, the font size, make the cap "Fat". You can set the text in the center, assign transfer, etc.

How to create a table in Excel: Step-by-step instructions

The simplest way to create tables is already known. But Excel has a more convenient option (in terms of subsequent formatting, data working).

Let's make a "smart" (dynamic) table:

Note. You can go on another path - first allocate the range of cells, and then click the "Table" button.

Now make the necessary data to the finished framework. If an additional column is required, we put the cursor to the cell intended for the name. Enter the name and press the input. The range will automatically expand.

If you need to increase the number of rows, engage in the lower right corner for the autocill marker and stretch down.

How to work with a table in Excel

With the release of new versions of the program, work in Excel with the tables became more interesting and dynamic. When a smart table is formed on a sheet, the "Work with Tables" tool becomes available - "Designer".

Here we can give a name table, resize.

Different styles are available, the ability to convert a table to a regular range or a summary report.

Opportunities for dynamic spreadsheet MS Excel huge. Let's start with the elementary data entry skills and autofills:

If you click on the arrow to the right of each subtitle of the cap, then we will receive access to additional tools to work with the data of the table.

Sometimes the user has to work with huge tables. To see the results, you need to scroll not one thousand lines. Delete lines - not an option (data will be subsequently needed). But you can hide. For this purpose, use numeric filters (picture above). Clean the ticks opposite those values \u200b\u200bthat should be hidden.