Code for auto fill (\-) stopped working

A

Andrew

Hello,
I have a spreadsheet which I've been using successfully for some
time. In one row, I have the command \* in several cells. This
command, when working properly, should fill the cell with *. Today I
noticed that it doesn't work. What could change to enable/disable
this function?

thanks,
Andy
 
S

Soni.Rajender

Hi Andy

Not getting you, can you please send a sample sheet.

Regards
Rajender Soni
 
D

Dave Peterson

In xl2003 menus:

Tools|Options|Transition Tab|Check Transition Navigation keys.

======
Personally, I'd turn all those transition settings off. I don't like how that
setting handles the Home and Tab keys (for example).

Instead, I'd format the cell:
Format|cells|Alignment tab|Text Alignment section|Horizontal|Choose Fill

Then just type the single asterisk (*).
 

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 does not accept text format! 0
Merging from an Excel file with graphics 1
Stop Command Question 4
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Drop down list control value in vba 2
Referencing a Forms Button in a Worksheet 7
How do I set focus (and select text) on a text box on a modeless userform? 0
VBA Conditional formating for specific text in several columns 1

Top