![]() Go to “ Error Alert” tab and write the message in the box of “ Error Message” Input Error and click on ok.Go to “ Input Message” tab, in “ Input Message Box” type “Enter only the month name”, the message box will appear near to the cell.In “ Settings” tab from the Allow drop down list select List then source tab will get active click on source tab and select the range A2:A13.Data Validation dialog box will appear.Select the cell C3, go to in “ Data” tab select Data Validation in the Data Tools group.To create the Month drop down list follow below given steps:. I have a table of month in Column and we want to create drop down list in cell C3. Let’s take an example and understand how we can copying and pasting the validation list only in Microsoft Excel. ![]() Paste Special: You can use the Paste Special to paste the specific cell content or attributes such as formula, formatting, comments etc. If you want to copy only the validation criteria, use Paste Special. When copying a cell that contains validation criteria to a different cell, the criteria are copied along with the text formula and format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |