| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 119915 | 2011-08-16 09:45:00 | Excel Help - Hide drop down list cell | WarNox (8772) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1223705 | 2011-08-16 09:45:00 | 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. |
WarNox (8772) | ||
| 1223706 | 2011-08-16 10:46:00 | Move the cell to the right hand side off the printable area. | Snorkbox (15764) | ||
| 1223707 | 2011-08-16 12:11:00 | 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. |
WarNox (8772) | ||
| 1223708 | 2011-08-16 22:18:00 | Try searching edu sites like this (www.google.co.nz 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. | kahawai chaser (3545) | ||
| 1 | |||||