EXCEL SPREADSHEET, HOW CAN I FILL I

D

DENISESA

HOW CAN I FILL IN THE SAME DATA, FOR EX COLUMN 1 IS DATE AND I USUALLY HAVE
20-30 TO TYPE IN. ALSO WHT DOESAUTO FILL, ONLKY SOMETIMES WORK. I TYPE THE
WORD MILWAUKEE AT LEAST 40 TIMES A DAY!!
 
J

Jason Morin

In response to your 2nd ques., AutoFill only works if the
word already exists somewhere in the same column. But you
can use AutoCorrect (Data > AutoCorrect Options) and
create a shortcut. For example, replace "Mi"
with "Milwaukee". You can then type "Mi" in a cell, press
return, and XL replace it with "Milwaukee".

HTH
Jason
Atlanta, GA
 
Top