How to Input message data validation in Microsoft Excel

Well, according to the title of this post I will be explaining the message Input Method validation data in Microsoft Excel. Following on the previous post I have explained How to perform Data Validation Settings in Microsoft Excel.

Input Message is the information that can be presented to users about what data should or should not be included in the validated cell. Information is displayed by default when the user selects a validated cell.

1. Blocks that have been validated range (A1: A5). Select the Data tab> Data Validation> Data Validation. Dialog box will appear and select Data Validation Input Message tab.

 
2. Tick ​​mark (√) in the Show input message when cell is selected to display the Input Message validated when a cell is selected.

3. In the Title text box: type the title information data validation, for example, type Enter a value of 10.

4. Input message in the text box: type of data validation information. For example, type You are only allowed to enter the data with a value of 10.

5.If the settings are finished press the OK button. Select a cell in the range to be validated, for example cell A1. Input Message will appear as shown below.

 
By default the Input Message displayed at the bottom of the cell to be validated. To change this, click and hold the left mouse button on the Input Message. Drag the Input Message on the position you want. If it is appropriate, release the left mouse button.

A few of my brief explanation of the message Input Method validation data in Microsoft Excel, May be useful for you all. Do not forget to look forward to other Excel tutorials.

How to perform Data Validation Settings in Microsoft Excel

In the Older Post I Already Gives Explanation On How To Edit Data Using the Replace Feature in Microsoft Excel, this time I will give further explanation of the Data Validation Settings in Microsoft Excel.

Data Validation settings is relatively easy because we only live determines what data should the user entered into a cell to be validated.

1. Press Ctrl + N to create a new workbook. Block cell or range to be validated, in this example the block range A1: A5.

2. Select the Data tab> Data Validation> Data Validation dialog box will bring up the data validation.

3. To perform the validation settings tab select settings. In the box Allow choice: you can choose the following options are available:

• Any Value. If you choose this option, then the user is allowed to enter any value without any restriction.
• Whole number. If you choose this option, then the user is only allowed to enter data such as numbers.
• Decimal. If you choose this option, then the user is only allowed to enter decimal data.
• List. If you choose this option, then the user is only allowed to enter the data on the list. The list can be derived from a cell reference or you enter directly into the Data Validation dialog box.
• Date. If you choose this option, then the user is only allowed to enter the data date.
• Time. If you choose this option, then the user is only allowed to enter time data.
• Text length. If you choose this option, then the user is only allowed to enter a long text data with certain characters.
• Custom. If you choose this option, then the user is only allowed to enter the data set using the formula.

4. For choice but List and Custom, you can make arrangements on the Data Options box:

• Between. If you choose this option, then the user is only allowed to enter data with a minimum value to the maximum value that you specify.
• Not Between. If you choose this option, then the user is not allowed to enter data with a minimum value to the maximum value that you specify.
• Equal to. If you choose opasi, the user is only allowed to enter data with the value you specify.
• Not equal to. If you choose this option, then the user is not allowed to enter data with the value you specify.
• Greater than. If you choose this option, then the user is only allowed to enter data with a value greater than the value you specify.
• Less than. If you choose this option, then the user is only allowed to enter data with a value less than the value you specify.
• Greater than or equal to. If you choose this option, then the user is only allowed to enter data with a value greater than or equal to the value you specify.
• Less than or equal to. If you choose this option, then the user is only allowed to enter data with values ​​less than or equal to the value you specify.

5. In this example select Whole number on the box Allow option: Select box option equal to the data. Enter a value of 10 in the text box Value: With these settings, the user is only allowed to enter numeric data with a value of 10.

6. To test the data type in cell A1 with a value other than 10, eg 11. Warning message box will appear as shown below.

Values ​​used in setting the Validation of data can also be derived from the reference cell. With these settings, the validation will always adjust the value contained in the reference cell is used.

1. For example, we will use cell B1 as a reference cell in the Data Validation. Type 10 in cell B1.

2. Block range A1: A5. Select the Data tab> Data Validation> Data Validation. Will Data Validation dialog box appears.

3. Select the Settings tab and then select Whole number on the box Allow option: In the Data option: select equal to. Type = B1 Minimum text box: as in the picture below.

Thus a brief explanation from me about How to Setup Data Validation in Microsoft Excel, may be useful for you all.

How to Edit Data Using the Replace Feature in Microsoft Excel

In the previous post I have explained How to Search Data in Microsoft Excel, so in this post I will discuss about How to Edit Data Using the Replace Feature in Microsoft Excel.To edit existing data in one or two cells alone would be easy for us to do. It only became difficult when we have to edit the data present in many cells. In this example, I will explain how we replace all data Male became Man. 

1. Create a New Workbook (Press Ctrl + N) and then make the data as the example picture I've provided below.

 
2. If you do not select a particular range, then edits the data will be applied to the whole cell. In this example the block range D3: D10 that means edit only applied in the range D3: D10.

3. Select Tab Home> Find & Select> Replace (Press Ctrl + H). Will Appear Find and Replace dialog box Replace tab.

 
4. Type the text that will be replaced in the Find what text box: In the Replace with text box: type in the new data that will be used. If so, press the Replace All to replace all the text in the range that we choose. Then the dialog box will appear as shown below.

 
5. A message box provides information that Excel has done a search and replacement in accordance with the provisions of 5 data that you set. Here I replace Male to Man, and then press the OK button.

 
In addition to changing the data in the entire worksheet or a selected range, you can also change the data contained in the entire workbook. For example, data man in the previous case, we will replace it not only contained in one worksheet. 

1. Select the tab Home> Find & Select> Replace (or press Ctrl + H). Dialog box will appear Find and Replace - Replace tab. 

2. Press the Options >> so the display Find and Replace dialog box will be as shown below.

 
3. Type the text that will be replaced in the Find what text box: Replace with text box: type in the new data that will be used. Select the workbook in korak Within option: Press the Replace All.

4. Confirmation box will appear again, then press the OK button. If Excel can not find the data that should be replaced, it will display a message box as shown below.

 
Thus a brief description of me on How to Edit Data Using the Replace Feature in Microsoft Excel, May be useful for you all.

How to Search Data in Microsoft Excel

After the previous post I have explained How to create a list in Microsoft Excel Data Series. This time I will explain how to search data in Microsoft Excel. Excel 2007 has billions of cells in each worksheet. To find the data one by one in each cell it will take a lot of time and effort. To overcome these problems, you can use the Find feature to speed up the search process the data.

1. Select the tab Home> Find & Select> Find. (Or press Ctrl + H). Find dialog box appears you Find Replace tab.

 
2. Type of data to be searched in the Find What text box: If the data to be searched had been previously entered, click the Find What drop down list:

3. Press the Find Next button. If the data you are looking for is found, then the data will be selected. However, if the data you are looking for is not found, a message box will appear as shown below.

 
4. Press the back button Find Next to search for the same data later. So that we do not need to press the Find Next button repeatedly, press the Find All to conduct a search all data at once. The result will be as shown below.

5. Click one of the lines of the search results. Cells containing the data you are looking for then be selected. If the search data is completed press the Close button.

A few of my brief explanation on How to search the data in Microsoft Excel, may be useful for you all.

How to create a list in Microsoft Excel Data Series

In addition to the data series number or date, you can also create a list of the data series itself. For example, you create a data series name of your company's employees. This technique would be very helpful if the data series are frequently used.1. Press Ctrl + N to create a new workbook. Click the Office Button and then press the button Excel Options. Excel Options dialog box appears.

2. Select the option line and press the Edit Custom List. Custom dialog box will appear List. Enter a series of data in the text box list entries: like the example image below.

 
3. If so, press the Add button. If there is no data series you'll make again press OK. 

4. Will reappear Excel Options dialog box and then press OK.

5. To try typing Roy result in cell A2. Drag the fill handle in cell A2 down until cell A8. The result will be like this.

 
Listing data series can also be derived from the range that contains specific data. For example, you create a list of data series subsidiary contained in range A1: A10.

1. Press Ctrl + N to create a new workbook. Type a company branch data in the range A1: A10 as in the image below.

 
2. Click the Office Button and then press the button Excel Options. Excel Options dialog box appears. Select the option line and press the Edit Custom Lists. Custom Lists dialog box appears.

 3. Import list in the text box cells: Type $ A1: $ A $ 10, the range of sources used in the data series. 

4. The move can also be done by pressing the button on the right of the Import list box From cells: Collapse Options dialog will appear as shown in the example image below.

 
5. Block range A1: A10 (the block is marked with dashed lines) and then press the button. 

6. Reappeared Custom Lists dialog box and then press the Import button. Range of data series that have been entered will look something like this.Press OK

 
7. Will reappear Excel Options dialog box and then press OK. 

8. To try the American Branch of the result type D1. Pull Handle on cell D1 fill down until the cell D10. The result looks like this.

 
Similarly, a brief description of me on How to create a list in Microsoft Excel Data Series. May be useful for you all.

Making Series Serial Data In Microsoft Excel

Serial Data Series is a series of data most commonly used Excel users. Therefore, Excel provides a special technique to allow users to create data series number, for example using the key combination Ctrl to speed up the manufacturing serial number of the data series.

1. Press Ctrl + N to create a new workbook. Type the initial value of the data series in cell A2, such as type 1. Place the pointer in cell A2.

2. Move the pointer on the black frame in the lower right corner of cell A2 (fill handle). Click and hold the deed and then pull down the handle to the cell A11.

 
3. Range A2: A11 initially be charged the same data, ie 1. To transform the data into a series of sequential data click the AutoFill Options drop down menu and select Fill Series. As shown below.

 
To Make the serial number of the data series quickly use the Autofill feature in combination with the Ctrl key on the keyboard as you pull the Fill Handle. Type 1 into cell B2 as the initial value of the data series. Press and hold down the Ctrl key. Drag Fill Handle to cell B2 down to B11 cells. The result looks like the picture below.

 
You also can create a data series with a serial number of a certain multiples. For example, you create a data series starting from 1 to 15 in increments of 2.

1. type 1 as the initial value in cell C2. Because the serial number is any multiple of 2, type 3 into cell C3.

2. Block Range C2: C3 then drag the fill handle in cell C3 down to the desired value.

 
A few brief explanation of my series on How to Make Serial Data In Microsoft Excel, May be useful for you all.

Entering Data Using Pick From Drop Down List

Besides using AutoComplete feature, we can also display a list of previously entered text in the cells that are actively using the Pick From Drop Dwon List. According to the authors, this method is relatively easy because all the data displayed (not just the text that have the same initial letter).

1. Create a new workbook (press Ctrl + N) and create data in the range A1: A3

2. Place the cell pointer padaq A4. Click the right mouse button then select Pick From Drop Down List.

 
3. In cell A4 and then display a list of text that has been entered previously.

 
4. Select the data to be entered using the mouse or keyboard and then press Enter.

Here's my explanation of how sedikt Entering Data Using Pick From Drop Down List may be useful for you all.

Using the AutoComplete feature

AutoComplete is a feature that is used to display a list of texts that have been put in the cell that is active. List of text will be displayed when entering new data if no initial letters (not necessarily 1 letter) with the same text that was typed in the active cell.

1. Create a new workbook (press Ctrl + N) and create data in the range A1: A3 as the example image below.

 
2. If you type P in cell A4 the AutoComplete feature will automatically display the man because the initial letters beginning with the letter P same Pria who had entered in cell A1.

 
3. Press the Enter key when the data you enter is the man. If the data you entered is not a man, then continue typing the data as usual.

AutoComplete feature is very helpful when entering many of the same data in a single column. However, there are some users who just do not like this feature because it makes the display AutoComplete sometimes we do not focus on entering data.

• Click the Office Button and then press the button Excel Options. Excel Options dialog box appears.

 

• Select the Advanced option. Remove the tick mark (√) the option Enable AutoComplete for cell values ​​and then press OK.
• To try it, type P in cell A4. If the man does not appear in the text cell A4, then was off in the AutoComplete feature.

insert Symbol

Not only in Microsoft Word, When creating reports using Excel sometimes we also need to enter a particular symbol. For example, the sigma (Σ) used debagai symbol for the number of the data series.

1. Click the tab Insert> Symbol Symbol dialog box then appears.

 
2. Select a symbol to be inserted into the cell and then press the Insert key. Do the same for the other symbol.

3. If no symbol to be entered, press the Close button.

 

Thus a brief description of my input data, may be useful for you all.

Undo and Redo feature in Microsoft Excel

After I explained briefly about Copying data in Microsoft Excel in a previous post, this time explaining what it is I kana Undo and Redo in Microsoft Excel.

Undo is a feature that is used to cancel orders that have been done before, while redo is used to repeat the Undo action ever canceled. Undo and Redo feature is not only applicable to input and edit the data. But you can also use the Undo feature to cancel the orders he had ever run, for example, you can cancel an order setting column widths before.

Here I will give three examples of the usefulness of the Undo and Redo:

1. To cancel orders that have been done previously contained Undo button in the Quick Access Toolbar, or press the key combination Ctrl + Z.

2. To cancel an order was made some levels simultaneously click the drop down button and select the Undo command to be aborted.

3. To repeat actions that have canceled Undo, Redo button or press the key combination Ctrl + Y.

That's the short explanation from me about Undo and Redo feature in Microsoft Excel, may be useful for you all.

Copying data in Microsoft Excel

After the previous post I have explained How to Edit and Delete Data In Microsoft Excel, this time I will explain how Copying data in Microsoft Excel. Ok, you can copy the data into a cell or range, if the data is already present on the cell or range to another. By copying the data, you do not need to type the same data over and over again so as to save time and effort.

1. Select the cell or range you want to copy. Select the Home Tab > Copy or press Ctrl-C. Cell or range you want to copy is marked with dashed lines.

2. Place the pointer on the desired cell, then select the Home tab > Paste or press the key combination Ctrl = V.

Similarly, a brief explanation of my About Copying the data in Microsoft Excel, maybe even Just a bit of explanation, but I hope to have very much to you all.

How to Edit and Delete Data in Microsoft Excel

There are 4 ways to emlakukan Edit and Delete Data In Microsoft Excel, the data you have entered into a cell sometimes not as expected. This can happen for many reasons, for example due to misreading or typo. Following steps to fix (edit) data in a cell:

1. Press the F2 key or double-click the cell you want to edit the data. Excel will then display the selected cell in edit mode.

2. Type the desired data and then press Enter. At the time of editing, press the Delete key to delete a character to the right of the insert. To erase the data on the left line insert, press the Backspace key.

3. In addition to the above, you can also edit the data by overwriting data with new data Lam. Place the mouse pointer on the cell you want to change the data. Type the new data, and then press Enter.

4. To delete data place the cell pointer to delete the data, and then press the Delete key on the keyboard.

May be useful for you all .... !!!!

Input Data in Microsoft Excel

Doing Before processing the data, you must first enter data into a cell. Following steps to enter data into a cell:

1. Select the cells that will be used to store data using a mouse or keyboard.

2. The process input data must be adapted to the type of data to be entered. The following provisions of the input data based on the type of data:

- Text. To enter text data as the data type when you type in a word processing application (Microsoft Word 2007), for example, type Computer sales data.

- Figures. To enter numeric data type in the data to be entered without the thousands separator.

If the data entered in the form of a decimal number, use a period (.) Or commas (,) depending on regional settings you use, for example, 125 414, 123.

To enter a negative number, enclose the number in parentheses () or a prefix number with a minus sign (-), for example, 125 414, 123

To enter a fractional number starts with a zero (0) and a space, then type a fractional number to be input. For example, to enter a fractional number 3/5 type 0 3/5

-Date. To enter data on use slashes (/) or hyphen (-) to separate the day, month and year, for example, to enter a date 5 September 2009 type 09/05/2009.

- Time. To enter data use a colon (:) to separate hours, minutes and seconds, for example, to enter the time at 10 over 32 minutes typing 10:32.

- Cell reference. You can enter the data from the reference cell address. Excess data from the reference cell address is the data will always be updated if there are changes in the source cells. You can also enter the data of the reference cell located in another worksheet.

To enter data from a cell reference we type an equal sign (=) followed by the reference cell is used. For example, to enter data from cell A1, type = and then select cell A1 using the mouse or the keyboard naviasi. Cells used as a reference indicated by a dotted line. In addition, the formula bar will also display the address of the reference cell is used.

3. Enter data according to the type of data, and then press Enter. To cancel the data input, press the Esc key.

Protection Open and Modify Workbook in Excel

When saving a workbook, you can protect the workbook so that can not be opened or modified in any person. To open or modify the workbook, the user must enter the appropriate password.

Please see the following ropes:
 1. Click the Office Button menu and then Select Save to save the new workbook, or Save As to save the workbook with a different name. Will display the Save As dialog box.

2. Click the drop down button and select the menu Tools General Options.

 
3. Appears General Options dialog box. To protect the workbook can not be opened so that any person, enter the password in the Password to open text box:

4. To protect a workbook that can not be modified any person, enter the password in the password text box to modify: Press the OK button.

 
5. Confirm Password dialog box appears. Enter the password used to protect open workbook. Press the OK button.

6. Confirm Password dialog box appears. Enter the password used to protect modification workbook. Press the OK button.

7. Save As dialog box appearing. Type a file name in the File name text box: and then press the Save button. Each open workbook protected, Password dialog box appears as shown below.

 
8. At the prompt Password:, type the password you will enter when protecting the workbook. Press the OK button.

9. If you are using correct password, the password dialog box appears to open the workbook protection modifications.

10. At the prompt Password: type the password that you enter when protecting the workbook. Press the OK button. If you enter the correct password, workbook modifications can be made.

11. If you forget the password used to protect, press the Read Only to open the workbook. If there is a change in the contents of the workbook, save the workbook with a different name.

So first a brief description of my protection and Modified Open Workbook in Excel. May be useful for you. And that certainly saay will give the other tutorials on post-post next.

Understanding and managing Workbook

Before I explain in more detail about what it workbook, you must first know what to do. Below are some tutorials which I will explain in detail to you. Ok we just started.

1. Creating Empty Workbook 
Workbook is a document or workbook in Excel 2007 program consisting of one or more worksheets. When running Excel 2007 for the first time, by default it will be made with a blank workbook Book1 naam. You can also create a new blank workbook in Excel 2007 when the program is running.

• Click the Office button> New, then New Workbook dialog box appears. 
• In the Templates list box, select Blank and recent. Select Blank workbook, and then press the Create button. 
• You can also create a blank workbook faster using the key combination Ctrl + N on keyboard.Maka will look like in the picture below.

2. Save a Workbook 
If you are finished managing data, workbook should be saved so that your work is not lost. You can save a workbook on a variety of storage media such as Hard Disk or USB Flash Disk. By default, workbooks saved Excel workbook file format (*. Xlsx). While supporting many new features, the file format can not be opened in Excel 2003 and earlier versions of Excel. Therefore, some users still prefer to use Excel 97-2003 workbook file format (*. Xlsx). To note if you save the workbook with the XLS file format is not all of the features of Excel 2007 can be used.

• to save the workbook click the Office Button> Save, or press Ctrl + S. Save As dialog box appears.

 

• Select the folder where the workbook. The selected folder will be displayed in the Save in box:
• Type a file name in the File name text box: Select the file format in the Save As type box: If so, press the Save button. 
• If there are changes to the workbook because of the editing process, these changes should also be recorded. Click the Office button> Save or press Ctrl + S. Storage process next workbook will not display the Save As dialog box for workbooks have been called earlier.

3. Saving Workbook by any other name 
To save the workbook with a different name, do the following steps. 

• Select the Office Button> Save As. Save As dialog box appears. 
• Select the folder where the workbook. Type a new file name in the File name text box: 
• Select the type of workbook on the Save as type box: Then hit Save.

4. Change the Default Folder Storage. 
You save a new workbook by default be stored in the My Documents folder. You can make arrangements to change the default folder for storing the new workbook.

• Click the Office Button and then press the button Excel Options. 
• Excel Options dialog box appears, select Save. Type the address of the default storage folder in the text box Default file location:, for example, C: \ Users \ COMPAQ \ Documents.

• Press the OK button to save the settings. After that, the next time you run Excel first time and it will save the new workbook, the workbook is saved in the Reports folder.

5. Closing Workbook 
The completed workbook used should be closed to avoid any possibility of undesirable events, such as the data in the workbook are accidentally deleted. To close the workbook, select one of the following ways:

• Click the Office Button, then press the Close button. 
• Press Ctrl + W key combination on the keyboard.
• Click on the Close icon contained in the workbook Title bar.

If the workbook has not been saved yet been no change since the editing process, a message box appears, as shown in the figure as below.

 
A message box provides information that has been no change workbook because the editing process. Press Yes to save the changes. If the results do not change you want to save press the No button.

6. Setting the recent Display Documents 
When finished using the workbook, the file name will be displayed in recent documents. You can re-open a new workbook used in the Recent Documents list can be set as desired.

• Click the Office Button and then press the button Excel Options. Will Excel Options dialog box appears.

 

• Select the Advanced Options. Type the number of the file name that will be displayed in the text box Show this number of Recent Documents: If the new file name you want to use does not appear in the Recent Documents, fill with niali zero (0). Press the OK.

Actually there are many more that I want to explain, but not today. Which of course I will explain in subsequent postings.Hopefully useful ....!!!