Moving and Copying Data and formulas in Excel

Hello friends how are you today we are learned about copying and paste feature of Excel. Actually copy and paste is not only two commands. Excel used the maximum feature of copying and paste function than the other software. So let’s start.

Copying cell contents by dragging and dropping: -

The easiest way to move or copy a cell or range of cells is to drag the cell or the range of cells to the new location and drop it.

1. Select the cell or range or range of cell you want to move.
2. Move the mouse pointer over the selections border. The pointer changes to an arrow.
3. Drag the pointer and the gray outline of the selection to the new location. Drag past the edge of a window scroll. Go to the point where you want to paste the data.
4. When you rich to the point where you want to paste the data simply release the mouse button when the gray outline is where you want to place the selected range.

To copy cell’s contents using drag and drop, do this:

1. Select the range of cells you want to copy.
2. Hold down the Ctrl key and move the pointer over an edge of the selection. The pointer becomes an arrow with a + (plus) sign.
3. Continuing holding down Ctrl key as you drag the edge of the selection to where you want the copy. The copy’s location appears enclosed by a wide gray border.

Using the drag-and-drop method, you can make only a single copy. You cannot copy to multiple locations or fill a range.

If you release the Ctrl key before you release the mouse button, the copy operation. The plus sign next to the arrow disappears. You can press Ctrl key again to switch back to copy operation.

Copying data across a Workbook:

1. Select the cell or range of cells you want to copy.
2. Click the Edit menu and choose Copy. Alternatively, click the Copy button on the standard toolbar or press Ctrl + C. The cells to copy appear, surrounded by marquee.
3. Select the worksheet to which you want to move data.
4. Select the cell at the at the top-left corner, where you want the duplicate to appear.

Using Data validation

Another great feature of Excel is data validation its validate data controls the creation of input criteria for a cell or range of cells. It can prompt a user for correct information or can display an error message if the data entered does not match the criteria.

To specify the data validation settings, do this:

1. Select a cell or range of cells for which you want to validate.
2. Click Data menu and choose validation….. .
3. In the data validation dialog box, click the settings tab property sheet.
4. Select the type of data to be validated from the Allow drop-down list.
5. Select an operator for validation from the data: drop-down list.
6. Enter the appropriate values in Minimum and Maximum: collapsable box.

To Specify an input message, do this:

1. Click the input message tab in data validation dialog box after specifying the settings property sheet.
2. Click and select the Show input message when cell is selected.
3. In the Title box enter a title for the message it is displayed in bold in the message box.
4. In the Input message: box enter a message this message is displayed below the title. The length of the message is up to 255 characters long. Press enter to start a new text in the message.
5. Click OK to save your settings.

To specify an error alert, do this:

1. Click Data menu and choose Validation…. .
2. Click the Error Alert tab in the data validation dialog box after specifying your settings property sheet.
3. Click the Show error alert after invalid data entered, so that the check box is checked.
4. Select a Style: for the message from the drop-down list.
5. Enter a title for the message in the Title: box.
6. Enter the text for the error message in the Error message: box.
7. Click OK to save your settings.

For check the criteria you select for your data validation select a cell which is under validation and then check the input message is appeared or not then enter a wrong data in this cell and press enter if error message is appeared then you success and it means which criteria you select is working.

So friends keep practicing for data validation it is very important for future use.

Auto Correct option in Excel

Excel has a great flexible feature of auto correct option which is the most important option which is commonly used in office and now those days it is used worlds wide. Auto correct will used for common typing errors and automatically corrects them as you type, it is also correct two initial capitals. You can also use Autocorrect in expand abbreviations means when you type incl, Auto automatically expand it to include. Autocorrect option is flexible because you can manage the Autocorrect option yourself.

To add AutoCorrect entries manually, do this:

1. Click the tools menu and choose AutoCorrect….. . The Auto correct dialog box appears.
2. In the replace text box, type the error or abbreviation as you usually type it.
3. In the with text box, type the correct spelling of the word or phrase or expansion of an abbreviation.
4. Click Add button to add the new entry to the list of Autocorrect entries.
5. Repeat all the steps from 2 for add more entries.
6. When you finished your work then click on the OK button.

To delete an Autocorrect entry, do this:

1. Click tools menu and choose Autocorrect….. . The Auto correct dialog box appears.
2. Select the entry you want to delete.
3. Click delete.
4. Repeat the steps from 2 how many entry you want to delete
5. When you complete your work click on the OK button.

To customize Autocorrect, do this:

1. Click the Tools menu and choose Autocorrect….. . The Autocorrect dialog box appears.
2. To turn off an option click on the check box you want to turn off the option.
3. When you finished making changes, click OK button.