Many ways to Copy data or content in MS Excel

See Previous Post: Data Validation button Data Tools group Microsoft Excel 2016

There are numerous ways to copy data or content in Microsoft Excel. But, before knowing the various ways, First of all we must know that, what is Copy ? For what purposes Copy is used ? And, How to do Copy ?

Hence, we can say Copy is type of cloning of any data in Excel. Whether, it is a Number, Text or any Picture etc; we can create a same type of exact data of these. The amount of data which could be copied, could be single or more than single.

Notably, the purpose that Copy shows is to make a duplicate of data. Also, by this way, Copying data helps to save time and effort. Significantly, it also saves redo of the tasks. Especially, not only in Microsoft Excel, copying of data is done, in almost every software program. So, the types of ways and steps to copy data in Excel are shown below.

Various ways to Copy data or content Excel – continued

First of all, click on the cell having data in it. Then click on the Copy button from the Clipboard group. Next, click anywhere on any of the cell in worksheet. And then click the Paste button.

Secondly, select the cell which has the data. Then, press the Right click Mouse button. A Menu with a list of options will pop up. And, then Left click on the Copy option from the Menu List. Next, again Right click with the Mouse button and select Paste option from the Menu List.

Thirdly, click on the cell having content in it. Then, press the Shortcut Key from the Keyboard i.e. (Ctrl+C) to Copy. Next, click anywhere on any cell in sheet. And then press the Shortcut Key i.e. (Ctrl+V) to Paste.

Several ways to Copy data or content Excel 2016

Fourthly, click on the cell which has the content. Also, users could select a range of cell having data. Then, press the Menu key or known as Application key. Next, press the “C” key from the Keyboard to Copy. Now, click on any cell anywhere in the worksheet. Then, again press press the Menu key and Press the “P” key from the Keyboard to Paste.

Furthermore, click on the cell having text or number etc. Then, Press the “Alt” key from the Keyboard to activate the Shortcut with Underscore keys. Next, Press the “H” key for the Home tab ribbon to activate.

And, then again Press the “C” key two times to Copy by activating the Copy Button. Now, click somewhere in the other cell in sheet. Lastly, Press the “Alt”, then “H”, “V” and “P” keys to Paste.

See Next Post: Various ways Cut data content worksheet Microsoft Excel 2016

Data Validation button of Data tab Excel 2016

See Previous Post: New Query button description Get Transform group MS Excel 2016

In this post, we’ll discuss further about the Data Validation button. This button is part of the Data Tools group. And, the Data tab ribbon has this group. So, this group has seven (7) buttons. The buttons are the Text to Columns, Flash Fill, Remove Duplicates and the Data Validation etc.

Also, are the Consolidate, Relationships and the Manage Data Model buttons etc. So, out of these, the Data Validation button mentioned, is the topic of our explanation. Notably, this button has the Drop down Menu. And, also this button contains two buttons.

These are the Circle Invalid Data and the Clear Validation Circles buttons. Markedly, the Data Validation button shows a pop dialog box, when clicked. This box contains three tabs. These are the Settings, Input Message and the Error Alert tabs.

Data Validation button of Data tab MS Excel – continued

So, the Settings tab of Data Validation dialog pop up box has the Validation Criteria group section. Further, below this the Allow combo box and Data combo box button are present. Firstly, the Allow button has the list of choices of certain criteria. These are the Any Value, Whole Number, Decimal, List, Date, Time, Text Length and the Custom Criteria.

And, the Data combo box contains the Between, Not Between and the Equal To comparison operators etc; and so on. Also, it has the Not Equal To, Greater Than and the Less Than etc. Additionally, are the Greater Than or Equal To and the Less Than or Equal To etc.

Data Validation button of Data tab MS Excel 2016

Further, the Input Message tab of Data Validation dialog box has the Title and the Input Message text boxes. Significantly, in this box users can input there personal messages. And, the messages specified in the Input Message box shows up when the cell is selected by user.

Next, the Error Alert tab of Data Validation dialog box has the Style combo box button. Also, it has the Title text box and the Error Message text box. So, the Style button has a list of three message choices. These are the Stop, Warning and the Information.

While, setting the Data Validation rules for the cells, the type of error message should be selected and defined. The Clear All button present at the bottom of the Data Validation box helps to clear the defined rules. Lastly, Circle Invalid Data button shows a circle over the cells having the invalid data. While, the Clear Validation Circles button helps users to remove the circles showing over the cells.

See Next Post: Multiple ways Copy data content worksheet Microsoft Excel 2016