LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kelly
 
Posts: n/a
Default Error message when trying to insert a column

Hello -

I'm in an Excel spreadsheet which I did not create. When I try inserting
columns, I am getting the following error message: "to prevent possible loss
of data, Excel cannot shift nonblank cells off the worksheet. Try to locate
the last nonblank cell by pressing CTRL+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". What on earth does this mean? I the
spreadsheet is not large but when I hit CTRL+END, I go to IV102. I don't
know how to make this go away. Can anyone help, I would be most grateful.
Thank you!

Kelly
 
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
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
how do i insert words into a column without erasing the words soccer5585 Excel Discussion (Misc queries) 0 June 8th 05 11:06 PM
Lookup then Match and insert value from next column Tenacity Excel Worksheet Functions 3 March 4th 05 02:49 AM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


All times are GMT +1. The time now is 09:47 PM.

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

About Us

"It's about Microsoft Excel"