Forum Discussion

Sue_G's avatar
Sue_G
Brass Contributor
Jan 15, 2020

Excel Question - Skipping Columns

I hope someone can help with my question. On my spreadsheet, I would like to skip over certain columns when entering data. I was able to set it up when I don't want to enter data at all using the fol...
excel
mathetes's avatar
mathetes
Silver Contributor
Jan 15, 2020

Sue_G 

 

I read what you've written and find myself wondering a number of things:

  • Is this always happening (when it happens) with the same column, or same set of columns?
  • How many columns over all are there?
  • What's the purpose of the spreadsheet in the first place?

That's just for starters. It definitely would seem to me that using a VBA routine to do what two touches of a tab key can do is killing a mosquito with a bazooka. (But I'm averse to VBA in general, believing that astute use of formulas and good design can accomplish a lot; my bias is not absolute, but I definitely don't turn to VBA/macros unless absolutely necessary.)

 

Bottom line, I just wonder if you can re-order the columns (or do some other kind of re-design) so the ones that often get by-passed come later, and only need to be touched by the cursor when they're needed.

 

Is it possible for you to post a sample of the spreadsheet? Can you describe the "business purpose" of it, or some other kind of background as to what the bigger picture is?

 

Resources