Monday, August 18, 2014

Create a drop-down list with color - Microsoft Excel in Mac



  1. On a new worksheet, type the values that you want to appear in your drop-down list. They should be in a single column or row without any blank cells (for easy to use, it is recommended to sort your values).
  2. Select all of your values, right-click, and then click "Define Name"
  3. Then it will prompt up a "New Name" window. Type a name for the values of your drop-down list and then click "OK". (No space in the name. )
  4. Select the cells that you want to have drop-down list.
  5. Click Data Validation.
  6. In the settings tab, select "List" from Allow box
  7. From the source field, type equal sign (=) and immediately followed by the name you defined in step 3.
  8. Click OK to confirm.
Apply the Conditional Formatting to color coded the drop-down list values.

  1. Highlight the cells you want to have drop-down list.
  2. Then click "Conditional Formatting" --> New Rule.
  3. Select "format only cells that contain"
  4. Edit your condition in the session called "Edit the Rule Description".
  5. Click "format" button to select your desired color in cell.

Wednesday, August 13, 2014

Mac Excel (in Microsoft Office) -- increase numbers +1 by dragging

You just need to do the following:

  1. Highlight a cell 
  2. Move your curse to the lower right hand corner so that the curser will change to a "cross" with dark in colour
  3. Move the curser down by dragging the cell with  "alt/option" key on hold
  4. Next cell will have a value increased by one from previous value.