Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
fredhep
 
Posts: n/a
Default Cannot insert a row in Excel spreadsheet

If this is a duplicate message, I apologize. I don't think that my first try
succeeded.

When using my Microsoft Excel spreadsheet in Widows XP (that I imported from
Microsoft Works in Windows 98SE) I can't insert a new row (I can insert a new
column). When I select the row and click on "Insert," then "Row," I get the
message: "To prevent possible loss of data Microsoft Excel cannot shift
nonblank cells off the worksheet. Try to locate the last nonblank cell by
pressing CNTRL+END and delete or clear all in cells between the last cell and
the end of your data. Then select cell A1 and save your workbook to reset the
last cell used. Or you can move the data to a new location and try again."

To me this message is meaningless. Any suggestions?

  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

Excel seems to think that you have information all the way down in row
65,536. Figure out what your REAL last row of data is. Highlight the next
row down from that REAL last row all the way down to row 65,536. Delete
those rows and save your workbook.
Now you should be able to insert.
HTH,
Gary Brown



"fredhep" wrote in message
...
If this is a duplicate message, I apologize. I don't think that my first
try
succeeded.

When using my Microsoft Excel spreadsheet in Widows XP (that I imported
from
Microsoft Works in Windows 98SE) I can't insert a new row (I can insert a
new
column). When I select the row and click on "Insert," then "Row," I get
the
message: "To prevent possible loss of data Microsoft Excel cannot shift
nonblank cells off the worksheet. Try to locate the last nonblank cell by
pressing CNTRL+END and delete or clear all in cells between the last cell
and
the end of your data. Then select cell A1 and save your workbook to reset
the
last cell used. Or you can move the data to a new location and try again."

To me this message is meaningless. Any suggestions?



  #3   Report Post  
fredhep
 
Posts: n/a
Default

Thanks for the help. It seems so obvious what the message means once you
know the answer.

"Gary Brown" wrote:

Excel seems to think that you have information all the way down in row
65,536. Figure out what your REAL last row of data is. Highlight the next
row down from that REAL last row all the way down to row 65,536. Delete
those rows and save your workbook.
Now you should be able to insert.
HTH,
Gary Brown



"fredhep" wrote in message
...
If this is a duplicate message, I apologize. I don't think that my first
try
succeeded.

When using my Microsoft Excel spreadsheet in Widows XP (that I imported
from
Microsoft Works in Windows 98SE) I can't insert a new row (I can insert a
new
column). When I select the row and click on "Insert," then "Row," I get
the
message: "To prevent possible loss of data Microsoft Excel cannot shift
nonblank cells off the worksheet. Try to locate the last nonblank cell by
pressing CNTRL+END and delete or clear all in cells between the last cell
and
the end of your data. Then select cell A1 and save your workbook to reset
the
last cell used. Or you can move the data to a new location and try again."

To me this message is meaningless. Any suggestions?




  #4   Report Post  
les nienhuis
 
Posts: n/a
Default



"fredhep" wrote:

If this is a duplicate message, I apologize. I don't think that my first try
succeeded.

When using my Microsoft Excel spreadsheet in Widows XP (that I imported from
Microsoft Works in Windows 98SE) I can't insert a new row (I can insert a new
column). When I select the row and click on "Insert," then "Row," I get the
message: "To prevent possible loss of data Microsoft Excel cannot shift
nonblank cells off the worksheet. Try to locate the last nonblank cell by
pressing CNTRL+END and delete or clear all in cells between the last cell and
the end of your data. Then select cell A1 and save your workbook to reset the
last cell used. Or you can move the data to a new location and try again."

To me this message is meaningless. Any suggestions?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller Excel Discussion (Misc queries) 1 February 8th 05 10:34 AM
How do I insert the directory path in my Excel file? Insert a Directory Path in Header/Footer Excel Worksheet Functions 2 February 4th 05 10:23 PM
How do I insert an Excel file into a PowerPoint Presentation slid. Barb Excel Worksheet Functions 1 December 11th 04 05:23 PM
How do I insert an Excel file into a PowerPoint Presentation slid. Barb Excel Discussion (Misc queries) 1 December 11th 04 05:22 PM
How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. Selena Excel Discussion (Misc queries) 1 December 7th 04 04:01 AM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"