inserting a row..
WHEN TRYING TO INSERT A ROW AND IT SAYS CANNOT SHIFT OBJECTS OFF ...
|
It means you have something in the last row(s) and cannot shift
the rows down. Use Ctrl+End to find the last cell, which is the intersection of the last row with content, and the last column with content. Spaces are content, and formulas are content as are empty strings. More information in http://www.mvps.org/dmcritchie/excel/lastcell.htm Some people try to hide calculation formulas in an out of the way place -- a very bad thing to do. If you try to copy an entire sheet and paste that into another spreadsheet below row 1 it will not fit. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "angelb88" wrote in message ... WHEN TRYING TO INSERT A ROW AND IT SAYS CANNOT SHIFT OBJECTS OFF ... |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com