Share an Excel file at the same time. Editing and formatting data in Excel worksheet cells
Representing data based on entering a description with tags or program settings. Open them for editing normally double click does not work. This is due to the fact that the association with the extension is not installed the right application, which is the default. But if you need to get a readable file in the form of a table with the ability to edit, you can open XML file in Excel. In this case, no converters are needed that can convert formats between themselves. The only caveat is that this feature is only available in Office versions 2003 and higher.
How to open XML in Excel: method one
Let's consider importing data to Excel based 2016 version. The first and easiest way is to initially run Excel program. When you start the application, instead of a greeting and logo, it will display a special login window, in which there is a line “Open other books” in the left menu.
After this, the browse item is used, and in the new window XML is selected as the opening format. After this, using the usual method we find required file and press the open button. In this case, it is recognized not as a text document containing descriptions and tags, but as a very ordinary table. Naturally, the data can be edited at your discretion, but more on that later.
How to open XML format in Excel: method two
Another proposed method is practically no different from the first. An XML file in Excel can be opened from the file menu or using the quick combination Ctrl+ O.
Again, the type of format to be opened is first selected, after which the desired file is found and the corresponding button is pressed.
Opening XML: Method Three
There are several more XML methods in Excel. So, in the 2016 version of the program you can use the menu top panel, where the “Data” section is selected, and then the button to obtain external data is pressed.
In the drop-down menu, you just need to select the “From Other Sources” section and use the line “From XML Import” in the new menu. This is followed by the standard procedure of searching for the desired file and then opening it.
Editing, saving and exporting
When using any of these methods, the user gets the table structure. Editing is done in the same way as it is done with standard files XLS. Sometimes, for ease of editing and saving data, it is advisable to use the developer menu.
In this case, you can import not all the contents of the XML file, but only what is really necessary, inserting information into the appropriate columns and rows, specifying the XML object as the data source. But to do this, you need to log into your account in the program itself using your registration with Microsoft.
You can save the changed file immediately in the original format by selecting the appropriate type from the list. From the file menu, if the object was saved in the “native” Excel format, you can select the export function, click on change file type and set XML as the final format.
If the user is too lazy to do such conversions, or in his work he uses a version of Office lower than version 2003, to open of this format in the form of a table you will have to use a special converter. There are quite a lot of such programs now offered. As a last resort, if this is not suitable, you can easily turn to specialized online services, where the format will be changed within a couple of tens of seconds. After completing these steps, all that remains is to download the finished result in XLS format to HDD, and then open it in Excel. However, in most cases such actions are not required, since in the same Office 2003 it is possible direct opening(import) XML format already provided initially. And it seems that few people today use outdated Microsoft office products.
Editing a table means changing the contents of cells and changing the structure of the table (adding, deleting rows or columns). Changing the appearance of the table, for example, the font used to display the contents of cells, the shading color of cells, and the appearance of cell borders is called formatting. Formatting tasks are discussed in the article Formatting a table in Excel.
To start working with an existing table, you need to load it into the Microsoft program Office Excel. There are several ways to do this.
If Microsoft program Office Excel is not running, then you need to open the folder in which the desired workbook is located and do double click left mouse button on the icon depicting a book.
Excel Cell Contents
In order to change the contents of a cell, you need to double-click the left mouse button in the selected cell or, using the cursor keys, place the active cell marker (frame) in this cell and press the key
How to add a row, column in an Excel table
When creating tables, you often need to add information to an already completed table, such as the name of a new employee. To do this, you must first insert a blank row into the table, and then enter the required data.
In order to insert an empty row between filled rows of a table, you first need to select the row before which the empty row should be inserted. To do this, left-click on the line number before which you want to insert an empty line. The line will be highlighted in color.
How to delete a row, column in Excel
To delete a row, you first need to select it by clicking on the row number of the sheet, and then click on the Delete button located on the Home -> Cells tab.
How to change column width in Excel
Quite often there is a need to change the width of a table column. This can be done in several ways.
The easiest way to change the column width is to use the mouse. To do this, place the mouse pointer in the sheet header on the right border of the column (the mouse pointer will take the form of a double-headed arrow), click left button and, holding it pressed, drag the column border to the right or left.
How to change row height in Excel
If you need to change the row height, just place the mouse pointer on the bottom border of the table row, press the left mouse button and, while holding the button pressed, move the border down or up.
Moving rows, columns, cells in Excel
Sometimes it becomes necessary to move several rows or columns of a table, for example, in order to change their order.
- In order to move a table fragment (a row, several rows, a column, several columns or a range of cells), you need to:
- Prepare the place where the fragment is to be inserted. Preparation consists of adding the required number of empty rows or columns to the table. For example, in order for the Qty and Price columns to appear before the Cost column, you need to insert two empty columns before this column.
Hi all! Very often, users, seeing a file with an xls extension, do not know how to open it. If you also encounter this problem, then let's figure it out together.
First, I propose to take a little look at what the xls format is, and then we will choose a program that can work with this type of file.
Xls is a data file format specially developed by Microsoft that contains information placed in special address cells, which in turn create a full-fledged table.
Upgraded version - xlsx format. It allows you to create files that are lighter in weight, but with advanced functionality.
As you probably already guessed, to open an xls file you need to use word processor Excel, if on your computer or mobile device there is no MS Office software package, then let's take a look alternative options than to open xls.
If your computer does not have installed package office programs from Microsoft, I suggest using alternative free options, which can not only replace Excel, but will also become a complete replacement for the MS Office package.
Open Office
Probably the most popular free analogue MS Office is Open Office. This product is distributed completely free of charge and can work with all popular office documents. The program interface is very similar to MS Office, but there are some functions that will take some getting used to. To open an xls file, you will need the Open Office Calc application, which is essentially the same Excel, only from a different developer. 
Among the disadvantages of this software package, I would like to note that it is not always high speed work, but for home use will fit perfectly.
You can download Open Office from the official website www.openoffice.org/ru/.
LibreOffice
Another free cross-platform software package with open source code. LibreOffice was created as a fork of OpenOffice back in 2010 and continues to be actively developed. LibreOffice can be installed on almost everything modern gadgets. The package includes programs for working with text, tables, presentations, graphics and databases.
To work with table files in xls format, LibreOffice provides the user with a Calc spreadsheet processor. 
The software package is perfect for both home use and for small organizations that do not want to pay money for licensed products.
Windows File Viewer
If you do not want to install a suite of office programs on your PC and you only need to open a file with tables once, then I present to your attention an excellent file viewer called File Viewer.
The main difference between this program and its analogues is that in addition to viewing files, it is possible to edit them. True, I don’t recommend abusing the editor’s functions. It’s better to trust word processors specially designed for these purposes. 
Note! File program Viewer is paid, to get acquainted with the program's functions for free you have only 10 days after installation, after which you will need to purchase a license.
You can download File Viewer on the official website at windowsfileviewer.com.
How to open xls file for Mac OS users
If you are as operating system If you use Mac OS, you can install the MS Office software package, which appeared relatively recently for this operating system. By the way, for some reason, on this OS, Exel is not at all to the taste of users and many use other solutions. If you are interested in learning about them, read below.
Apple Numbers
If you don’t yet know how to open xls, then I recommend the quite popular Apple program Numbers, designed specifically for Mac OS. The main advantage of the program is the very high speed of working with files. 
Also, when working with tables created in other programs, the formatting does not get lost and the cells do not move out. I think Apple Numbers will be indispensable program for users who constantly work with tables. You can download the application from the link - www.apple.com/ru/numbers/
Planamesa NeoOffice
Another open source product that was created specifically for a proprietary operating system Apple. This software package can work with all modern electronic documents. And it will do a great job with xls files, which you can view, edit and save. 
The program interface is very similar to MS Office, so users will not have any difficulty understanding all the tools on their own.
How to open xls using online services
If for some reason you are unable to install an office software package on your computer, then do not despair. It is possible to open xls file using popular online service ov from Yandex and Google. Let's look at each of them.
Using Yandex Disk to view spreadsheets
After you register in cloud storage, get 7 GB of cloud storage for free immediately. This will be quite enough for storing and editing electronic documents and small files.
How to open xls file on Android devices
For Android platforms on this moment created great amount office software packages that users can download from Play Market, but not all of them work stably and quickly. Therefore, we have to make a choice in favor of more optimized solutions that do not take up much space and work quickly.
Kingsoft WPS Office
An excellent cross-platform application that works quickly with text documents and tables.
The main difference between Kingsoft WPS Office and its analogues is that the applications have high operating speed and consume a minimum of resources. At the same time, they all have necessary functions to view and edit tables. 
The application interface is simple, which allows the user to quickly understand the functionality and comfortably work with documents.
No wonder Kingsoft WPS Office entered the top best apps for Android devices.
Open xls documents on Apple gadgets
There aren't many good ones for Apple device users. office applications. Previously, users of gadgets under iOS control used MS Excel, but now everything more people prefer online services. Since they do not require installation on the device, but still provide the same functions.
If for some reason you need to install an office software package, I recommend the following solution.
MobiSystem Office Suite Pro
One of the few office applications for iOS that has proven itself only with positive side. The software package allows you to work with all modern electronic documents, and also provides the user with a very convenient explorer for searching files. 
An xls file is a spreadsheet created in text editor. In some cases, this type of file needs to be opened when a personal computer is not at hand. Let's review the most functional online editors that allow you to open this type of file, as well as edit it directly through an Internet browser.
XLS is a spreadsheet created in the editor Microsoft Excel. This format contains electronic data of cells, formulas, charts, graphs and other elements. In addition to the tabular Microsoft editor, you can open such an extension using third party programs. They can also edit xls, change data in cells, parameters of charts and graphs, formulas, etc.
The best services for opening XLS online
Office Live
For users who have an account for Microsoft services, there is an option to use the online Excel editor. He is full-fledged tool to edit tables and open XLS files online. If you don’t have an account, then within a few minutes you can go through quick registration and use the service. The advantages of using an online editor are that it has a classic Excel interface and users will not have any difficulties with the work. The disadvantages of Office Live include the fact that without registration in Microsoft system you won't be able to use it.
Registration instructions, if there is no account and opening the file:
- go to the online editor page;
- The Login dialog box will then appear. If you have an account, enter the data; if you don’t have one, then click “ Create it»;
- in the “Account Creation” window you need to enter your phone number, account Skype recording or email and set a password (the password must contain upper and lower case letters, as well as numbers);
- After this, an access code will be sent to your phone number; you must enter it in the appropriate field. More details about registration can be found in;
- then it will open home page online applications « Backstage»;
- click on the “New Book” tab and after that the familiar interface of the desktop version of the editor will open;
- go back to “Backstage” and click “ Send a book» in the upper right corner of the screen;
- then a selection window will open in Explorer, open the desired table and start sending a copy to the cloud storage;
- after these steps, the file will be automatically opened in online editor and it can be viewed and edited.
Google Sheets
Google Sheets is a convenient service for working with documents. In order to use the spreadsheet editor you will need to run registration procedure, to do this, just enter your personal data Google account. The advantages of the application is intuitive clear interface, functionality and the ability to save results in cloud storage and on a computer. The disadvantages include the fact that when opening large elements with charts and graphs, a long loading time occurs and the browser does not respond to requests for some time.
Instructions:
Online Document Viewer
English-language online service that offers viewing text and spreadsheet documents without registering. The advantages include the fact that you do not need to register, you can save files on your PC. The disadvantages of Online Document Viewer are quite significant - the display of tables is incorrect, the same goes for graphs and charts, there is no ability to edit.
Instructions:
Zoho Excel Viewer
A simple and convenient online service that allows you not only to view tables and edit them. Its advantages are that the user can take advantage of sufficient wide choice tools editing. You can change the font, fill, borders, etc. Saving the finished document in Zoho Excel Viewer is carried out not only on a personal computer, but also by providing a link to electronic copy file.
Instructions:
Edit Grid Viewer
A simple service for working with spreadsheets and opening XLS files online. Allows you to view and edit documents. The service has big advantage, with its help you can carry out multi-user work over one document. Just open it general access to the file and it will be available to other users. Edit Grid Viewer has only one drawback: it cannot open files with the XLSX extension.
Instructions:
Docspal
The resource allows users to only open and view spreadsheets and XLS documents, no other actions are provided by the developers. But at the same time, Docspal has possible conversion file to other formats.
Instructions:
Yandex.Disk
Cloud storage Yandex.Disk allows you to view spreadsheets, open XLS online for free and edit them. The application interface is similar to Microsoft Excel, therefore it will not cause any difficulties for users. The advantages are that it is possible to save on the cloud and PC.
Instructions:
Today everyone seems to be moving to the cloud, so why are we any worse? New technologies for sharing access to Excel data via the Internet is a simple method that provides many opportunities and advantages that you can use.
With Excel Online, you no longer need cumbersome HTML code to put your spreadsheets online. Simply save your workbook online and access it from literally anywhere, share it with others, and work together on the same spreadsheet. Using Excel Online, you can embed an Excel sheet into a website or blog and let visitors interact with it to get exactly the information they want to find.
How to send Excel 2013 sheets to the Internet
All Excel Online sheets are stored in the OneDrive web service ( former SkyDrive). As you probably know, this online storage has been around for a while now and is now integrated into Microsoft Excel as a one-click interface command. In addition, guests, i.e. other users with whom you share your tables no longer need their own account Microsoft entry in order to view and edit the Excel files that you have shared with them.
If you still don't have account OneDrive, you can create it right now. This service is simple, free and definitely worth your attention, since most applications Microsoft package Office 2013 (not just Excel) support OneDrive. After registration, follow these steps:
1. Log in to your Microsoft account
Make sure you are signed in to a Microsoft account from Excel 2013. Open an Excel workbook and look in the right top corner. If you see your name and photo there, then proceed to the next step, otherwise click Sign in(Entrance).
Excel will display a window asking you to confirm that you really want to allow Office to connect to the Internet. Click Yes(Yes) and then enter your account information Windows entries Live.
2. Save the Excel sheet to the cloud
Make sure, for your own peace of mind, that the correct one is open. workbook, that is, exactly the one to which you want to open public access on the Internet. I want to share the book Holiday Gift List so that my family and friends can watch it and contribute
With the desired workbook open, go to the tab File(File) and click Share(Sharing) on the left side of the window. By default the option will be selected Invite People(Invite other people), then you need to click Save To Cloud(Save to Cloud) on the right side of the window.
After that, select a location to save the Excel file. First on the list on the left is OneDrive, and it is selected by default. All you have to do is specify the folder to save the file on the right side of the window.
Comment: If you don't see the OneDrive menu item, it means you don't have a OneDrive account or you're not signed in to your account.
I have already created special folder Gift Planner, and it is shown in the list of recent folders. You can select any other folder by clicking the button Browse(Browse) below area Recent Folders(Recent folders), or create new folder, by clicking right click mouse and selecting context menu New(Create) > Folder(Folder). When desired folder will be selected, press Save(Save).
3. Share an Excel sheet saved on the Internet
Your Excel workbook is already online, and you can view it in your OneDrive. If you need to share Excel sheets saved on the Internet, then you only have one step left to do - choose one of the sharing methods offered by Excel 2013:
Advice: If you want to limit the area of an Excel workbook that can be viewed by other users, open the tab File(File) section Info(Details) and press Browser View Options(Browser viewing options). Here you can configure which sheets and which named elements can be displayed online.
That's all! Your Excel 2013 workbook is now online and accessible to selected users. And even if you don't like to collaborate with someone, this method will allow you to access Excel files from anywhere, no matter whether you are in the office, working at home or traveling somewhere.
Working with workbooks in Excel Online
If you are a confident inhabitant of the Cloud Universe, then you can easily master Excel Online during your lunch break.
How to create a workbook in Excel Online
To create a new book, click the small arrow next to the button Create(Create) and select from the drop-down list Excel workbook(Excel workbook).
To rename your online book, click the default name and enter a new one.
To load an existing workbook into Excel Online, click Upload(Upload) on the OneDrive toolbar and select the desired file saved on your computer.
How to Edit Workbooks in Excel Online
Once you have opened a workbook in Excel Online, you can work with it Excel help Web App(same as with Excel installed on personal computer), i.e. enter data, sort and filter, calculate using formulas, and visualize data using charts.
There is only one significant difference between the web version and the local version Excel version. Excel Online doesn't have a button Save(Save) because it saves the book automatically. If you change your mind, click Ctrl+Z to cancel the action, and Ctrl+Y to redo the undone action. For the same purpose you can use buttons Undo(Cancel) / Redo(Return) tab Home(Home) in the section Undo(Cancel).
If you try to edit some data, but nothing happens, then most likely the workbook is open in read-only mode. To enable editing mode, click Edit Workbook(Edit book) > Edit in Excel Web App(Edit in Excel Online) and make quick changes right in your web browser. To access more advanced data analysis capabilities, such as pivot tables, sparklines, or to communicate with external source data, press Edit in Excel(Open in Excel) to switch to Microsoft Excel on your computer.
When you save a sheet in Excel, it will be saved where you originally created it, that is, in the OneDrive cloud storage.
Advice: If you want to make quick changes to multiple workbooks, then in the best possible way will open a list of files in your OneDrive, find the book you need, right-click on it and select necessary action from the context menu.
How to share a sheet with other users in Excel Online
... and then choose one of the options:
- Invite People(Send access link) – and enter the address Email people to whom you want to give access to the book.
- Get a link(Get link) – and paste this link into email, post it on your website or social networks.
You can also set access rights for contacts: the right to only view or give permission to edit the document.
When multiple people are editing a worksheet at the same time, Excel Online immediately shows their presence and the updates they've made, as long as everyone is editing the document in Excel Online and not in local Excel on their computer. If you click the small arrow next to a person's name in the upper right corner of the Excel sheet, you can see which cell that person is currently editing.
How to block editing of certain cells in a shared worksheet
If you're sharing online sheets with your team, you might want to give them editing rights only certain cells, rows or columns Excel document. To do this in Excel at local computer you need to select the range(s) you allow to be edited, and then protect the sheet.
How to Embed an Excel Sheet into a Website or Blog
Comment: The embed code is an iframe, so make sure your site supports this tag and your blog allows it to be used in posts.
Implemented Excel Web App
What you see below is an interactive Excel sheet that demonstrates the described technique in action. This table calculates how many days are left until your next birthday, anniversary or other event and colors the intervals in various shades of green, yellow and red. In Excel Web App, you simply enter your events in the first column, then try changing the corresponding dates and look at the results.
If you are curious about the formula used here, please take a look at the article How to set up in Excel conditional formatting dates.
Translator's note: In some browsers, this iframe may not display correctly or may not be displayed at all.
Mashups in Excel Web App
If you want to create more close interaction between your Excel web sheets and other web apps or services, you can use the JavaScript API available on OneDrive to create interactive mashups of your data.
Below you can see a Destination Explorer mashup created by Excel command Web App as an example of what developers can create for your website or blog. This mashup uses the Excel Services JavaScript API and Bing Maps to help site visitors choose their travel route. You can select a location on the map, and the mashup will show you the weather in that location or the number of tourists visiting those locations. The screenshot below shows our location