!! Don't forget that when you "save as..."
The current workbook changes to that one.
So next time you *save* it overwrites the one you just *Saved as..*

For me, best after *Save as..* is to now re-open the original, if all goes
fine - keep going

If not, revert to the *Saved as..* file

Steve


On Sun, 17 Sep 2006 14:37:01 +0100, JLatham
wrote:

To emphasize what Gord Dibben said: normal way to refer to cells on a
sheet
is to use the column letter first, then row number as B12 and B13. Not
just
being picky, but it helps assure people of what you are talking about.

Now, back to your problem.

First make a backup copy of the file, simply open it and use File | Save
As
and give it a new name. That's in case the changes I'm about to detail
mess
it up. And they could if the table contains formulas and things.

Click on the 14 at the left edge of the sheet, choose Insert | Row. That
will give you an empty row right below row 13.

Click the 12 at the left edge of the sheet, highlighting the entire row.
Move your cursor to the right into A12 and down a little until the cursor
becomes a 4-direction arrow symbol. Left-Click and hold and drag that
down
into the new row you just inserted. Release the mouse button.

Go back and click on the 12 at the left edge of the now empty row 12.
Then
from the menu choose Edit | Delete to remove the empty row.

If your table didn't suddenly fill up with error indications like #REF,
you're probably good to go.

"marrie" wrote:

Well there is suposed ot be a user name in colomn 13b and it moved up
to 12b
and the one in 12b switched places. this happened thorugh out this
table.
I'd shou you all but there is some personal info in this spread sheet as
well so can't show you all just now. Any suggestions.
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Unless you have named your columns, there are no such columns(or
rows) as
12b
and 13b

Do you mean cells B12 and B13?

What makes you think they may be switched?


Gord Dibben MS Excel MVP

On Sat, 16 Sep 2006 13:47:57 -0700, "marrie" wrote:

Hello. I think a certain colome of cells got swieched some how. with
out
movingthem by hand how can I re swotch them? thanks. example
13b is where 12b is supposed to be. Thanks.