Excel formulae + drop down table

  • Thread starter Thread starter rubyn15
  • Start date Start date
R

rubyn15

I am trying to recreate a really big excel sheet filled with formula
and was wondering if there was any way i could see all the formulae o
that sheet without having to click on each cell.
Also, there is a drop down table that has specified values in it tha
you can choose from. Any idea on how i can recreate that?
Thanks
Rub
 
Go to tools > options and check the formula box to show formula.

Foir a drop down list go to Data > Validation and chose List and the
either create the list or identify the range it will come from

E
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 for PC doesnt work on Excel Mac 2011. 11
data validation list 17
Drop Down List 2
Excel Excel: How do I put a formula in a drop down list 11
Dependent drop down dynamic range formula, off sheet. 7
Display zero in the cells with Excel 2013 5
Excel question ? 5
drop down list 1

Back
Top