• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Stupid Excel Question

R

runningconfig

n00b
Joined
Jul 10, 2011
Messages
46
Hey,

I found a spreadsheet that I want to start using that already contains multiple drop down lists.

The thing is I can't find where the data for these drop downs in stored?

Usually I see an additional sheet that contains this data but now with this one.

Any idea how this would have been hidden?
 
The tabs could be hidden. If you click on the active tab and select unhide.

It could be behind any chart/graphs.

Or hidden rows and tabs. If you select all the rows and select unhide, same with tabs.

Or tabs/rows that are not hidden but shrunk all the way down.

Also looking at the formulas can give you an idea of what/where to look.
 
You must log in or register to reply here.
Back
Top