#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Insert Paste

I am trying to add another cell, So as I always do copy from the another cell
and Insert copy for the new added cell but this is new thing happening now. I
do not want to creat new sheet can some one tell me why I am getting this
message " Cannot Shift Objects off Sheet"
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default Insert Paste

Would help if you would include how you are trying to "add another cell"...

The short answer is you are probably trying to add a row or a column that
exceeds the limits of the Excel or include in a formula a cell in a row or
column beyond the limits of column IV or row 65536.

HTH
Regards,
Howard
"Mike-Lodi" wrote in message
...
I am trying to add another cell, So as I always do copy from the another
cell
and Insert copy for the new added cell but this is new thing happening
now. I
do not want to creat new sheet can some one tell me why I am getting this
message " Cannot Shift Objects off Sheet"



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Insert Paste

Hi,

It may be that Excel has become confused, it happens sometimes.

To correct thing select all 'unused' columns to the right of your data and
'delete'
then select all unused rows below your data and delete. Save the workbook
and that should reset everything.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mike-Lodi" wrote:

I am trying to add another cell, So as I always do copy from the another cell
and Insert copy for the new added cell but this is new thing happening now. I
do not want to creat new sheet can some one tell me why I am getting this
message " Cannot Shift Objects off Sheet"

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
What does InsertNameLabel & InsertNamePaste do? Studebaker Excel Discussion (Misc queries) 2 June 12th 08 04:13 AM
Insert Name Paste List Philip J Smith Excel Discussion (Misc queries) 3 January 24th 08 06:29 PM
Paste and Insert Schwimms Excel Discussion (Misc queries) 1 June 6th 07 09:20 PM
Macro that will select and insert a new row and paste as value [email protected] Excel Worksheet Functions 3 December 5th 06 04:06 AM
insert and paste in one step KathyinCincinnati Setting up and Configuration of Excel 1 December 2nd 04 12:30 AM


All times are GMT +1. The time now is 02:57 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"