Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert row problem
hi all, i have a worksheet outlined as an invoice with out any data on
it.when i try to insert a new row this warning pops up."to prevent loss of data excel cannot shift nonblank cells off the worksheet."i cant find a way to work around this.any help is greatly appreciated. thx wyn b. -- wynb |
#2
|
|||
|
|||
Scroll down... down.. and down.. to the very bottom of the worksheet. Check
whether there is anything in any one of the cells in row 65536 (the last row). It is very likely that at least one cell in the last row contains something. Because a worksheet can has at most 65536 rows, and you got something in 65536 row, therefore, Excel cannot insert any more rows in the middle, as it cannot get rid of the information in that last row. Regards, Edwin Tam http://www.vonixx.com "WYN" wrote: hi all, i have a worksheet outlined as an invoice with out any data on it.when i try to insert a new row this warning pops up."to prevent loss of data excel cannot shift nonblank cells off the worksheet."i cant find a way to work around this.any help is greatly appreciated. thx wyn b. -- wynb |
#3
|
|||
|
|||
This usually means that you have some data on row 65535 (or thereabouts) If your worksheet is not supposed to be this large you need to clean off the excess. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=383425 |
#4
|
|||
|
|||
hi edwin,that fixed the problem.thank you.wyn b.
-- wynb "Edwin Tam" wrote: Scroll down... down.. and down.. to the very bottom of the worksheet. Check whether there is anything in any one of the cells in row 65536 (the last row). It is very likely that at least one cell in the last row contains something. Because a worksheet can has at most 65536 rows, and you got something in 65536 row, therefore, Excel cannot insert any more rows in the middle, as it cannot get rid of the information in that last row. Regards, Edwin Tam http://www.vonixx.com "WYN" wrote: hi all, i have a worksheet outlined as an invoice with out any data on it.when i try to insert a new row this warning pops up."to prevent loss of data excel cannot shift nonblank cells off the worksheet."i cant find a way to work around this.any help is greatly appreciated. thx wyn b. -- wynb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simultaneouly insert of rows or col. - Ajit | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Excel logo insert printing problem | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |