looking for short cut

D

Dylan @ UAFC

Can't get this to work right.
got about 300000 rows

just need to considate
=a1&"_"&b1 (need to have the _)
of course when I crtl + shift + enter
it copies the same form all the way down

shortcut advise plese
 
G

Glenn

Dylan said:
Can't get this to work right.
got about 300000 rows

just need to considate
=a1&"_"&b1 (need to have the _)
of course when I crtl + shift + enter
it copies the same form all the way down

shortcut advise plese
Click to expand...


Let go of the shift.
 

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

Automation of scanned file storage based on content 0
Is there a one button shortcut for "copy cell above & paste here" 4
copy down question 6
Wildcard issue for Index/Match Function when searching numbers 1
Shortcut keys for copying data down 29,000+ cells 2
"search" a different sheet with multiple criteria 2
Multiple selections of rows & columns by clicking in one cell 0
Cutting list summary - function?? 0

Top