Data validation (input message)

%3CLINGO-SUB%20id%3D%22lingo-sub-2945417%22%20slang%3D%22en-US%22%3EData%20validation%20(input%20message)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2945417%22%20slang%3D%22en-US%22%3E%3CP%3EPls%20assist%20how%20can%20i%20copy%20and%20paste%20data%20validation%20from%20column%20HF-HI%20to%20HJ-HM.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Julius575_1-1636506340868.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325837i22064EC8A38F43EB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Julius575_1-1636506340868.png%22%20alt%3D%22Julius575_1-1636506340868.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2945417%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2945724%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20(input%20message)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2945724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1049438%22%20target%3D%22_blank%22%3E%40Julius575%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EShould%20work%20with%20all%20versions%20of%20Excel%2C%20It's%20quick%20and%20painless%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CU%3ECopy%20cells%20with%20data%20validation%20with%20shortcuts%3C%2FU%3E%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%20class%3D%22%22%3ESelect%20the%20cell%20or%20range%20of%20cells%20and%20press%20Ctrl%20%2B%20C.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ESelect%20destination%20and%20press%20Ctrl%20%2B%20V.%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Pls assist how can i copy and paste data validation from column HF-HI to HJ-HM.

 

Julius575_1-1636506340868.png

 

1 Reply

@Julius575 

Should work with all versions of Excel, It's quick and painless

 

Copy cells with data validation with shortcuts

  1. Select the cell or range of cells and press Ctrl + C.

  2. Select destination and press Ctrl + V.

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)