Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding information
I've searched through and seems no one else is having my problem. At the
bottom of my sheet I have a list of names that goes into a drop down list. I go into format cells -- custom and put in ;;; and it hides the names but when I click the drop down box where they go the names are still there. That is what I want. Now I have another list but it is numbers, that go into another drop down list. When I go to format cells -- custom and put in the ;;; it to hides the numbers but when I click the drop down box for the numbers only it is blank. I can scroll down and click a blank spot and the number appears in the cell. My question is why are words showing up in my drop down lists but when I have a drop down list of numbers the numbers do not show up? I know they are there I just can't see them. And how do I fix this? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding information
First, I confirm the odd behaviour - I see exactly what you see
A couple of suggestions 1) hide the rows the data, OR 2) format the data so that the font and the background are the same, and hence the data is invisible, OR What you cannot do is move the data to another sheet. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hbaublit" wrote in message ... I've searched through and seems no one else is having my problem. At the bottom of my sheet I have a list of names that goes into a drop down list. I go into format cells -- custom and put in ;;; and it hides the names but when I click the drop down box where they go the names are still there. That is what I want. Now I have another list but it is numbers, that go into another drop down list. When I go to format cells -- custom and put in the ;;; it to hides the numbers but when I click the drop down box for the numbers only it is blank. I can scroll down and click a blank spot and the number appears in the cell. My question is why are words showing up in my drop down lists but when I have a drop down list of numbers the numbers do not show up? I know they are there I just can't see them. And how do I fix this? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding information
Place the list of names on another worksheet then name that list with
InsertNameDefine Your DV source would then be =MyList You can hide the sheet with the list if you don't want to see it. Gord Dibben MS Excel MVP On Tue, 30 Jun 2009 09:06:01 -0700, hbaublit wrote: I've searched through and seems no one else is having my problem. At the bottom of my sheet I have a list of names that goes into a drop down list. I go into format cells -- custom and put in ;;; and it hides the names but when I click the drop down box where they go the names are still there. That is what I want. Now I have another list but it is numbers, that go into another drop down list. When I go to format cells -- custom and put in the ;;; it to hides the numbers but when I click the drop down box for the numbers only it is blank. I can scroll down and click a blank spot and the number appears in the cell. My question is why are words showing up in my drop down lists but when I have a drop down list of numbers the numbers do not show up? I know they are there I just can't see them. And how do I fix this? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding information
Bernard,
Thanks for the help. Indeed that is very odd. I hadn't even thought to just hide the row because I was trying to hide like I had done the names. Thank you once again. "Bernard Liengme" wrote: First, I confirm the odd behaviour - I see exactly what you see A couple of suggestions 1) hide the rows the data, OR 2) format the data so that the font and the background are the same, and hence the data is invisible, OR What you cannot do is move the data to another sheet. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hbaublit" wrote in message ... I've searched through and seems no one else is having my problem. At the bottom of my sheet I have a list of names that goes into a drop down list. I go into format cells -- custom and put in ;;; and it hides the names but when I click the drop down box where they go the names are still there. That is what I want. Now I have another list but it is numbers, that go into another drop down list. When I go to format cells -- custom and put in the ;;; it to hides the numbers but when I click the drop down box for the numbers only it is blank. I can scroll down and click a blank spot and the number appears in the cell. My question is why are words showing up in my drop down lists but when I have a drop down list of numbers the numbers do not show up? I know they are there I just can't see them. And how do I fix this? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Hiding information
"hbaublit":
.. I know they are there I just can't see them. And how do I fix this? One further thought, perhaps a possible fix/work-around is simply to input the source numbers (for the DV) as text numbers, ie precede these with an apostrophe when you input. Then it'll behave exactly the way you want. And you could easily take care of downstream calculations pointing to these text numbers by re-converting it to real numbers via for eg, a simple "add zero", eg: =vlookup(A2+0, ...) where A2 houses the DV with the text numbers. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding duplicate information | Excel Worksheet Functions | |||
Hiding cell information | Excel Worksheet Functions | |||
Viewing information after hiding columns / rows | Excel Discussion (Misc queries) | |||
Viewing information after hiding columns / rows | Excel Discussion (Misc queries) | |||
Hiding "Send To Mail Recipient" Information In Excel | Excel Discussion (Misc queries) |