How to create a document in Excel. How to create an Excel file, open, save, close

Microsoft Excel 2007 program is one of the two most popular programs in the Microsoft Office suite. The most popular, of course, Microsoft Word. Just recently the latest version of the program was Excel 2003, but now both 2007 and 2010 Excel have appeared. Let's consider How work in Excel 2007. This program is designed for creating tables, presenting series of numbers in a visual form using charts and graphs. Also Microsoft Excel program used to carry out calculations and perform mathematical tasks of varying complexity: from simplifying routine mathematical operations to performing complex calculations. The most important thing is that all this can be done quite simply, and no special knowledge is required.

Microsoft Excel works with files. Each file is a kind of book consisting of sheets, where each sheet is a table. You can enter various data into the cells of these tables: letters, symbols, words, numbers. This data can be sorted, copied, moved. You can also perform other operations with data: text, logical, mathematical... Data can also be presented in a visual form - using graphs and diagrams.

Create an Excel file

Click on the button Start in the lower left corner of the computer, select All programs, find Microsoft Office(if you have it installed), click on it, select Microsoft Office Excel, and launch by double clicking.

After this, to create excel file, click on the large round button with squares in the upper left corner. In the window that appears, select Save as. The computer will open a new window with the contents of your computer, in which you select a folder to save your file. In line File name, where the default name is Book 1, place the cursor and write a name for your future Excel file. There is no need to write an extension - it will be included in the name automatically. In the window below, where File type, leave Excel workbook.

While working on a file, save it periodically so that if your computer crashes or freezes, your work will not be lost. For subsequent saves, press the round button again and select

Excel file structure. Sheets

Excel file- a kind of book that consists of sheets. You can switch between sheets by clicking on the corresponding sheet below, or on the arrows Forward And Back to the left of the sheet tabs (at the bottom of the program’s working window). There can be a lot of sheets in a book, they may not even be visible, and then you can switch between them only with the help of arrows.

Every Excel sheet- separate table. Using the icon to the right of the sheet tabs, you can insert new sheets. Sheets can also be renamed, deleted, and moved. To do this, you either right-click on the sheet name. and select the desired operation in the window, or in the menu home select the items: Insert - Insert a sheet, Delete - Delete a sheet, Format - Rename a sheet, Format - Move or copy a sheet. You can also rearrange sheets by dragging the sheet tab to the right or left.

Now that you have learned how to create Excel files, Let's look at working with tables and cells in this program.

You can get more detailed information in the “All courses” and “Utilities” sections, which can be accessed through the top menu of the site. In these sections, articles are grouped by topic into blocks containing the most detailed (as far as possible) information on various topics.

Sharing in Microsoft Excel allows multiple users to work with one file at once. Ten to twenty people on different computers simultaneously enter some data into one document. Where certain information is located, certain formulas work.

The “main user” has the ability to monitor the actions of the working group, add/remove members, and edit conflicting changes. How to set up collaboration in Excel.

Features of working with a shared file

Not all tasks can be performed in a shared Excel workbook.

• Create Excel tables.
• Create, edit or view scripts.
• Delete sheets.
• Merge or split cells.
• Work with XML data (import, add, update, delete, etc.).

Exit: disable sharing - perform a prohibited task - enable access again.

Sharing also limits a number of tasks for participants:

Unacceptable	Really
Insert or delete a group of cells	Add a row or column
Add or change conditional formats	Work with existing formats
Enable or change the Data Validation tool	Work with existing scan settings
Create or edit charts, summary reports	Work with existing charts and pivot tables
Insert or edit pictures and graphics	View existing pictures and graphics
Insert or change hyperlinks	Follow the available hyperlinks
Assign, edit or delete passwords	Existing passwords work
Put or remove protection for sheets and books	Existing protection works
Group, structure data; insert sublevels	Work with existing groups, structures and sublevels
Record, edit, or view macros	Run existing macros that are not associated with unavailable tasks
Change or delete array formulas	Use existing formulas
Add new information to the data form	Search for information in data form

How to share an Excel file?

First, we decide which book we will “open” for editing by several participants at once. We create a new file and fill it with information. Or open an existing one.

1. Go to the “Review” tab. Book Access dialog box.
2. File access control - editing. Check the box next to “Allow multiple users to edit the file at the same time.”
3. Head over to the More Info tool to configure your multi-user editing options.
4. Click OK. If we open public access to a new book, we choose its title. If sharing is intended for an existing file, click OK.
5. Open the Microsoft Office menu. Select the “Save As” command. We select the save file format that will work on all user computers.
6. As a saving location, select a network resource/network folder that will be opened by the intended participants. Click “Save”.

Attention! You cannot use a web server to save the shared file.

1. Data tab. "Connections".
2. Change links/change links. If this button is missing, there are no associated files in the sheet.
3. Go to the “Status” tab to check the existing connections. The OK button indicates that the connections are working.

Open a shared workbook

1. Open the Microsoft Office menu.
2. Click “Open”.
3. Select a shared book.
4. When the book is open, click on the Microsoft Office button. Go to the “Excel Options” tab (at the bottom of the menu).
5. “General” - “Personal settings” - “User name”. Enter identification information (name, nickname).

All. You can edit information or enter new information. After work - save.

It happens that when you open an Excel workbook with shared access to a file, the message “File locked” appears. Can't save. When you open it again, it turns out that sharing is disabled. Possible causes of the problem:

1. Several users edit the same part of a document. For example, they enter different data into one cell. A blockage occurs.
2. While using a shared file, a log of changes is kept (who entered, when, what they did). The book is growing. It starts to glitch.
3. They removed one of the users, but so far they have not told him about it. Then the blocking can only appear on his computer.

What you can do if file sharing is blocked:

1. Clear or delete the change log.
2. Clear file contents.
3. Cancel and then reactivate sharing.
4. Open xls workbook in OpenOffice. And save it again in xls.

It has been noticed that the “File Locked” entry appears less frequently in newer versions of Excel.

How to delete a user

1. On the “Review” tab, open the “Book Access” menu.
2. In the “Edit” section we see a list of users.
3. Select a name and click “Delete”.

Verify that users are finished with the file before deleting.

How to turn off sharing mode in Excel

1. “Review” tab - “Corrections” - “Select corrections”.
2. Set the “Corrections” parameters. In terms of time – “everything”. The checkboxes opposite “User” and “In range” are unchecked. On the contrary, “make changes on a separate sheet” is worth it. Click OK.
3. The Change Log will open. It can be saved either.

To disable sharing of an Excel file, on the Review tab, click Workbook Access and uncheck the box next to Allow multiple users to edit the file.

There should be one user left on the list - you.

Hello friends. Today I will tell you how to create an Excel file, open an existing one, save it and close it.

Each Excel workbook is stored in a separate file. Therefore, it is very important to be able to handle files correctly. Here I will describe several ways to perform actions with documents. I advise you to try each and choose which one is the most convenient, or maybe you will use many of them.

I quote all the calculations on this blog from Microsoft Office 2013. If you are using a different version, the appearance of some commands and windows may be slightly different, but their general meaning remains the same. If you do not find the described tools in your version of the program, ask in the comments or through the feedback form. I will definitely answer your questions.

Creating an Excel document

If you don't have Excel open yet, click on the MS Excel shortcut on the desktop or in the menu Start. After loading Excel, a start window will appear with a choice of templates. To create a new document, click on one of them, or select Blank Workbook.

Excel start window

If MS Excel is already running, for creating:

1. Press the key combination Ctrl+N. After clicking, a new workbook will be immediately created
2. Execute Ribbon Command File – Create. Its execution will lead to the opening of the start window, where you can create a file from the template, or a blank workbook.

How to open an Excel document

If Excel is not yet running To open the created file, find it in Windows Explorer and double-click on it. MS Excel will be launched and the document you selected will immediately open.

If the program is already running, there are several ways to open a workbook:

If you select the Computer - Browse location in the Open window, an Explorer window will open where you can select a filter for the file to open, as well as the opening method:

• Open– opens the selected Excel file for editing
• Open for reading– opens the file without editing
• Open as copy– creates a duplicate document and opens it with the ability to edit it
• Open in browser– if such a feature is supported, opens the workbook in an Internet browser
• Open in Protected View– opens a document using Protected View mode
• Open and restore– the program will try to restore and open a file that was closed abnormally without saving

Opening a file from disk

Saving an Excel document

Although Microsoft Excel has good autosave and data recovery tools, I recommend getting into the habit of saving your workbook from time to time, even if you are not finished working on it. At a minimum, you will feel more confident that the results of your work will not be lost.

1. Use the keyboard shortcut Ctrl+S
2. Use the key combination Shift+F12, or F12 (to save the document under a new name)
3. Click Save on the Quick Access Toolbar
4. Execute the ribbon command File – Save, or File – Save As (if you want to save the book as a new document)

If this is the first time you've saved your workbook, either of these commands will open the Save As window, where you can choose a save location, file type, and file name. To do this, click the Browse button.

If you saved the document previously, the program will simply save the file over the last saved version.

How to close an Excel workbook

When you are finished working with a file, it is better to close it to free up system memory. You can do this in these ways:

• Click on the cross(x) in the upper right corner of the program window
• Run command File – Close
• Double click on the icon system menu in the upper left corner of the window
  Excel system menu icon
• Use the key combinations Ctrl+W, or Alt+F4

If there are unsaved changes in the file at the time of closing, the program will ask what to do:

• Save– save all changes and close the document
• Don't save– close the workbook without saving
• Cancel– do not close the file
  Closing an Excel workbook

That's all the ways to handle Excel files. And in the next post I will tell you how to set up autosave for your workbook. See you!

As part of the first material on Excel 2010 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 data in them.

Table of contents

• Introduction
• Interface and control
• Data entry and editing
• Data formatting
• Cell Data Format
• Conclusion

Introduction

I think I won’t be wrong if I say that the most popular application included in the Microsoft Office package is the test editor (processor) Word. However, there is one more program that any office worker rarely does without. Microsoft Excel (Excel) refers to software products called spreadsheets. Using Excel, in a visual form, you can calculate and automate calculations for almost anything, from a personal monthly budget to complex mathematical and economic-statistical calculations containing large volumes of data.

One of the key features of spreadsheets is the ability to automatically recalculate the values ​​of any required cells when the contents of one of them change. To visualize the obtained data, you can create various types of charts, pivot tables and maps based on groups of cells. At the same time, spreadsheets created in Excel can be inserted into other documents, as well as saved in a separate file for later use or editing.

Calling Excel simply a “spreadsheet” would be somewhat incorrect, since this program contains enormous capabilities, and in terms of its functionality and the range of tasks it can solve, this application can perhaps surpass even Word. That is why, as part of the “Excel for Beginners” series of materials, we will only get acquainted with the key capabilities of this program.

Now that the introductory part is over, it's time to get down to business. In the first part of the series, for better assimilation of the material, as an example, we will create a regular table reflecting personal budget expenses for six months like this:

But before we start creating it, let's first look at the basic elements of Excel's interface and controls, and also talk about some basic concepts of this program.

Interface and control

If you are already familiar with the Word editor, then understanding the Excel interface will not be difficult. After all, it is based on the same Ribbon, but only with a different set of tabs, groups and commands. At the same time, to expand the work area, some groups of tabs are displayed only when necessary. You can also minimize the ribbon altogether by double-clicking on the active tab with the left mouse button or pressing the key combination Ctrl+F1. Returning it to the screen is done in the same way.

It is worth noting that in Excel, for the same command, there can be several ways to call it at once: through the ribbon, from the context menu, or using a hotkey combination. Knowledge and use of the latter can greatly speed up work in the program.

The context menu is context-sensitive, meaning its content depends on what the user is doing at the moment. The context menu is called by right-clicking on almost any object in MS Excel. This saves time because it displays the most frequently used commands for the selected item.

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

In the window that opens, in the menu on the right, select the desired tab and click on the button Create a 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. There is a button to cancel erroneous actions Reset, which returns the tab settings to the initial ones.

You can also add the most frequently used commands to Quick Access Toolbar located in the upper left corner of the program window.

You can do this by clicking the button Customizing the Quick Access Toolbar, where it is enough to select the desired command from the list, and if the necessary one is not in it, click on the item Other commands.

Data entry and editing

Files created in Excel are called workbooks and have the extension "xls" or "xlsx". In turn, the workbook consists of several worksheets. Each worksheet is a separate spreadsheet, which can be interconnected if necessary. The active workbook is the one you are currently working with, for example, entering data into.

After launching the application, a new book is automatically created with the name “Book1”. By default, a workbook consists of three worksheets named "Sheet1" through "Sheet3".

The workspace of an Excel sheet is divided into many rectangular cells. Cells merged horizontally make up rows, and cells merged vertically make up columns. To be able to study a large amount of data, each worksheet of the program has 1,048,576 rows numbered by numbers and 16,384 columns designated by letters of the Latin alphabet.

Thus, each cell is the intersection of various columns and rows on the sheet, forming its own unique address, consisting of the letter of the column and the number of the row to which it belongs. For example, the first cell name is A1 because it is at the intersection of column "A" and row "1".

If the application is enabled Formula bar, which is located immediately below Ribbon, then to the left of it is Name field, where the name of the current cell is displayed. Here you can always enter the name of the cell you are looking for to quickly navigate to it. This feature is especially useful in large documents containing thousands of rows and columns.

Also, to view different areas of the sheet, scroll bars are located at the bottom and right. You can also navigate around the Excel workspace using the arrow keys.

To start entering data into the desired cell, you need to select it. 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 you enter will appear in the selected cell.

When entering data into a cell, you can also use the formula bar. To do this, select the desired cell, and then click on the formula bar field and start typing. In this case, the entered information will be automatically displayed in the selected cell.

After finishing entering data, press:

• Press the “Enter” key - the next active cell will be the cell below.
• Press 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, double-click on it with the left mouse button. Move the blinking cursor to the desired location to make the necessary edits. As with many applications, you use the arrow, Del, and Backspace keys to delete and make corrections. If desired, all necessary edits can be made in the formula bar.

The amount of data you will enter into a cell is not limited to the visible part of it. That is, the cells of the program’s working field can contain either one number or several paragraphs of text. Each Excel cell can hold up to 32,767 numeric or text characters.

Formatting Cell Data

After entering the row and column names, we get a table that looks like this:

As can be seen from our example, several names of expense items “went” beyond the boundaries of the cell, and if the neighboring cell(s) also contains some information, then the entered text partially overlaps it and becomes invisible. And the table itself looks rather ugly and unpresentable. Moreover, if you print such a document, the current situation will remain - it will be quite difficult to make out what is what in such a table, as you can see for yourself from the figure below.

To make a spreadsheet document more neat and beautiful, you often have to change the sizes of rows and columns, the font of the cell contents, its background, align text, add borders, etc.

First, let's tidy up the left column. Move the mouse cursor to the border of columns “A” and “B” in the line where their names are displayed. When changing the mouse cursor to a characteristic symbol with two arrows in different directions, press and hold the left key and drag the dotted line that appears in the desired direction to expand the column until all the names fit within one cell.

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

If you need to set the exact sizes of rows and columns, then on the tab home in Group Cells select item Format. In the menu that opens, use the commands Line height And Column width You can set these parameters manually.

Very often it is necessary to change the parameters of several cells or even an entire column or row. In order to select an entire column or row, click on its name at the top or its number at the left, respectively.

To select a group of adjacent cells, circle them with the cursor and hold down the left mouse button. If you need to select scattered fields of the table, then press and hold the “Ctrl” key, and then click on the necessary cells.

Now that you know how to select and format multiple cells at once, let's center the month names in our table. Various commands for aligning content within cells are found on the tab home in a group with a self-explanatory name Alignment. Moreover, for a table cell this action can be performed both relative to the horizontal and vertical directions.

Circle the cells with the names of the months in the table header and click on the button Align Center.

In Group Font on the tab home you can change the font type, size, color and style: bold, italic, underlined, and so on. There are also buttons for changing the cell borders and its fill color. All these functions will be useful to us to further change the appearance of the table.

So, first, let's increase the font of the names of the columns and columns of our table to 12 points, and also make it bold.

Now, first select the top row of the table and set it to a black background, and then in the left column to cells A2 to A6 - dark blue. You can do this using the button Fill color.

You've probably noticed that the color of the text in the top line has merged with the background color, and the names in the left column are hard to read. Let's fix this by changing the font color using the button Text color on white.

Also using the already familiar command Fill color We gave the background of the even and odd number lines a different blue hue.

To prevent the cells from merging, let's define boundaries for them. Defining boundaries occurs only for the selected area of ​​the 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 everyone in the same group Font.

The menu that opens displays a list of quick commands with which you can choose to display the desired boundaries of the selected area: bottom, top, left, right, outer, all, etc. It also contains commands for drawing borders manually. At the very bottom of the list is the item Other borders allowing you to specify in more detail the necessary parameters of cell boundaries, which we will use.

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

As a result, using a set of commands of just one group Font we transformed the unsightly appearance of the table into a completely presentable one, and now knowing how they work, you can independently come up with your own unique styles for designing spreadsheets.

Cell Data Format

Now, in order to complete our table, we need to properly format the data that we enter there. Let us remember that in our case these are monetary expenses.

You can enter different types of data into each cell of the spreadsheet: text, numbers, and even graphics. That is why in Excel there is such a thing as a “cell data format”, which serves to correctly process the information you enter.

Initially, all cells have General format, allowing them to contain both text and digital data. But you have the right to change this and choose: numeric, monetary, financial, percentage, fractional, exponential and formats. In addition, there are formats for date, time, postal codes, telephone numbers and personnel numbers.

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

Select the cells in the table containing information on monthly expenses. On the ribbon in the tab home in Group Number click the arrow next to the field Number Format, after which a menu will open with a list of the main available formats. You can select the item Monetary right here, but for a more complete overview we will select the very bottom line Other number formats.

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

Having selected the currency format, at the top of the window you can see how the value will look in the table cells. Just below mono set the number of decimal places to display. To prevent pennies from cluttering up the table fields, we will set the value here to zero. Next, you can select the currency and display of negative numbers.

Now our training table has finally taken its final form:

By the way, all the manipulations that we did with the table above, that is, formatting cells and their data, can be performed using the context menu by right-clicking on the selected area and selecting Cell Format. In the window that opens with the same name, there are tabs for all the operations we have considered: Number, Alignment, Font, Border And Fill.

Now, when you finish working in the program, you can save the result. All these commands are in the tab File.

Conclusion

Probably, many of you will ask the question: “Why create this kind of tables in Excel, when the same thing can be done in Word using ready-made templates?” That’s right, but it’s impossible to perform all sorts of mathematical operations on cells in a text editor. You almost always enter the information into the cells yourself, and the table is only a visual representation of the data. And creating large tables in Word is not very convenient.

In Excel, the opposite is true: tables can be as large as desired, and cell values ​​can be entered either manually or automatically calculated using formulas. That is, here the table acts not only as a visual aid, but also as a powerful computational and analytical tool. Moreover, cells can be interconnected not only within one table, but also contain values ​​obtained from other tables located on different sheets and even in different books.

You will learn how to make a table “smart” in the next part, in which we will get acquainted with the basic computing capabilities of Excel, the rules for constructing mathematical formulas, functions and much more.

Undoubtedly, almost every user uses Excel when creating tables, partly because it is easy to use, has an intuitive interface, and also has a powerful tool for creating colorful and professional diagrams. Everyone can easily learn the basics of working in Excel.

Let's consider the procedures for handling working documents. Using Excel, you can create a wide variety of documents. Worksheets can be used to create tables, calculate statistical estimates, manage a database, and create charts. For each of these applications, Excel can create a separate document, which is saved to disk as a file.

The file may contain several interconnected worksheets that form a single three-dimensional document (notepad, work folder).

1) Create a new document.

To create a new document from the File menu, you need to call the New directive. A document with the name Book2 will appear on the screen: Excel assigns the name Book to new documents with the addition of the current serial number.

To load a file with a working document located there from disk, you need to call the Open directive from the File menu.

In this window, in the Drives field, you need to specify the drive, and in the Directories field, select the directory where your file is located.

If the selection was made correctly, a list of file names will appear in the left field, among which the desired file should be located. If you click on the name of this file, it will appear in the File Name field. After this, you need to close the dialog box by clicking the OK button or double-clicking on the name of the file you are looking for.

3) Saving the document.

The first time you save your document, you need to call the Save As... directive from the File menu. After this, a dialog box will open in which you need to specify the name of the file to be saved, as well as the drive and directory in which it should be located. Excel by default offers a standard name (Book[ordinal number]), which the user can replace with any other. The default file extension .XLS offered by Excel should not be changed. After all settings have been made, you need to close the dialog box by clicking on the OK button.

4) Adding worksheets.

Add directives are located in the Insert menu. The user can add the following types of elements to the document:

• - worksheets for creating tables;
• - diagrams (as a table element or on a separate sheet);
• - a worksheet for recording a macro in the form of a program module (in the Excel4.0 macro language or in the VisualBasic language);
• - worksheet for creating a dialog box.

A new sheet is always inserted before the active worksheet. If the sheet is intended to create a table, then regardless of the position it occupies, it will have the name Sheet17 with a subsequent increase in the number when adding new tables. New charts located on separate worksheets are numbered starting with Chart1, etc. If you need to delete a worksheet, you need to right-click the context menu and execute the delete directive.

5) Moving worksheets.

Place the mouse pointer on the spine of the worksheet you want to move and right-click to open the context menu. Using the MoveorCopy directive, open a dialog box with the same name and specify in it the new position of the sheet to be rearranged. Close the Moveor Copy window by clicking the OK button, and the worksheet will take its new position. If you enable the optional CreateaCopy button, then this worksheet will remain in its previous position, and its copy will take the new position. excel spreadsheet program editor

The name of the copy of the sheet will be formed by adding a serial number to the name of the copied sheet, for example, Sheet1(2)

6) Renaming worksheets.

Place your mouse pointer on the spine of the worksheet you want to rename and right-click. A context menu will open in which, using the Rename directive, you need to open the RenameSheet dialog box. This window can also be opened by double-clicking the left mouse button on the worksheet name. In the Name input field, enter a new name for the sheet, which must contain no more than 31 characters, including spaces. After entering the name, click OK and the new worksheet name will appear in the name index.

7) Correction of row height and column width.

First of all, the table row or column to be adjusted must be marked. To do this, you need to left-click on the number (coordinate) of a row or column. The Format menu contains the Row and Column submenus. Selecting one of these submenus opens the next level menu. In the Column submenu, call the Width directive, then a dialog box will open in which the user can specify the width of the column. One character can be used as a unit of measurement.

Correction can also be performed using the mouse manipulator. To do this, the mouse pointer must be positioned on the boundary between line numbers or column addresses. The mouse pointer changes to a double-headed arrow. If you now press the left mouse button and, without releasing it, move the mouse pointer a little, you can see a dashed line that shows the offset of the line border. Move this line to the desired position and release the mouse button, then a new line border will appear in the table. If you double-click on the row number (column address), the height (width) of this row (column) will be automatically adjusted to its contents.

Why work if someone has already done the work for you?

This question is valid for standard Excel documents that have already been developed by Microsoft. Let's look at how you can use the provided templates in Excel.

To access document templates installed with Office, you should:

1. On the File tab, select the New command.
2. In the Available templates group, select Sample templates (Fig. 1) and indicate the template you like (however, there are quite a few preset templates. There’s not much for the eye to focus on).
3. Click the Create button, as a result of which a new Excel workbook will be created based on the template you selected.

I would like to note that regular Office documents (Word and Excel) are also created based on the provided service templates.

The latter are taken as a basis every time a new document is created. Do you want to change the settings of newly created documents? Change the main template.

For example, you no longer have the strength to look at the Calibri font, 11, installed by default. We were tired of changing it every day to Calibri, 12, which is pleasing to the eye. How can I fix it? Very simple!!!

To do this, just set the desired settings in the newly opened document and save it under the name CSS (this is the default Excel template), selecting the value in the File type field - Excel template(Fig. 2).

In addition to those described, you can also use templates located on the Microsoft website (provided that your computer is connected to the Internet).

To download the template from the Microsoft website you need:

1. On the tab File select a team Create.
2. In a group Office.com Templates select the group of templates you are interested in – the templates available in this group will be displayed in the viewing area.
3. Select with the mouse the template that we plan to download to your computer, for example Timetable(Fig. 3), and press the button Download.

After downloading, the template will be opened on an Excel worksheet (Fig. 4) in the form of a ready-made table with some data. If necessary, they should be replaced with your own values ​​or filled in the corresponding cells. And your child will have beauty on the wall so that he doesn’t have to look at the diary every time.

Hello friends. Today I will tell you how to create an Excel file, open an existing one, save it and close it.

Each Excel workbook is stored in a separate file. Therefore, it is very important to be able to handle files correctly. Here I will describe several ways to perform actions with documents. I advise you to try each and choose which one is the most convenient, or maybe you will use many of them.

I quote all the calculations on this blog from Microsoft Office 2013. If you are using a different version, the appearance of some commands and windows may be slightly different, but their general meaning remains the same. If you do not find the described tools in your version of the program, ask in the comments or through the feedback form. I will definitely answer your questions.

Creating an Excel document

If you don't have Excel open yet, click on the MS Excel shortcut on the desktop or in the menu Start. After loading Excel, a start window will appear with . To create a new document, click on one of them, or select Blank workbook.

Excel start window

If MS Excel is already running, for creating:

1. Press the key combination Ctrl+N . After clicking, a new workbook will be immediately created
2. Execute Ribbon Command File – Create . Its execution will lead to the opening of the start window, where you can create a file from the template, or a blank workbook.

How to open an Excel document

If Excel is not yet running To open the created file, find it in Windows Explorer and double-click on it. MS Excel will be launched and the document you selected will immediately open.

If the program is already running, there are several ways to open a workbook:

If you select a location in the Open window Computer - Review, an explorer window will open where you can select a filter for the file to be opened, as well as the opening method:

• Open– opens the selected Excel file for editing
• Open for reading– opens the file without editing
• Open as copy– creates a duplicate document and opens it with the ability to edit it
• Open in browser– if such a feature is supported, opens the workbook in an Internet browser
• Open in Protected View– opens a document using Protected View mode
• Open and restore– the program will try to restore and open a file that was closed abnormally without saving

Saving an Excel document

Although Microsoft Excel has good autosave and data recovery tools, I recommend getting into the habit of saving your workbook from time to time, even if you are not finished working on it. At a minimum, you will feel more confident that the results of your work will not be lost.

1. Use the keyboard shortcut Ctrl+S
2. Use the key combination Shift+F12, or F12 (to save the document under a new name)
3. Click Save on the Quick Access Toolbar
4. Execute Ribbon Command File - Save, or File - Save As(if you want to save the book as a new document)

If this is your first time saving your workbook, either of these commands will open the Save As window, where you can choose the save location, file type, and file name. To do this, click the Browse button.

Save As window

If you saved the document previously, the program will simply save the file over the last saved version.

How to close an Excel workbook

When you are finished working with a file, it is better to close it to free up system memory. You can do this in these ways:

If there are unsaved changes in the file at the time of closing, the program will ask what to do:

That's all the ways to handle Excel files. And in the next post I will tell you how to use your workbook. See you!

Microsoft Excel 2007 program is one of the two most popular programs in the Microsoft Office suite. The most popular, of course, is . Most recently, the latest version of the program was, but now both 2007 and 2010 Excel have appeared. Let's consider How work in Excel 2007. This program is designed for creating tables, presenting series of numbers in a visual form using charts and graphs. Also Microsoft Excel program used to carry out calculations and perform mathematical tasks of varying complexity: from simplifying routine mathematical operations to performing complex calculations. The most important thing is that all this can be done quite simply, and no special knowledge is required.

Microsoft Excel works with . Each file is a kind of book consisting of sheets, where each sheet is a table. You can enter various data into the cells of these tables: letters, symbols, words, numbers. This data can be sorted, copied, moved. You can also perform other operations with data: text, logical, mathematical... Data can also be presented in a visual form - using graphs and diagrams.

Create an Excel file

Click on the button Start in the lower left corner of the computer, select All programs , find Microsoft Office(if you have it installed), click on it, select Microsoft Office Excel, and launch by double clicking.

After this, to create excel file, click on the large round button with squares in the upper left corner. In the window that appears, select Save as . The computer will open a new window with the contents of your computer, in which you select a folder to save your file. In line File name, where the default name is Book 1, place the cursor and write a name for your future Excel file. There is no need to write an extension - it will be included in the name automatically. In the window below, where File type, leave Excel workbook .

After you press the button Save, the Excel file will be created in the specified location on your computer. Now you no longer need to go to Start - All Programs : All you need to do is find this file and double-click it.

While working on a file, save it periodically so that if your computer crashes or freezes, your work will not be lost. For subsequent saves, press the round button again and select Save, or use the small icon Save next to this button.

Excel file structure. Sheets

Excel file- a kind of book that consists of sheets. You can switch between sheets by clicking on the corresponding sheet below, or on the arrows Forward And Back to the left of the sheet tabs (at the bottom of the program’s working window). There can be a lot of sheets in a book, they may not even be visible, and then you can switch between them only with the help of arrows.

Every Excel sheet- separate table. Using the icon to the right of the sheet tabs, you can insert new sheets. Sheets can also be renamed, deleted, and moved. To do this, you either right-click on the sheet name. and select the desired operation in the window, or in the menu home select items: Insert - Insert a sheet, Delete - Delete a sheet, Format - Rename a sheet, Format - Move or copy a sheet. You can also rearrange sheets by dragging the sheet tab to the right or left.

Now that you have learned how to create Excel files in this program.

You can get more detailed information in the “All courses” and “Utilities” sections, which can be accessed through the top menu of the site. In these sections, articles are grouped by topic into blocks containing the most detailed (as far as possible) information on various topics.

You can also subscribe to the blog and learn about all new articles.
It does not take a lot of time. Just click on the link below: