How to create an excel file, open it, save it, close it. Excel. Creation of documents How to block the editing of the singing middles on the arkush from the back door

Golovna / Korisne PZ

For a number of cases that work closely with Excel spreadsheets, you may need to create an Excel spreadsheet on a computer that does not have Microsoft Office installed (also known as Microsoft Excel). Problem? Anіtrochs! When creating designated tables, you will be assisted by popular services that allow you to easily create an Excel spreadsheet online. We will tell you how to run Excel online, how to help us with whom, and how to practice with them.

Specifics of services from vbudovanim Excel

Merezha has some popular merging services that allow you not only to open an Excel file online, but also to create a new Excel spreadsheet, edit it, and then save it to your PC. Sound stench can finish a functional similar to MS Excel, and the robot will not create everyday problems for them, as they are already right behind the stationary MS Excel editor.

For registration on such platforms, you can use the login and password of the public record of the correspondent in social networks (for example, with Facebook), or go through the standard registration procedure via email.

Use Exciel functionality

I need to work with documents, spreadsheets and create presentations online, without installing an anonymous program on the computer, so I created a selection of the shortest services - and.

Let's move on to the list of services that allow you to create Excel tables online. Deyakі їх dosit actively pratsyyut іz hmarnym servіs, so they can copy the creation of a koristuvach table there, and already call the koristuvach can zavantazhit created by him a table on your computer.

Office.Live - program for creating and editing tables

This service from Microsoft gives you the ability to access MS Office features online, and free of charge. Zocrema, you can use the functionality of the MS Excel spreadsheet editor, which allows you to create, edit and save tables online in popular formats of this editor (, xml and others).

To work with the editor, go to the instructions resource https://office.live.com/start/Excel.aspx.
Select "See for help with Microsoft's physical record".
І to create an oblique record (or hurry up with the oblique tribute of your oblіkovogo record in Skype).
They gave you a screen of basic templates for creating excel tables. Press "New book", and you will switch to the mode of creation and editing of your table.
To save the result, click on the tab "File" - "Save yak" - "Get a copy".

Google Spreadsheets - allows you to add graphics and diagrams to Excel

Google Docs is a great online service like Google with rich capabilities, including allowing you to work with Excel, review different file formats (XLS, XLSX, ODS, CSV), create graphics and diagrams as well. To work with this service, you need to have a Google record, because you don’t have it, so I’ll tell you to do it.

To speed up Google Docs, go to the site https://docs.google.com/spreadsheets/u/0/, and enter your spreadsheet data in Google.
To create a new document, click on “Blank” (a rectangle with a green plus sign), and you will switch to the Excel spreadsheet creation mode.
The interface of the service is English, but for short ones, as before, right from Excel, the robot from Google Docs does not have any particular problems.
To save the table you have created on your computer, click on File - Download as and select a custom format for saving the file (for example, xlsx).

ZOHO Sheet - spreadsheet software

Service from Russian language support, which provides all the necessary functionality for creating Excel spreadsheets. The service includes almost everything that its competitors do – it works with more formats in excel, it supports more editing of the decal document with short cuts, it allows you to use graphics and diagrams too.

https://www.zoho.com/docs/sheet.html
Press the button "CREATE SPREADSHEET" (you may need to give your public record in Google), and you will switch to the table creation mode.
You can save the lost result by clicking on "File" - "Export as", and then selecting the file format option that is convenient for you (named "MS Excel workbook").

EtherCalc - display .xlsx, .xlsm and .xls files

Among the advantages of this service, I have considered the ability to work with Excel tables without any registration, the support of parallel editing of one table of dekilkom with coristuvaches, manual functionality, as well as the absence of other advantages that are allowed to work online.

To work with the cim service, please go to https://ethercalc.org/.
Press the "Create Spreadsheet" button (create a spreadsheet).
You will switch to edit mode and you can create the table you need.
To save the final document, press on the image with a left hand floppy disk, select the saving format and download the table to your PC.

Working with "EtherCalc" service

Yandex.Disk - simple work with Excel online

The Russian company Yandex pleased the koristuvach with the ability to create and edit an Excel document online for the help of a special service on Yandex.Disk. Behind its functionality, this service is a copy of Office Online (the first of the merging services I have described), with this, for the help of coristuvachs, on this service in Yandex and inode, problems are trapping in the robots of great formulas, blaming bugs, the service is nasty working with excel files, created in MS Excel up to 2007.

To work with this service, go to the new one https://disk.yandex.ua/client/disk (you may need registration on Yandex).
Click on the "Create" button - "Table".
You will switch to the mode of creating and editing tables.

Visnovok

For work with Excel, online varto is speeded up by online services, which I have re-arranged more. All stinks are cost-free, they support (for a small blame) the Russian interface, for their functionality, they may not compromise the stationary version of MS Excel. As a reader, it was necessary to create an excel table in terms, but the computer with an installed MS Office did not appear at hand, however, it was possible to speed up the functionality of the descriptions of the wider lace tools, which allows you to effectively write, and similar to it, zavdannya.

To create an Excel document from a template, you need to create or open a workbook in MS Excel. Then go to the File tab and click on Create.

On the screen will appear in the form of templates. This menu has okremі documents, and folders with different templates. In order to select a template, simply click on the default icon, and then add it and see it in a new document.

Templates in Excel

Basically, document templates in Excel are based on tables, so they stink good for information in looking like lists, graphs, structuring documents. Here you can find various timesheets, filing forms, price lists, lists of references.

Excel templates are good because they are already designed. The documents themselves have accentuated colors and other adjustments, which would have taken a lot of time, so as to work the document from scratch. Also, such templates are manually created, for example, in Word, so that the areas of documents are surrounded and do not require additional adjustments to look at the attachment of the middle ones.

In addition, in the tables there are tricks that are tuned in, for the help of which you can manipulate the data and conduct a quick search.

Deyakі templates dosit specific and can be but deisno korisnі, for example, є templates for paper music, millimeters, rіznih lists, as well as laying out lessons. Such templates can be used in everyday life, and in robots.

Nykorisnіshі/tsіkavіshі templates in MS Excel 2010:

paper-millimeter

sheet music

family tree

spivrobitnik pass card

teacher's lesson plan

table of results

Address book

calendars

inventory transfer

perelik myna

homemade

rahunki

list of references for the project

price-list

distribution of dzvinkiv

blood vise chart

magazine

food planner

entry budget

Updated templates can be found

Today, let's go, everyone is going over to the gloomy collections, then what's the big deal? New technologies for accessing Excel data via the Internet are a simple way to give impersonal opportunities and gains, so you can win.

With the advent of Excel Online, you no longer need cumbersome HTML code to accommodate spreadsheets on the Internet. Just save a working book online and remove access to it literally from any time, give access to others and work on the same table at once. With Excel Online, you can embed an Excel sheet on a website or blog and let people interact with it to see the very information they want to know.

How to upload Excel 2013 sheets to the Internet

All Excel Online sheets are collected from the OneDrive web service (more SkyDrive). Yak Wee, maybe you know that the online collection has already appeared some time ago, and now it is integrated into Microsoft Excel as a command is available in one click to the interface. From the other side, guests, tobto. For others, with whom you share your spreadsheets, you no longer need the official Microsoft record in order to review and edit the Excel files that you shared with them.

If you don't have a OneDrive image yet, you can create one right away. This service is simple, cost-free and insanely meritorious for your respect, most of the programs of the Microsoft Office 2013 package (not only Excel) support OneDrive. After registration, write down the following lines:

1. See to your Microsoft exposure

Rewind, you've made it to Microsoft's Excel 2013 public record. Open a working Excel workbook and look at the top right cut. If you add your own photo there, go to the next step, otherwise press sign in(Enter).

Excel will show you a window that confirms that you really want to allow Office to connect to the Internet. Press Yes(Yes) and enter the details of the Windows Live Live recording.

2. Save an Excel sheet from darkness

Perekonaytes, scho for your peace of mind, scho need a working book, that is the same, until you need to get access to the Internet. I want full access to the book Holiday Gift List, so that the members of my homeland and my friends could marvel at and accept

I want to work a book, go to the tab file(File) ta press share(Zahalny access) at the left part of the window. An option will be selected for the lock Invite People(Ask for other people), gave you the necessary press Save To Cloud(Save in the dark) at the right side of the window.

Then choose a place to save the Excel file. The first on the list of evils is OneDrive, and the blame for the lockdown. You are left with less to choose a folder for saving the file on the right side of the window.

Respect: If you don't check the OneDrive menu item, you don't have a OneDrive account, or you haven't reached your account.

I have already created a special folder gift planner, and it appears next to the list of remaining folders. You can choose any other folder by pressing the button Browse(Looking) below the region Recent Folders(Stop folders), or create a new folder by right-clicking the mouse and selecting it from the context menu New(Create) > Folder(Heart in heat). When selected, I will need a folder, press Save(Save).

3. We give you full access to an Excel sheet saved on the Internet

Your working Excel workbook is already online, and you can look it up on your OneDrive. As it is necessary to open global access to savings on the Internet Excel sheets, then you have lost more than one click - choose one of the Excel 2013 methods for obtaining global access:

Porada: If you want to surround the area of the Excel workbook, as it is available for review by other shorthands, open the tab file(File) split info(Vіdomostі) ta press Browser View Options(I will review the parameters in the browser). Here you can find out how the lists and the names of the elements can be displayed on the Internet.

From i all! Your working Excel 2013 workbook now has access for selected workbooks to it. And you don’t like to work together with someone, any way you can allow access to Excel files, the stars are good, not important, you are in the office, work at home, or it will rise in price.

Work with books in Excel Online

If you are a sackbag of the Khmarny Vsesvit, then without any problems master Excel Online in an hour of daily interruption.

How to create a book in Excel Online

To create a new book, press a small arrow with a button Create(Create) the one on the list that you see, choose Excel workbook(Excel book).

To rename your online book, type in a name, enter a new one.

To get a basic workbook in Excel Online, press the button Upload(Get) on the OneDrive toolbar and enter the required file, savings on the computer.

How to edit workbooks in Excel Online

Since you have opened the book in Excel Online, you can use it for help with Excel Web App (just like with Excel installed on a personal computer), then. enter data, sort and filter, calculate, vicarious formulas, and directly submit data for additional diagrams.

There is only one difference between the web version and the local version of Excel. Excel Online doesn't have buttons Save(Save), to the one who automatically saves the book. Yakscho We changed your mind, press ctrl+z, to say dіyu, that ctrl+y, sob again vikonati skasovanu diyu. For tієї well, you can beat the buttons Undo(Skasuwati) / redo(Rotate) on tabs Home(Headquarters) at the branch Undo(Skasuwati).

If you try to edit some data, but if nothing comes up, then, better for everything, the book is no longer readable. To turn on the editing mode, press Edit Workbook(Edit book) > Edit in Excel Web App(Change in Excel Online) and make quick changes directly from your web browser. To take access to the possibilities of more advanced data analysis, for example, to the stars of the tables, sparklines, or to link from the old data, press Edit in Excel(Open in Excel) to go to Microsoft Excel on your computer.

If you save a sheet in Excel, it will be saved there, de Vie yogo was created on the cob, so in the gloomy OneDrive collection.

Porada: If you want to save files in decal books, then the best way would be to open the list of files from OneDrive, find the book you need, right-click on it and select the desired entry from the context menu.

How does Excel Online give access to the archway for other koristuvachiv

… and then choose one of the options:

Invite People(Send a request for access) - and enter the e-mail address of the people you want to give access to the book.
Get a link(Remove the message) - and put the message into the electronic sheet, distribute it on the site or in social networks.

You can also set the access rights for contacts: the right to review or give permission to edit the document.

If you edit a small number of people at once, Excel Online will immediately show the presence and progress of the update, remember that everyone edits the document in Excel Online, and not in local Excel on the computer. If you press a small arrow to entrust people to them at the upper right corner of the Excel arch, then you can work, which is the very middle of the editing of the people.

How to block the redaguvannya of the singing middles on the arkush from the backyard access

If you give your team access to the online sheets, you might want to give them the rights to edit only the middle rows, rows and columns of the Excel document. For this in Excel on a local computer, you need to select a range (range), if you allow editing, and then deleting the arch.

How to pass an excel sheet to a website chi blog

Respect: The zastosuvannya code is for the iframe, so change your site so that your site supports this tag, and the blog allows you to tag it in posts.

Excel Web App

Those you see below are an interactive Excel sheet that shows the technique described in the tutorial. Tsya table of rozrakhovuє, how many days have been lost until your coming day of the people, rivermen chi like other podії and zabarvlyuє promіshki at raznі vіdtinki green, yellow and red. In Excel Web App, you just need to enter your password at the first page, then try to change the required dates and see the results.

If you like it, if there is a formula here, then, be kind, look at the article How to set smart date formatting in Excel.

Translation note: In some browsers, the iframe may display incorrectly or not.

Excel Web App mashups

If you want to create more interoperability between your Excel websheets and other web add-ons or services, you can tweak the JavaScript API available on OneDrive to create interactive meshes with your data.

Below you can see the Destination Explorer mashup, created by the Excel Web App team as an example of what retailers can create for your website or blog. This mashup is based on API Excel Services JavaScript and Bing Maps, and this task is to help the site choose a route for the road. You can choose a place on the map, and the bag will show you the weather in that city, or the number of tourists who see the city. The screen shot below shows our distribution

When you start Excel, you see a window with an empty book. For the locking of the document, one hopes im'ya - book1(Book1). Nove im'ya asks himself to be a koristuvach.

Rice. 13.8. book creation

The document can be created in the following ways:

choose from the menu File(File) command Create(New). At the sphere book creation(New Workbook) click on the mouse to use hyperforce (Fig. 13.8). Possilannya in the area zavdan allow vykoristovuvat for the creation of a book a clean book, templates on the computer, templates on websites. To save a book as a template, you can create a new book with the same formatting and styles that make up the template. (According to the template for the hour of the creation of the document, it was reviewed in section 9);
press the button Create(New) Toolbar Standard. The button is expanded on the left edge of the panel and allows you to create a new document based on the default template. The button is duplicated by keys CTRL + t (CTRL+N).

Behind the scenes, the book template can be called Book.xlt. (Assigned to a template is reviewed in section 9, in the section "Which template is available at the time of creating a document.") For standard arcades, the Sheet.xlt template is used. To change the look of the Excel workbook that is locked behind the lock, change the new workbook and save її pіd іm'yam Book.хlt at the Xlstart catalog.

Saving a new toolbar setup

The toolbar selection for Office 2003 software windows was reviewed for the "Toolbars" branch 2. Significantly, you can save the customization of a number of toolbars and those on the screen for later work, which will save you the need to re-adjust the next time you start Microsoft Excel. After adjusting the resize of the toolbars and retouching on the screen, you can see it from Excel. Find the Excel.xlb file and change its name by leaving the extension.xlb in front. To save the installation again, open the renaming parameter file in the toolbars with the command Vidkriti(Open) at the menu File(File).

The Microsoft Excel program is handy for folding tables and visualizations. Working area - tse rich seredkіv, yakі can be filled with danim. Year - format, vikoristovuvatime prompt graphs, diagrams, stars.

A work in Excel with tables for koristuvachіv-pochatkіvtsіv can be foldable at first glance. Vaughn suttєvo vіdrіznyаєtsya vіd principіv pobudovі table u Word. Ale, let’s start from small things: creating and formatting tables. For example, you can’t think of a better tool for creating tables than you can imagine Excel.

How to create a spreadsheet in Excel for dummies

There is no hurry to work with tables in Excel for dummies. You can create a table in different ways and for specific purposes, skin can use your own way. For this reason, we visually assess the situation.

Look respectfully at the worksheet of the spreadsheet processor:

Tse bezlіch seredkіv at stovptsyah and rows. Really - a table. The columns are marked with Latin letters. Rows are numbers. If you want to bring this arkush to another, take a clean side. Without waiting between.

On the back, let's learn to practice with the middles, rows and rows.

How to see the row

To see the whole story, click on the name (Latin letters) with the left mouse button.

To see a row - after the name of the row (after the number).

To see a sprig of stovptsiv or a row, click the left button of the mouse behind the name, try it out.

To see the help of hot keys, we put the cursor at the bottom of the necessary column - we press Ctrl + hit. To see the row - Shift + space.

How to change between centers

Even though the information when filling in the tables is not to be missed, it is necessary to change between the middle ones:

To change the width of the columns and the height of the rows in a row in the same range, you can see the area, increase 1 column / row (manually change) - automatically change the size of all the views of the columns and rows.

Note. To rotate the amount of space, you can press the "Skip" button or the hot key combination CTRL+Z. Ale vona spratsovuє todi, if robish once. Piznishe - do not help.

To rotate the rows at the exit boundary, open the tool menu: “Head” - “Format” and select “Autopick Row Height”

For students, this method is not relevant. Press "Format" - "Width for locking". Memorize the number. We see if there is a commissar at the stovpts, between which it is necessary to “turn”. I know “Format” - “Width of the column” - the tasks are entered by the display program (sound 8.43 - the number of characters in the Calibri font with a size of 11 points). OK.

How to insert a row or row

We see a row / row to the right / lower than that month, where it is necessary to insert a new range. Tobto stovpets z'appear levoruch vіd seen in the middle. And the row is wider.

Pressing with the right mouse button - select from the "Insert" menu (or press the hot key combination CTRL+SHIFT+"=").

Significantly "stovpchik" and embossed OK.

Porada. For a swedish insertion, it is necessary to see the stovpets at the buggy area and press CTRL+SHIFT+"=".

All these beginners will be at hand when the tables are folded in the Excel program. We will have to expand the borders, add rows/stovpts at the process of work.

Pokrokov's creation of tables with formulas

Now it will be an hour to see a friend between stovptsiv and rows.

For the help of the "Font" menu, you can format data in Excel tables, like in Word.

Remember, for example, change the font, make the cap bold. You can insert the text in the center, please transfer it too thin.

How to create a table in Excel: instruction manual

The simplest way to create tables in the same vіdomy. Ale in Excel is a good option (for a plan of a distant format, work with data).

I’ll make a “reasonable” (dynamic) table:

Note. You can take a different route - see the range of the middle ones, and then press the "Table" button.

Now enter the necessary data for the finished frame. As a matter of course, we need to put the cursor next to the assignments to name the room. Write down the name and press INTRODUCTION. The range will automatically expand.

As it is necessary to increase the number of rows, it will be added to the lower right corner for the autocomplete marker and it will be stretched down.

How to practice with a table in Excel

With the release of new versions of the robot program in Excel with tables, it became cica and dynamic. If a reasonable table is formed on the arch, the tool "Robot with tables" - "Designer" becomes available.

Here we can give the name of the table, change the rozmіr.

Different styles are available, the ability to reshape the table to a greater range or sound.

Possibility of dynamic spreadsheets MS Excel majesty. Let's look at the basics of entering data and autocomplete:

If you click on the right-handed arrow of the skin subheading of the cap, we will take away access to additional tools for working with these tables.

Sometimes koristuvachevi should be brought to practice from great tables. To look over the bags, it is necessary to burn through more than one thousand rows. Seeing the rows is not an option (give it a go). Ale can take. For tієї meti, speed up with numerical filters (image is higher). Take away the checkmarks on the contrary, quietly, so that you can be protected.