Either simple or impossible... 1

[Morglisn]

Hey, guys..

I have several rows in my spreadsheet that use the same formula, although the cells referenced by the formulas increment. Normally, I could just copy the cells down and let the cell #s increment. No problem.

In this case, however, I have borders around each of the cells in the rows in question. I want a gap between the borders. Is there any way to insert a gap between two rows, in lieu of inserting another row? If I insert another row, my formulas do not increment correctly, and I have to correct them manually.

If that made absolutely no sense, I apologize. I'm finding it hard to describe what I'm trying to do.

 

[PaycheckSlave]

KevinNZ is right, it works with conditional formatting. Highlight the column you want formatted. Choose “Formula Is” and use =(MOD(ROW($A1),2)=0) as the formula.

 

[krossview]

Here is an alternate solution that may work for you.
The workaround is in the method of copying not by reformating the rows around the cells.

1. Insert one or more rows between each formula and
format cells as required.
2. Enable Datafilter and select "Non Blanks" cells
(This filters out all blank rows)
3. Copy 1st cell and paste into other cells
Use Paste Special if you only want to copy formula's

4. If this trick did not work for you then add a custom
command "Select Visible Cells" to your one of your
toolbars. To add this command. Right-click toolbar,
select Customize-Commands then Category: Edit and find
command "Select Visible Cells" at the bottom.
5. Now when you copy the 1st cell, highlight the cells you
want to paste to and click on "Select Visible Cells"
toolbar first and then Paste info
6. Now turn-off the Data Filter or select "All" from the
drop down box and you are all done.

The last feature is very handy and usefull when you are working on 3-d spreadsheets and want to paste information down to other grouped worksheets. It's a powerfull feature, which can save you quite a bit of time. Also tricky as you can mess up a workbook in a hurry if multiple worksheets are group together for editing.


Btw.
Play with Excel's Copy & Paste as it has some need features which can really speed up your work. Like copying non-continuous cells and pasting into continuous block. Copying one cell and paste it to non-continuous cells. Note this works only for one row or one column.

Hope this works

Krossview/OK

 

[Boothby171]

Maybe I'm oversimplifying: can't you just add the rows *after* you copy all the cells? Or, copy the cells once, add the rows, and then take advantage of the Excel-imposed fix? (something tells me that last suggestion fails to understand the problem you're having)

--Steve