Trouble with Excel Spreadsheets

M

Mel2002

I am working in a large spreadsheet- the addresses do not link to the correct
company names- the addresses are 1 row down.

How do I rectify this. Is there a way of inserting 1 row in 1 column without
disturbing the others?
 
C

CLR

Practice on a copy of your data........

Go to the cell where you want to insert a row, then Right-click > Insert >
check ShiftCellsDown > OK

Vaya con Dios,
Chuck, CABGx3
 
D

David Biddulph

Mel2002 said:
I am working in a large spreadsheet- the addresses do not link to the
correct
company names- the addresses are 1 row down.

How do I rectify this. Is there a way of inserting 1 row in 1 column
without
disturbing the others?
Click to expand...

Select the cell where you wish to insert.
Insert/ Cells/ Shift cells down
 
Top