2 basic Excel questions for you pro's

[Guest]

I am a very new user of Excel so bear with my "green-ness";

1) I have been creating links throughout my 13 sheet workbook, now when I
attempt to finish making these links today, the actual formula (=SUM(A36)) is
populating into the cell and not my data????

2) I have a section that I want users to be able to only select 1, like
"choose only 1" in a survey. When you select 1 cell, your previous selection
moves, etc.

Thanks in advance for the help~

 

[Guest]

First basic question:

If you enter a formula and it appears in both the formula bar and the cell,
odds are Excel thinks the material is just a text string Take a typical
problem cell:

1. clear the cell
2. format the cell as general
3. re-type (NOT PASTE) the equation

 

[Gord Dibben]

Not necessary to clear the cell.

Just re-format to General then hit F2 and ENTER.


Gord Dibben Excel MVP

 

[Guest]

Possibly in Options you have selected "Show formulas"

Tools > Options = View Tab Formulas is selected. Unselect it.

 

[Guest]

Perfect. Thank you very much. Any ideas on part #2? It is an internal
shipping request form and I want staff memebers to not only have to select a
service level (overnight, ground, etc.) but only be able to select 1 of them??

thx

 

[Gord Dibben]

Try Data>Data Validation>Allow>List.

Either type the list into the dialog box(comma delimited) or have the list on
the sheet and select that list range.

Checkmark "in cell dropdown".

Users will use the dropdown list to select one of the options from the list.

For more on DV dropdowns see Debra Dalgleish's sit.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

 

[Gord Dibben]

Joe

Instead of copying from Outlook try File>Export from Outlook as a *.csv or
*.txt file.

Open that file in Excel and see what you get.


Gord Dibben Excel MVP

 

[Gord Dibben]

Ignore this post.

Was meant for somewhere else<g>


Gord