How to save a word table. Saving a book in a different file format

For those who constantly work with Microsoft Excel, you often have to wonder how to correctly copy table data while preserving formatting, formulas or their values.

How to insert a formula into Excel spreadsheet and save the table format? After all, when solving this problem, you can save a lot of time. To do this we will use the function " Special insert"is a simple tool that allows you to quickly solve complex problems and master general principles its use. Using this simple tool allows you to quickly bring all tables to a uniform format and get the result you need.

How to copy a table with column width and row height

Let's say we have a table like this, the format of which needs to be preserved when copied:

When copying to another sheet using the usual Ctrl+C – Ctrl+V method. We get an undesirable result:

Therefore, you have to manually “expand” it to bring it into comfortable view. If the table is large, then you will have to “tinker” for a long time. But there is a way to significantly reduce temporary losses.

Method 1: Use a special insert

She received the original parameters and looks perfectly accurate.

Method 2: Select columns before copying

Secret this method The point is that if you select its columns along with their headers before copying a table, then when pasting, the width of each column will also be copied.

For each case it is rational to use your own method. But it is worth noting that the second method allows us not only to quickly transfer the table along with the format, but also copy the height of the rows. After all, there is no “line height” option in the Paste Special menu. Therefore, to solve this problem you should act like this:

Inserting formula values ​​while maintaining table format

Although the special insert is not perfect, you should not underestimate its capabilities. For example, how to insert a formula value into an Excel table and preserve the cell format.

To solve this problem, you need to perform 2 operations using Paste Special in Excel.

Since the copied range is still on the clipboard after copying, we immediately call the paste special again and select the “formats” option. Click OK.

We have inserted the formula values ​​into the table and saved the cell formats. As you guessed, you can also do a third operation to copy the width of the columns, as described above.

Helpful advice! To avoid performing the second operation, you can use the “Format by Sample” tool.

Microsoft Excel provides users with virtually unlimited possibilities for calculating simple functions and performing a number of other procedures. Using the program allows you to set formats, save cell values, work with formulas, transfer and change them in a way that is convenient for users.

In this tutorial 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 a workbook for the first time and select 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 programs If any failure occurs, you can restore the autosaved file.

1. Open a workbook 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 Versions. Click on the file to open it.
4. A yellow warning will appear under the book's ribbon. To restore this version of the book, click Restore and then OK.

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

If you don't see the file you're looking for, or you're looking for a file that doesn't have previous versions, then you can view all autosaved files by clicking the Manage Versions button and selecting Recover Unsaved Workbooks from the drop-down menu.

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

To save a file as a PDF:

Saving your book as Adobe Acrobat The document, called PDF, can be especially useful if recipients don't have or use Excel. Saving as a PDF allows recipients to see the contents of the book, although they will not be able to edit it.

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

This question arises if you come across some data presented in the form of a table on the Internet and want to save it in the format Microsoft Word(possibly pre-edited). If you simply open a saved HTML page in Word and then try to save it “as Word document", then you will retain the original page format, which is hardly acceptable as an independent document, and you will be tortured to clean it of all unnecessary things.

The simplest thing is to transfer the table via 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 exactly the table without capturing any unnecessary elements - when you hover the cursor 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 click on the keyboard shortcut +). But the table style will remain the same as it was in the original document - especially annoying is the HTML fashion for a “convex” double frame, and through the usual Format | Borders and Shading (in new versions: Designer | Borders or Designer | 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 selecting a new style for it. In Word 2003, this is done through a menu with the non-obvious name Table | Auto-format the table and then select one of the frame styles from the list (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). There is also a very simple table with thin black lines.

Rice. H.3. Office 2007 Table Styles

Usually this is not enough - you also have to change the font, set it to black, remove hyperlinks (color 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 this is still incomparably simpler than creating such a table from scratch, moving it cell by cell.

In most cases, you will probably save your books in the current file format (XLSX). But sometimes you may need to save the workbook in a different format, for example for more early version 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 functionality may not be saved.

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

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

If you have an Excel 97-2003 workbook open but don't need to store it in that file format, simply 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

Formats text files

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

Other file formats

File formats that use the clipboard

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

File formats not supported in Excel 2013

The following file formats are no longer supported, so you will not be able to open files in these formats or save files in these formats.

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

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

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

You can save an Excel 2007 and later workbook in the format of previous versions of Excel, in a file text format, as well as in other formats such as PDF files and XPS. Typically saving occurs in XLSX format, but the default file format used for saving can be changed. If you often use the command Save as, you can add it to your 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 unique to Excel 2007 and later versions will be lost. additional information See the article Using 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.

On the tab File select team Save as.

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

In the dropdown list 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 active worksheet type (workbook sheet, chart sheet, or other sheet types), different file formats will be available for saving.

Saving a different file format in Excel 2007 and later

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: When you save a workbook created in an earlier version of Excel in the Excel 2007 or later workbook format, some functionality and formatting may be lost. Information about unsupported Excel functions 97–2003 see article

PDF - was developed as a format for presenting books and magazines on computers. In everyday life and business, it is most often used to create, so to speak, unchangeable documents. For example, you have created a table with tariffs or an agreement and you need to send it to the client, so that the client does not change anything there, it is best to save it in PDF. After all, you can easily use Excel, even if you protect it with a password.

XML— was developed as a language convenient for processing documents by programs and convenient and understandable for a person to work with a document. You could say a format specially created for the Internet. Very often, exchanges between two programs take place through such a universal language. For example, automatic uploading from Access and loading into 1C.

The full list of available formats is shown in the picture:

As shown earlier, for saving Excel in PDF you need to go to the menu, select Save as - then select PDF or XPS (in the first picture).

XPS is also a special format for protecting the contents of a document, one might say an electronic sheet of paper.

Excel to JPEG or PNG

No for picture format special function saving, but this is quite easy to do using Windows.

First of all, almost every keyboard has special button Print Screen(screenshot), it is located to the right of F12. Most often something like PrtScn or Prt Sc is written on it.

After clicking this button, the screen image is saved and you can paste it anywhere: into a letter, into Word or into the Paint program. From Paint you can already save it as JPEG and PNG.

If you only need to copy active window, press Alt + PrtScn - described in more detail.

It's even easier to find the scissors program (starting in Windows 7 it's built-in). Start - all programs - Standard scissors are there - now you can select any fragment and immediately save it in in the required format drawing. Convenient - I recommend it to those who don’t use it.

If you have a MAC, press Shift + Command + 3 to take a screenshot

Save Excel to XML

Again, as shown in the large picture, left-click on Save As - then a saving window will open in the File type window, look for XML data (*.xml).

If an error occurs when saving, save in XML 2003 table format, also in the list. Most often this happens because XML document may not accept more than 65 thousand lines, and the 2003 format cuts them off!