Not able to add more rows between two rows.

[Ajay Gupta]

I am not able to add more rows between two rows.

I am trying CTRL+Shift+PLUS.but it says cannot shift object

Please help i am a beginner.dnt knw much about excel

 

[shailyog]

welcome to the Forma Ajay Gupta


Press Ctrl+ down arrow


u will reach last row.


See if there is any value there. try to accommodate it in some previous rows.

 

[Ajay Gupta]

Yes i have done that but still i am not able to add rows.

 

[shailyog]

select all unused columns and rows and press delete only if you are sure that there is nothing on sheet which is hidden and can be useful. See if this works.


if not then this link may help you:

http://support.microsoft.com/kb/211769

 

[Hui]

You may also have some merged columns/rows somewhere

Unmerge Columns/Rows that extend to the end of the Row or Column

 

[Ajay Gupta]

Thanks a lot.Its done now.The link provided the solution-Ctrl+6.

Thanks