LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Unable to Insert Columns

I'm unable to insert columns into my worksheet. Message I get is "To prevent
possible loss of data, Excel cannot shift nonblank cells off the worksheet.

Try to to locate the last nonblank cell by pressing CTRL+END, and delete or
clear all in cell 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."

I tried this, but I'm still unable to insert columns. I've also cleared
print area, but still no success. Any suggestions? By the way, all columns
are filtered (if this matters).

Thanks in advance.
 
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
Unable to insert table J Austin Excel Discussion (Misc queries) 3 May 15th 23 07:43 PM
Unable to Insert objects in Excel Anil Excel Discussion (Misc queries) 0 June 17th 08 01:02 PM
unable to delete or insert a text box ... Deb RW New Users to Excel 3 June 18th 07 09:30 PM
Unable to delete or insert a worksheet. dmarten Excel Discussion (Misc queries) 2 October 31st 06 05:03 PM
unable to insert columns in excel, insert- columns (disabled) iam_leearner Excel Discussion (Misc queries) 1 August 13th 06 02:26 PM


All times are GMT +1. The time now is 02:13 AM.

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"