Advice 1: As in Excel to divide the cell

In the table editor Microsoft Office Excel the user can have more than a sufficient number of cells to 18278 columns and 1048576 rows. The width and height of the cells can change, merge several cells into one, building spreadsheets as blocks. However, the operation of division of cells in part is possible only up to a certain minimum limit, but the huge number of available cells almost always allows you to bypass this restriction.
As in Excel to divide the cell
You will need
  • Spreadsheet editor of Microsoft Office Excel.
Instruction
1
If the cell that you want to share, was created by merging several table cells, the operation is very simple. Start with the selection of this cell - click on it with the mouse cursor. When this menu is highlighted, the button "Combine and place in the centre", placed in the group of commands Alignment on the Home tab. Click this button or open attached to it a drop-down list and select "unmerge cells". In both cases, the result is the same - Excel will divide the cell into its component cells.
2
If you want to break a cellthat is a component, will have to do some more operations. You need to make part of the neighboring table cell, creating the impression that the desired cell is divided into several sections. If the cell should be split horizontally, merge will have cells in the row, and a vertical split this should be done with cells of the column.
3
Start with selection when creating a table the required elements in the row or column. For example, if one cell in the column needs to be split into three vertical sections, select the cells in the three neighboring columns on the height of the table.
4
Combine the rows of the selected range. On the Home tab, open the drop-down list buttons "to Combine and place in the center of the" group of commands "Align" and select "Merge rows".
How to divide in Excel <strong>cell</strong>
5
Change the width of the combined columns to make it equal to neighboring columns. To do this, select all of the combined columns used in example three. Hover the cursor over the border between any two headers of the selected columns and drag it to the desired column width. The horizontal size of all selected columns will change synchronously.
How to divide in Excel <strong>cell</strong>
6
Choose the cellfor which made all these manipulations. Again open the drop-down list buttons "to Combine and place in the center", but this time select "unmerge cells". This is the last operation, the desired cell after it will be broken into given number of parts. If you want to split on a horizontal section all the steps need to produce with strings.
How to divide in Excel <strong>cell</strong>

Advice 2: How to protect the cell from changes in Excel

Protection of cells in tables created in Excel, part Microsoft Office package, it may be useful when you have complex formulas and pre-defined constants in the selected table. By default, each cell in the worksheet is locked, but in the absence of the protection sheet, editing of data available to any user.
How to protect the cell from changes in Excel
Instruction
1
The main menu of the Windows operating system, knoke press "start" to initiate procedures for the protection of the cells in the selected table from changes and click "All programs."
2
Expand Microsoft Office and run the Excel application.
3
Select the protected cells of the table and open it.
4
Highlight the desired cell or cells, and open the menu "Format" of the top toolbar of the Excel application window.
5
Select "Cells" and click on the security tab of the resulting window.
6
Apply the check box on the "cells" and confirm application of the selected modifications with the OK button. All unselected cells will remain editable.
7
Apply a check mark on the "Hide formula" to prevent users from editing the contents of the selected cells and click OK to confirm save changes.
8
Expand the tools menu of the top toolbar of the application window to install the protection from the selected range of cells and point to "Protection".
9
Select the option "Allow users to edit ranges" to distinguish the required range and click "Create" in the dialog box.
10
Enter values for the range names, cell addresses, thereto and password in the appropriate fields for each user and confirm your choice with OK.
11
Return to menu "tools" and run the "Protection" to restrict editing of the entire sheet of the selected document.
12
Use the option "Protect sheet" and enter the desired password value in the dialog box.
13
Apply the check boxes for the fields necessary exceptions confirm and apply the selected changes by pressing the OK button.

Advice 3: As in Excel cell protection

In Microsoft Office Excel it is possible to protect the data. It can spread to the workbook, worksheet, cell, controls. To protect the cell from changes or from entering into it incorrect data, it is necessary to turn to the tools of the program.
As in Excel cell protection
Instruction
1
To protect the cell from entering invalid data, highlight the desired cell or a range. Go to the tab "Data". In the section "Working with data" click on the "Test data". Opens a new dialog box "input Validation".
2
Activate the tab "Settings" and set the type of data that is allowed to enter in the cellusing a drop-down list in the "check Condition". If necessary, set additional parameters which will be evaluated in the input cell values.
3
On the tabs "Message input" and "error Message" you can enter hints that allow users to understand what format you are allowed to add data into the cells and set the text to alert you to improper actions. After making all necessary changes click OK to the new settings took effect, the window "input Validation" will be closed automatically.
4
To protect against changes to cells, select the range and click the Home tab. In the section "the Cell" click on "Format". Another option: click the right mouse button in the selected cells and select the context menu "Format cells". This will open a new dialog box.
5
Go to the security tab and set the marker in the "Protected cell". Apply the new settings by pressing the OK button. Protection of cells will turn on only if you protect the whole sheet.
6
Sheet protection is enabled on the tab "Review". Click on it and click on the "Protect sheet" in the section "Changes". A new dialog box. Set markers next to those items that will fit.
7
If necessary, enter the password in the designated row and click OK. An additional window will appear, confirm it the password you just entered and click OK. Then when you try to edit a cell the program will notify the user that it is protected from changes.
Is the advice useful?
Search