Advice 1: How to merge cells in Excel without losing data

In Microsoft Office Excel, you can merge several cells into one. But if you use for this operation tool "to Combine and place in the center" from "Alignment" lost data in all cells, except those who were in the upper-left cell of the range.
How to merge cells in Excel without losing data
Instruction
1
To merge cells in Excel without losing the data contained in them, use the ampersand operator is the & symbol denoting the English word "and". Place the cursor in the cell in which the combined data in the formula bar an equal sign and the opening parenthesis.
2
Select the first cell with the left mouse button and enclose between ampersands the space character in quotation marks - & "" & scroll to the next cell and re-enter &" "&. Continue as long as the mark in this way all the cellsthat you want to merge. To finish entering the formula, put a mark close parenthesis and press Enter. The formula will look like this: =(A1&" "&B1&" "&C1).
3
If you need to split combined data punctuation marks, place them after the first ampersand and quotation mark after entering a punctuation mark, don't forget to add a space. An example formula for the combined data using punctuation: =(A1&"; "&B1&"; "&C1).
4
You can also use the function "Concatenate". To do this, set the cursor in the cell, click in the formula bar fx icon. Opens a new dialog box "function Wizard". From the list, select the CONCATENATE function, or browse using the search fields. In the window "function Arguments", put the cursor in the Text1 box and select left click the first cell of the merged range. Move the cursor to field "Text2" and select the document next cell. Click on the OK button.
5
When using this method do not highlight the entire range of merged cells, this will lead to the fact that data will be lost. Formula should look like =CONCATENATE(A1:B1). Separate locations the sign ";" - semicolon, then all the values will be retained. Formula example: =CONCATENATE(A1; B1; C1).

Advice 2: How to learn how to use Excel

Sooner or later, the user of the personal computer have to deal with such software as Excel. It developed spreadsheets that allow you to create different databases.
How to learn how to use Excel
Instruction
1
To learn how to work with this program, it is first necessary to determine the tasks that must be performed for you. Typically, such software has a flexible built-in functions that allow you to format and categorize all the information in different directions. In the Internet there are many different courses that allow in real time to see how to build a table that integrates information, data is sorted and much more.
2
Usually, the first exercise starts with an introduction. You should know clearly where each graph. At this point in time there are several versions of this software, namely Excel 2003, 2007 and 2010. Perhaps, many got used to the 2003 version. Despite the fact that now the updates are only generated for 2007 and 2010 software Excel 2003 does not cease to be popular.
3
Open the program on your computer. Go to the tab "help" and read those items that interest you. In fact, such software for functions like Word. There are the same formatting commands, menu items, are similar in many ways, the interface is also very clear. To add a new table, click on "File" - "Create". Next, enter the name of the document in which you will work.
4
Next, enter information into the cells of the table. You can stretch each block, both in width and in length. To add more cells, right-click the table and select "Add cells". In the tools tab you can find the additional operations which provides the software. Start with a simple copy of the information in the table and then try different ways to display them in the table, to sort, to try to present in more convenient form.

Advice 3: How to prevent changes to the cell

Protecting cells in a spreadsheet editor of Microsoft Office Excel is not used to comply with the secrecy - for this purpose here is the protection of the data file. Lock access to the cells is needed, rather, to prevent accidental changes to formulas or data in spreadsheets. The procedure of protection is simple, but requires an understanding of the working principle.
How to prevent changes to the cell
You will need
  • The table editor Microsoft Office Excel 2007 or 2010.
Instruction
1
Protection in Excel is organized in such a way that it is set on the sheet document as a whole and covers all its contents. So before you can proceed with the setup blocking access, you should specify exceptions to the General prohibition. Of course, this should be done only if it is necessary to leave free the access to some cells of the table. Start with selecting the entire sheet, press Ctrl + A.
2
Click the selection with the right mouse button and select in the pop-context menu "Format cells". On the screen a window will appear in which you need the security tab - check the installed checkbox "Protected cell". If you want the locked cells not only it was impossible to edit, but to view the information contained in formulas, set a mark in the "Hide formula". Click OK and the sheet will be ready to turn on protection.
3
If you leave a free access to any of the elements is not required, skip this step, otherwise select the cellsthat should be excluded from the list of protected. Again invoke the properties window via the context menu and perform the opposite operation - to remove the checkmark from the checkbox labelled "Protected cell". Press the OK button.
4
Turn on sheet protection. This can be done on the tab "Home" menu of the table editor. In the group of "Cell" this tab has a drop-down list "Format" - open it and select "Protect sheet". On the screen appears a small window of settings of the protection.
5
Put a mark in the checkboxes of operations that must remain available to users on the protected sheet. If to remove protection should only a person who knows the password, enter this password in the text box. Click OK, and the protection is activated.

Advice 4: In Excel, replace the full stop with a comma

Point and comma can perform functions thousands separator in numbers written as decimal fractions. In most English-speaking countries as a separator and in Russia - the comma. This often is the need to replace the commas in the spreadsheet program Microsoft Office Excel.
In Excel, replace the full stop with a comma
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
If in the settings of your tabular editor point set as the decimal separator, this can be changed in one of the sections panel installations Excel. To reach it, open the application menu. This can be done by pressing the Alt key followed by the button "f". In Excel 2010 menu item "Settings" is placed in the penultimate line of the command list, and in Excel 2007, the button "Excel Options" in the bottom right corner of the menu.
2
Select "Advanced" in the left column of the settings panel and under "edit Options" find the line "Use system separators". If the checkbox from the label mark is, then you need the field "Delimiter between the integer and fractional parts" cannot be edited. Remove it, put a comma in the text box and click OK to commit changes in the preferences editor.
3
If you want to replace the dot with a comma in a specific cell on a spreadsheet, it can be done in several ways. First select the desired cell, then switch to edit - press F2 or double click this cell. Move the input cursor to the point and replace it with a comma. The same can be done in the cell and in the formula bar - where to activate the edit mode with just one click.
4
For total replacement of all commas by dots in all the cells in a spreadsheet use the find dialog and replace. To call it designed "hot keys" Ctrl + H "Replace" in the drop-down list of the button "Find & select" - it is placed in the command group edit on the Home tab.
5
In the Find field of the find dialog and replace a dot and a comma in the "Replace with". If you use this operation only on the current sheet of paper will be enough, click "Replace all" and Excel will proceed to run the command. For replacement on all sheets of the open document, click "Options", set the value "book" in the drop-down list labelled "Search" and then click on "Replace all".
Is the advice useful?
Search