Ignore blank cells

[Paul Silverwood]

I have a spreadsheet where i am typing into A1 "timber", into A2 "metal", into A3 "marble" etc.
If i start to type into A4 "timber" the cell will autofill from cell A1
however if i leave cell A4 blank then start to type "timber" into A5 it will not autofill
How do i get excel to ignore the blank cell at A4 ?

 

[James006]

Hello,

Not sure to fully understand your question ...

Do you need to turn off AutoComplete feature ...?

If it's the case ...

From your Main Menu :

• Click File > Options
• Click Advanced, and then under Editing options, select or clear the EnableAutoComplete for cell values check box to turn this option on or off.

Hope this will help

 

[Paul Silverwood]

Hi James
Thanks but not working
Any other suggestions ?
Cheers
Paul

Hello,

Not sure to fully understand your question ...

Do you need to turn off AutoComplete feature ...?

If it's the case ...

From your Main Menu :

• Click File > Options
• Click Advanced, and then under Editing options, select or clear the EnableAutoComplete for cell values check box to turn this option on or off.

Hope this will help

 

[James006]

Hi,

Since Excel Options are loaded for each session ...

Forgot to tell you to close down everything ... and re-open ...