Trouble with Excel Spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending Data from one spreadsheet to another 4
How do I create a small array from a larger one? 3
Linking 2 spreadsheet using data from the last row of spreadsheet 13
Linking 2 spreadsheet using data from 1st spreadsheet 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
merging spreadsheet data 1
HELP- Excel Spreadsheet onto a Publisher template 1
Links error when insert line/row to source workbook 1

Back
Top