Windows 10: Converting and Excel with Dropdown search box to work on a mac

Is there a way to get an excel created in windows to work on a mac if it include macros and a dropdown search box?

:)

 

[Mac] CMD key /search icon /search box on taskbar don't work in .351?

Hi guys,

After updating my Windows 10 to .351 I can no longer use the [Windows] (CMD key on Mac) key / search icon / search box on the taskbar. Any suggestions how to tweak this issue? TIA

Cheers

 

search box

Hi,

Thank you for posting your query on Microsoft Community.

I appreciate your interest in Windows 10.We sincerely regret for the inconvenience caused.

I suggest you to follow the below steps and check if are able to find search box.

• 
  Right click on the task bar.
  
• 
  Go to Cortana.
  
• 
  Click on show search box.
  

Now check if you are able to find search box.

Please let us know if you need further assistance.

Thank you.

 

Help needed with Excel Attendance Sheet

You use the Data tab, Data validation facility to do this.

If you want a coherent explanation then look in Excel Help. Here's the relevant extract from Excel 2007 Help. Excel 2007 Help - Data Validation.pdf

My example:
- I have written them in what seems to me to be the order of easiest explanation.
- You'd actually set them up in the reverse order - step 3, step 2, step 1.

1 The result - my dropdown list. I select the cell then click on the dropdown arrow that appears next to it.




2 To set this up, select the whole column [or individual cells] where you want the dropdown to appear then click on the Data tab then the Data validation control. You need to
- select In-cell dropdown
- set the Allow entry to List
- in Source, enter the worksheet name & cell range where you have written the allowable entries - you will generally want to use absolute cell references such as those shown [$ in a cell address means absolute and will not vary as you copy the formula all the way down your column - look this up if you are not familiar with it because it needs a bit of getting used to].




3 Write out the list of allowable entries that will appear in your dropdown list.




Job done.

Denis