Share via

Data Validation Box

Anonymous
2024-02-22T22:12:20+00:00

Hello -

I have an excel spreadsheet where I am using the Data Validation drop down box but I noticed that once I click on the end box it is now showing up on the following sheet.

I have selected the column and dragged it to the left to fit, I have tried changing the margins to narrow and have moved the margins around from the original setting but nothing has pulled the dropdown box from being on the next page.

Does anyone have a solution to getting the dropdown arrow onto the same page as the dropdown menu?

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. HansV 462.6K Reputation points
    2024-02-22T22:45:30+00:00

    I don't have Office 2019 anymore. I hope that someone else who has Office 2019 can comment on this problem.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-02-22T22:40:59+00:00

    I am using Microsoft Office Professional Plus 2019 and it is updated to the latest version of Microsoft 365 and Office.

    Was this answer helpful?

    0 comments No comments
  3. HansV 462.6K Reputation points
    2024-02-22T22:21:44+00:00

    Which version of Excel/Office are you using? This doesn't happen in my version of Excel, in Microsoft 365:

    Was this answer helpful?

    0 comments No comments