Hello,

I would like to know how to select every 3rd or 4th cell in an excel spreadsheet (which I would enter in a new column). Does anyone know the formula?

I would also like to know how to highlight a column of data (~30,000 + rows) from where I select the start value - down the column to the END of th data, without dragging. Is there a shortcut for doing this? I appreciate this forum.

THANK you,
tracyannTracyann,

The first part, you can record a MACRO to select every 3rd or th cell, but second is a tough one, not sure if it possible.... Thank you for your response, but what does "record a macro" mean? I've never used macros - just the formulas in the cells... maybe I just need to sit down and think! about how I did it years ago. There are so many shortcuts in EXcel that I'm not sure if I can sift through them all to find the highlighting one I'm looking for - but I know it's possible. I've had people SHOW me before. -thanks again, tracyann1. HOLD Ctrl key while selecting with mouse.
2. Select first row, hold Shift key, select last row.Thank you!