0

What's the best way to allow users to easily copy data from one cell and apply it to other cells, without using key combinations?

I was thinking about dragging cell borders horizontally or vertically to apply data to adjacent cells, but the cell is also a drop-down, so I don't know how to activate those borders without expanding the drop-down.

Context: this is a form to request new hires with different schedules.

enter image description here

  • You can make a button "Apply to other days" which would copy the data to other cells. I 've seen such a thing somewhere. – UXP Dec 7 '17 at 9:41
0

What is the user goal of the dropdown-menu?

If i understand it correctly, it's about gathering schedules for which new hires can apply? What about utilizing the Google Calendar drag-feature for creating time blocks and creating a week-calendar view for each unique hire?

  • Hi thanks for looking into this. This is a form for hiring manager to request new hires from Recruiting department. In this form Hiring Manager should define which shifts each new hire will work. In this case Hiring Manager requests 8 new positions (4PT and 4FT) and he should select days and shifts for each position. So that Recruiter can later offer a candidate different options to choose from. – Emiliia Dec 7 '17 at 17:52
  • Okay. I'm still not really sure if the dropdown-menu is the best method for inputting time-slots. This way there are a lot of options to choose from for the Hiring manager. – Rick P Dec 8 '17 at 11:03
  • In the drop-down Hiring Manger will have options of standard shifts: Day, Swing, Grave and Other for non-standard shifts, that's where you can type time manually. – Emiliia Dec 8 '17 at 18:58
0

First Highlight the Cells you want to copy to , then use single paste function

enter image description here

enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.