ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems inserting rows (https://www.excelbanter.com/excel-discussion-misc-queries/40853-problems-inserting-rows.html)

KathleenK

Problems inserting rows
 
How can I insert a row in Excel when the assistant says it's not possible?
The assistant says that inserting rows would shift data off the worksheet,
rather into the next blank rows

Dave Peterson

Maybe...

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default...b;en-ca;211769

Remember to look for comments and merged cells.



KathleenK wrote:

How can I insert a row in Excel when the assistant says it's not possible?
The assistant says that inserting rows would shift data off the worksheet,
rather into the next blank rows


--

Dave Peterson


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com