colomns got swoeched

[marrie]

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.

 

[Gord Dibben]

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

 

[marrie]

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.

 

[JLatham]

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.

 

[SteveW]

!! 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

 

[Gord Dibben]

It is possible you sorted the data and this is why it happened "throughout this
table".

If you haven't saved the workbook yet you may be able to hit the undo button to
get your data back in order.

Do you have a backup file anywhere that would be useful?


Gord

 

[JLatham]

Good plan also. I think the end desire either way is to have an untouched
copy, and experiment with one, keeping untouched copy in reserve in case of
disaster.

I was also thinking of what Gord Dibbon mentions in follow-up posting -
somehow the table got sorted - in which case, things will probably be OK
either way unless something else was depending on data in the table and the
move/delete messes that up.

 

[SteveW]

I'll leave gord to keep up with the solution to your problem

Regarding the *Save As..*
I never ever use it, well not since I screwed up once.

Current file "Fred", Save as... *Fred problem*
You keep working, solve the problem - Save and Exit

Later you get rid of *Fred problem* as you think it was the one you had
problems with.

You open *Fred* and hey presto the original problem file is back !

I use Explorer to make a copy of the original file
and then carry on working with the original file name.

Steve

Good plan also. I think the end desire either way is to have an
untouched
copy, and experiment with one, keeping untouched copy in reserve in case
of
disaster.

I was also thinking of what Gord Dibbon mentions in follow-up posting -
somehow the table got sorted - in which case, things will probably be OK
either way unless something else was depending on data in the table and
the
move/delete messes that up.

 

[JLatham]

I concur - too many cooks. Gord seems to have it in hand, and that puts it
in Good Hands. Probably better than Allstate even!

 

[marrie]

actually I just slded it by going to deleate menu and choosing shift cells
up and it fixed it. I found someother shortcuts and if anybody wants them
I'll compile what I find by going to a new post later. thanks for all your
help guys.

 

[marrie]

I got the problem solved but I will make a back up copy sometime in case
this happens again.

 

[JLatham]

To err is human, to have a recent backup is often truly divine!