Excel Puzzle
Further to Gord's reply, if you have formulae in even rows that refer to
cells in odd rows then these will show #REF errors after you remove the odd
rows.
Pete
"Templar" wrote in message
...
Two Inquires
First: Is there a shortcut for me to be able to delete every other line
in
an excel
document. The information on every other line (3,5,7,9 etc) is redundant
and I'd hate to have to delete them line by line.
Second: When I delete the redundant line, some data from the main line
disappears too. I can't have that happen. (that is, if I delete line 3,
some important
data on line 2 disappears)
Please advise. Thank you.
--
Templar
|