data validation shortcut key for mac in excel

In Excel, you can change the dropdown list by highli ghting the text and then pressing F2 (or using the keyboard shortcut Ctrl+F2).ĭrop down lists are a staple of spreadsheet applications and can be used for a variety of tasks. This will open the Text Box Properties dialog box.

Next, click on the Home tab and click on the Text Box Properties button. Simply highlight the entire drop-down list, and then use the shortcut keys (Ctrl+A or Cmd+A) to select all of the text. If you need to change the drop-down list in Excel, it's easy to do. This selection can further influence the values in another list by presenting options that relate to the first choice.To begin with, the first drop-down list's Items list might present A list of product categories that produces a secondary list of product models.For this function to work, the first drop-down list must be based on relevant constraints for cycle ranges set up in Ex cel.

Once you’ve read the article and you understand what each shortcut does, spend two or three minutes per day practicing until you know them by heart.The Data Validation feature in Excel 2019 offers a List option to confine selections in a cell to a preconfigured series of values. I will go through each of these in detail but to learn them faster, start by printing the commands out or writing them down. Luckily, after spending thousands upon thousands of hours in Excel I’ve narrowed down the field to the most valuable ones on your behalf. It would be great to memorize all of those shortcuts but for most people that isn’t feasible. This lets you keep your focus where it belongs - on the problem you’re trying to solve.Įxcel is designed for power users, and as a result, there are hundreds of delectable keyboard shortcuts that you could learn (especially on Windows). Using shortcuts allows you to outsource functions like copy and paste from your conscious mind (using a mouse) to your unconscious mind (muscle memory).

Much like graduating from hunt and peck to touch typing, using keyboard shortcuts frees up your brain from the distraction of target acquisition.

12 keyboard shortcuts that will make you better at ExcelĪsk a software developer, banker, writer, or really anyone who types professionally and they will sing the praises of keyboard shortcuts.

Data validation shortcut key for mac in excel