Outlook Reading Pane

Disabling the Word 2007 Mini-Toolbar

Excel Sheet Navigation

4Networking in Leeds East

Twitter - ReTweets

Twitter - Lists

Twitter - Mobile

Excel Paste Column Widths

PowerPoint Slide Master

Windows 'God Mode'

Excel Functions

Filling Alternate Cells

Microsoft Office Shortcut keys

Excel Negative Times

Word Reading Layout

Windows Shortcuts

Excel dropdowns

Quick sheet selection

Search files on Google

A - Z of Excel

Word 2003 to 2007

   Astradyne Blog/Tips and Tricks - Filling Alternate Cells


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.




Copyright ©2006-2013

vb training leeds, vba training leeds, excel vba, access vba, pc training in leeds, computer training in yorkshire, pc training in yorkshire, computer training in leeds, microsoft access vb, microsoft excel vb training, microsoft powerpoint training, microsoft training, microsoft word, office 2000, excel training leeds, access training leeds, office training leeds, office 2007, leeds vba, leeds visual basic, leeds training