How do I transfer a filter drop down box to another cell?

A

Angela

Hi,
I have a spreadsheet that I filtered the questions in Column A, but I want
the drop down box from the filter to be in C1, is this possible? Reason
being is I want to hide Column A but do not want to hide the drop down box...
thanks in advance :))
Angela
 
L

Luke M

I don't think what you're asking for is possible.

Possible alternative?
Change the font color of column A to match cell background (white), and then
reduce column size to match size of filter button. Would give an appearance
of an empty column.

If you don't want people entering data in the column, you could try
protected those cells, and then protect the sheet.
 
E

Eduardo

Hi Angela,
Right click in your mouse and hold it, then move the box where you want to
see it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
How to delete a drop down box in Excel 2007 1
Viewing drop down box for a filter 2
Selecting multiple values from a drop down list box 5
Auto filter drop down box 1
Excel Drop Down Box 2
Filter a Drop List ? 1
Excel Excel: How do I put a formula in a drop down list 11

Top