Save everything. Saving data in Excel How to save a word table

Writing Excel spreadsheets to a computer is called saving. This is a process in which we make a file from a table and add it to the Local Disk. Then the file with the table can be opened on a computer, transferred to a USB flash drive, or sent over the Internet.

How to save an Excel spreadsheet

1 . Click on the inscription "File" in the upper left corner of the program.

If there is no such inscription, click on the round button with colored squares. She is also in the upper left corner of Excel.

2. Select "Save As" from the list.

3. A small window will open. Through it, you need to select a place on the computer where the table should be written. This can be done through the left side.

Then I open the "Reports" folder.

If the required folder is not there, you can create it right in the window. To do this, click on the "New folder" button at the top.

I check if the location for saving is correct. It will be written at the top of the window.

4 . Type a name for your file or leave it as the computer suggests. The name can be changed at the bottom, in the "File name" line.

The window will disappear - this will mean that the file with the table has been written to the specified location.

Now you can close Excel and try to find the recorded file on your computer. To do this, open the location that you chose when saving. There should be a file with the specified name or the standard name "Book 1".

Important! When compiling a table, it is better to save it from time to time. To do this, use the following button in the upper left corner of the program:

By clicking on it, the table will be overwritten. That is, the previously recorded version will be replaced by a new one. This is necessary in order not to accidentally lose data. After all, if a failure occurs in the computer (freeze, power outage), then there is a high probability of losing the table.

This question arises if you stumble upon some data presented in the form of a table on the Internet and want to save it in Microsoft Word format (possibly after editing it). If you just open a saved HTML page in Word and then try to save it "as a Word document", then you will retain the original page format, which is hardly acceptable as a standalone document, and you will be tortured to clean it of all unnecessary.

The simplest thing is to transfer the table through the clipboard. This can be done directly from any browser or by first saving the page to a disk file and then opening it in Word. In the latter option, it is easier to select the table without capturing any unnecessary elements - when you hover over the table, all versions of Word after XP show an icon next to the table in the upper left corner, when you click on it, the entire table will be selected (you can also press the keyboard shortcut +). But the style of the table will remain the same as it was in the original document - especially annoying is the fashion adopted in HTML for a "convex" double border, and through the usual menu Format | Borders and shading (in new versions: Design | Borders or Design | Borders | Borders and shading) Word stubbornly refuses to change it to a regular frame of simple lines.

You can change the appearance of the frame of such a table by choosing a new style for it. In Word 2003, this is done through a menu with an unobvious name Table | Auto-formatting of the table and subsequent selection from the list of one of the frame styles (the simplest is called Table Grid 1). In new versions, this is even easier, because several table styles are displayed directly on the Design tab, and the remaining several dozen are available through the lower button to the right of them (the cursor points to it in Fig. H.3). Including there is the simplest table with thin black lines.

Rice. H.3. Office 2007 table styles

Usually this is not enough - you still have to change the font, set it to black, remove hyperlinks (colored fonts when printed on a regular black and white laser printer will be displayed in ugly shades of gray in a fine grid), format paragraphs if necessary. But it is still incomparably easier than creating such a table from scratch by transferring it cell by cell.

In most cases, you will most likely save your books in the current file format (XLSX). However, sometimes you might want to save the workbook in a different format, such as for an earlier version of Excel, to a text file, or to a PDF or XPS file. Just remember that whenever you save a workbook in a different file format, some of its formatting, data, and functions cannot be saved.

The list of formats (also called file types) you can (and cannot open or save in the Excel 2013 file that appears at the end of this article.

Convert an Excel 97-2003 workbook to the current file format

If you've opened an Excel 97-2003 workbook but you don't need to store it in this file format, just convert the workbook to the current file format (XLSX).

On the menu File select team Intelligence.

Click the button Convert.

Excel Supported File Formats

In Excel 2013, you can open and save project files in the following formats.

Excel file formats

Text file formats

Note: If you save the workbook in any text format, all formatting will be lost.

Other file formats

File formats using the clipboard

If you copied the data to the clipboard in one of the following file formats, you can paste it into Excel using the command Insert or Paste special (home > Clipboard > Insert).

File formats not supported in Excel 2013

The following file formats are no longer supported, so you cannot open files in these formats or save files in these formats.

To work with book data in a software that is no longer supported, try the following:

Find a company on the Internet that makes file converters for formats not supported by Excel.

Save the book in a different file format that you can open in another program. For example, save the workbook to an XML spreadsheet or text file format that may be supported in another program.

You can save an Excel 2007 workbook and later in the format of previous versions of Excel, as a text file, and in other formats such as PDF and XPS files. Usually, saving is in XLSX format, but the default file format for saving can be changed. If you use the command often Save as, you can add it to the Quick Access Toolbar.

Saving an Excel workbook in a different file format

Important: If you save a workbook in a different version of Excel file format, formatting and features that are unique to Excel 2007 and later will be lost. For more information, see Use Excel with earlier versions of Excel.

Open the workbook in Excel that you want to save in a format suitable for use in another program.

In the tab File select team Save as.

Accept the name suggested in the field File name, or enter a new name for the book.

Dropdown File type select a format suitable for use in another program.

Use the arrows to scroll through the list and display more formats.

Note: Depending on the type of active sheet (book sheet, chart sheet, or other sheet types), different file formats will be available for saving.

Save a different file format in Excel 2007 and later format

Any file that opens in Excel 2007 and later can be saved in the current Excel workbook format (XSLX). This way you can take advantage of new features that are not supported in other file formats.

Note: If you save a workbook created in an earlier version of Excel in the Excel 2007 and later workbook format, some functionality and some formatting may be lost. For unsupported Excel 97-2003 features, see

In this lesson, you will learn how to use the Save and Save As commands, and you will also learn how to save a workbook in compatibility mode. Excel 97-2003, and how to save the book in the format PDF.

Whenever you create a new document in Excel, you need to know how to save it for later access and editing. Excel allows you to save documents in several ways.

To use the Save As command:

To use the Save command:

If you are saving the workbook for the first time and choose Save, the Save As dialog box appears.

To use Autosave:

Excel automatically saves your workbooks as you work to a temporary folder. If you forget to save your changes, or Excel has a crash, you can restore the autosaved file.

1. Open a book that was previously closed without saving.
2. Click the File tab and select Details from the pop-up menu.
3. If autosaved versions of your book exist, they will be shown in the section Versions... Click on the file to open it.
4. A yellow warning appears under the tape of the book. To restore this version of the workbook, click Restore and then OK.

By default, Excel automatically saves the workbook every 10 minutes. If you worked with the spreadsheet for less than 10 minutes and closed it without saving, or if there was a crash, Excel will not have time to autosave.

If you do not see the file you are looking for, or are looking for a file that does not have previous versions, then you can view all autosaved files by clicking the Version Control button and choosing Recover Unsaved Books from the drop-down menu.

To save the workbook in Excel 97-2003 Workbook format:

To save a file in PDF format:

Saving your workbook in the Adobe Acrobat Document format, called PDF, can be especially useful if the recipients don't have and don't use Excel. Saving in PDF format allows recipients to see the contents of the book, although they will not be able to edit it.

By default, Excel only saves the active sheet. If you have several sheets in your book, and you want to save them all in one PDF file, then click the Options button. The Options Dialog Box appears. Select Entire Book and press OK.

Saving data to Excel

Word users know that it is not enough to create text that is displayed on the monitor. It still needs to be saved on the hard disk of the computer so that it does not disappear after exiting the program. The same goes for Excel.

To save your work, choose from the menu File command Save or click the corresponding button on Toolbars . In the mini-explorer window that appears, select the folder where you want to save the Microsoft Excel workbook and write in the line File name working title, and in line File type choose Microsoft Excel workbook . Press the key Enter, and your table or chart will be saved in the folder you specified in the mini explorer.

If you want to save the already named file under a different name, select from the menu File command Save as and in the mini-explorer window, correct the file name to the new one. You can also save it to any other folder on your hard drive or floppy disk.

Do not forget to press the button from time to time during work.Save onToolbars Microsoft Excel to avoid data loss in the event of a program or computer malfunction. You can turn on the autosave function, which will automatically save the stages of your work at a time interval you specify.