PDA

View Full Version : Excel Help - Hide drop down list cell



WarNox
16-08-2011, 09:45 PM
Hey,

Basically I've got an Invoice/Quote form template, which has a drop down list where it pulls the Customers from another sheet. This auto fills the customer name, address, email... It uses VLOOKUP to get the values.

This works fine, but it means that one column in the Customers table has to have unique values. Not a problem but I do not want this 'unique' column displayed anywhere on the Quote/Invoice. I just want it used to fill in the other values.

Tried googling this but cannot find how to hide this cell or somehow make it invisible.

Attached is the photo to help explain my case. Crossed with the red line is the cell I want to somehow hide.

Thanks for any help.

Snorkbox
16-08-2011, 10:46 PM
Move the cell to the right hand side off the printable area.

WarNox
17-08-2011, 12:11 AM
Move the cell to the right hand side off the printable area.

haha yea, that would work but the template goes to the margins on either side.

kahawai chaser
17-08-2011, 10:18 AM
Try searching edu sites like this (http://www.google.co.nz/#hl=en&q=site:edu+%2Bexcel+vlookup+table+%2Bhide+remove+d rop+down+list&oq=site:edu+%2Bexcel+vlookup+table+%2Bhide+remove+ drop+down+list&aq=f&aqi=&aql=&gs_sm=e&gs_upl=33428l35846l32l36184l4l4l0l0l0l1l330l936l2-1.2l3l0&bav=on.2,or.r_gc.r_pw.&fp=884bb1a5381cdf6e&biw=1024&bih=473); They tend to have advanced tutorials. Disadvantage generally in pdf, and quite large file size.