#microsoft-excel-2003

[stackcopybiz]

Answer: allow two possible values in a Excel cell #computers #programming #fix

Answer: allow two possible values in a Excel cell #computers #programming #fix

allow two possible values in a Excel cell

I would like to create a cell format for one cell to only allow the value “yes” or “no” for this cell.

How could I do this?

Answer [by dcp]: allow two possible values in a Excel cell

Click cell you want to restrict value for.

Go to Data->Validation

On the dialog that comes up, for Allow, select List, and for Source, put in “Yes,No”.

Now your cell will…

View On WordPress

[stackcopybiz]

Resolved: Cells not updating automatically #answer #development #fix

Resolved: Cells not updating automatically #answer #development #fix

Cells not updating automatically

I seem to have a problem with an excel file. I have a formula in a cell which counts the values in 2 other cells, however, normally after entering in the values in the 2 other cells, the formula cell updates automatically when enter is pressed or when the cells are clicked out of.

For some reason, I am having to click on the formula bar, then I have to click…

View On WordPress

[stackcopybiz]

How to: Hyperlink font in Excel always changes to the default font face/size #solution #fix #programming

How to: Hyperlink font in Excel always changes to the default font face/size #solution #fix #programming

Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).

How can you configure Excel to use the same font face/size as you selected for the entire sheet (or group of cells) and not the default font set in Excel (in Excel 2007 the…

View On WordPress

[stackcopybiz]

How-to: How do I put logical operators in an Excel =IF Formula? #dev #programming #fix

How-to: How do I put logical operators in an Excel =IF Formula? #dev #programming #fix

How do I put logical operators in an Excel =IF Formula?

I’m trying to enter a formula to display text according to an IF condition. The best I can manage is something like…

=IF(myval>=minval & myval <= maxval, "OK", "Not OK")

But this appears to work exactly wrongly, displaying OK when myval is out of range and Not OK when it is in range. How do I specify the logical AND correctly? I have tried…

View On WordPress

[stackcopybiz]

Fix: Export an Excel spreadsheet to fixed-width text file? #it #solution #dev

Fix: Export an Excel spreadsheet to fixed-width text file? #it #solution #dev

Export an Excel spreadsheet to fixed-width text file?

Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns.

Does it also have functionality where, given an existing spreadsheet, you can export to a fixed-width text file?

If so, how do I access this? I have tried using Save…

View On WordPress