Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I transfer a filter drop down box to another cell?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I transfer a filter drop down box to another cell?
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Angela" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I transfer a filter drop down box to another cell?
Hi Angela,
Right click in your mouse and hold it, then move the box where you want to see it "Angela" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists to transfer data between worksheets | Excel Worksheet Functions | |||
How to define a drop down row filter in cell C2 for cells C3:C27 ? | Excel Discussion (Misc queries) | |||
customers from the drop down ist will not transfer to invoice | Charts and Charting in Excel | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down Filter | Excel Discussion (Misc queries) |