Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


Excel Drop Down List

To create an Excel drop down list has become extremely easy and no longer requires any programming. You can simply make use of the Data Validation Tool.

If you want to create a simple dropdown so that a user chooses only one of 3 departments e.g. Department A, B or C you can follow these steps:

  • Click on the cell or cells you want the drop down to appear in
  • Go to the Data Ribbon and click on Data Validation.
  • In the ‘Allow’ box, choose the List option
  • In the Source, one way of creating the list is just to type it separated by commas e.g. A,B,C
  • Click OK
Excel drop down list

Now when someone clicks on one of these cells a drop down arrow will appear and when clicked will show only the A, B, or C. The user can choose one of them but if they type a D for example, it will not be allowed.

For lists that require more options e.g. a drop down list of employees in the company, you may not want to type it in manually in the Data Validation tool. In this case you can set up the list in a separate sheet and then refer to the list in the source instead if typing them out.

The process is the same except that instead of typing the list you highlight the cells that contain the drop down list.

Excel drop down list

You can now link formula to these cells confident that users will use the correct spelling of the values.

Drop down list then Excel lookup