Thread: Making tab do a CRLF when reaching end of a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
loudfish loudfish is offline
external usenet poster
  
Posts: 49
Default Making tab do a CRLF when reaching end of a range
On 9 May, 21:06, John A <John wrote:
Can I make Excel respond to tab by going to the next row, once it reaches the end of a range?

Yes. Highlight the range (highlight the two columns). Now when you
tab, it will move through your selection, so from the 2nd column, a
tab should move to column 1 in the next row.

HTH

Andrew

Reply With QuoteReply With Quote