How To Autofill Every Other Cell In Excel

I think most of us already know when your first cell is just a number and not a formula, Excel will automatically fill in your cells by counting upward by one. Suppose, though, you do not want to apply the Excel autofill formula to each cell below it? What then?

Follow the steps below to learn how:

  1. Highlight the first two cells in your column.
  2. Now place your mouse at the lower right-hand corner of your two cells until the cursor changes to a plus sign (+).
  3. You can now hold and drag that down as you would normally.

Excel will now no longer automatically fill every cell based on your first cell.  It will now fill every second cell in every column.

I will admit that I am not an expert in Excel, but I DO try to learn as much as I can and save as much time and as many keystrokes as I can.  This information falls into that category. I hope you find it saves you time and keystrokes as well!

Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!