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 |