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