Advice 1: How to paint a cell

The Microsoft Office allows you to use spreadsheets to maintain databases, computation, and presentation. For greater clarity, it is sometimes necessary to select several cells, depending on their content.
How to paint a cell
You will need
  • MS Office
Instruction
1
Often, to highlight a cell or group of cells use a colored background. To paint a cell in Microsoft Word, draw a table. In the main menu select "table", "Add table".
Press left mouse button in the cell where you want to start the selection and hold, drag the selection to the whole group. In the main menu, choose "Format" then "Borders and shading". You can choose a fill color and pattern, as well as to style cell borders.
How to paint <strong>cell</strong>
2
In MS Office Word 2007 interface is slightly different. Click on the icon "Boundary", choose the tab "Fill". At the bottom right of the drop-down list, choose the part of the document to which you want to apply a fill, page, cell, or paragraph. In this version of Word have the option to impose a pattern on the cell or group of cells, and also to stylize the border.
How to paint <strong>cell</strong>
3
In the table editor MS Office Excel to paint the cell, from the main menu select "Format" then "Cell". In the dialog box, choose the tab "View". Here you can choose the color suitable for your table and, if deemed necessary, pattern.
How to paint <strong>cell</strong>
4
In Excel 2007, on the properties pane in the Font when you hover over the symbol fill pop-up appears "Change the background color of the selected cells". Click on the triangle top down next to the icon to choose a suitable shade from the drop down list.
How to paint <strong>cell</strong>
5
In order to paint a cell in MS Access, from the main menu select "Format" then "Cell". In the dialog box, "grid View" select the cell background color drop-down list background Color.
How to paint <strong>cell</strong>
6
In MS Office Access 2007 the properties pane of the Font group select the icon fills. Open the drop-down list next to it and choose the desired color. If the palette of standard colors suitable shade is not found, click on the "more colors" and continue the search there.
How to paint <strong>cell</strong>
Useful advice
Do not get carried away painting the table, otherwise too much diversity will interfere with and divert attention from the data.

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.
Is the advice useful?
Search