How do I add rows to a completed worksheet?

[skeener]

I started working on a worksheet and as I went along I needed to add
categories under sub headings. This involved rows. I am now unable to add
rows. How do I add rows to a completed worksheet? I am trying to simply add
rows between sub headings.

 

[Peo Sjoblom]

What happens when you try to add rows?

Regards,

Peo Sjoblom

 

[skeener]

My worksheet is an annual expense report. As I went along adding dataI
discovered I needed more categories under a specific heading. ie., Car
Factors:
Gas, Car Wash, Car Repair and needed to add parking. Before typing in
parking on a blank row I tried to add a row to maintain the space between
Subheadings ie., Car Factors. This is the message I got when I went to
insert-row:

To prevent possible loss of data Excel cannot shift nonblank cells off
worksheet. Try to locate last nonblank cell by pressing crtl+end and delete
it, clear all in cells between last cell and the end of your data. Then
select cell A1 and save your workbook to last cell used.

I don't know what this means. I simply need to add a row in various spots
throughout the entire worksheet.

Thank you. S

 

[Gord Dibben]

skeener

The error message "cannot shift non-blank cells off worksheet" means you have
data or formulas or <spaces> in cells all the way down to row 65536.

Select A1 and CRTL + END to see where Excel takes you.

If far below where you think it should be, select all rows below your real
data range by going to last row of real data and hit SHIFT + END + DownArrow
to select all rows.

Edit>Delete>Entire Row.

Do same for columns to the right of real data.

Now save and close then re-open the workbook.

Insert your rows.

Gord Dibben Excel MVP

 

[skeener]

Thank you Thank You. You saved me.

skeener

The error message "cannot shift non-blank cells off worksheet" means you have
data or formulas or <spaces> in cells all the way down to row 65536.

Select A1 and CRTL + END to see where Excel takes you.

If far below where you think it should be, select all rows below your real
data range by going to last row of real data and hit SHIFT + END + DownArrow
to select all rows.

Edit>Delete>Entire Row.

Do same for columns to the right of real data.

Now save and close then re-open the workbook.

Insert your rows.

Gord Dibben Excel MVP

 

[Gord Dibben]

Thanks for the feedback.

Gord

Thank you Thank You. You saved me.