|
Hi,
In this section I'll be including more tips and tricks, along with some advice and stories from the world of PCs.
Tina asked: “Your tips are very useful. Can I use Autofill to set up an A/B split in my excel subscriber database? Have over 30,000 rows of subscriber data. Want to Autofill a "1" in every other row in a specific column. Much appreciated. The column is not filled at the moment.”
Sean’s answer: Put a 1 in the first cell. Highlight the 1 and the blank cell below. Now drag the fill handle as far as you’d like down (or double-click the fill handle if there’s data in the column to the left). You’ll get 1 2 3 4, separated by blank rows. However, click the AutoFill options SmartTag, and choose Copy Cells.
Easy!
| 
Blog
