Question about Computers & Internet

2 Answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 42 Answers

This error message occurs if the following conditions are true:

  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769

Posted on Nov 06, 2008

  • Harish Swamy Oct 02, 2010

    Thanks for the explanation

    Other sites presumed there was data in these reanges

    Harish Swamy

  • miranda_rd_1
    miranda_rd_1 Jan 06, 2013

    Hi! I just posted this solution here:http://runakay.blogspot.com/2013/01/inse...

×

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Cannot hide error"cannot shift objects offsheet"

Posted on Jan 05, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

My son was doing school work on the computer all weekend - now I can no longer find or open my Excel spreadsheets!


Your sheets should not have been affected, except in the recent files location. You did not mention what operating system you are using, but on Vista and 7 you open your documents folder and type the name or partial name, of the spred sheet into the search window in the upper right corner of the window, and all sheets matching will show up.

Dec 06, 2010 | Computers & Internet

Tip

How to set, modify, remove and recover Excel 2007 password?


Microsoft Office software developers have been paying more and more attention to the means of protecting users' information, and Microsoft Excel has not been overlooked. Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them. The methods include completely blocking access to a document, forbidding saving changes to it. Besides, some expert team even designed Excel password recovery tool to recover Excel 2007 password for those who have lost Excel password.
Set a password to open or modify Excel 2007 password Set a password to open Excel 2007
  1. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document. excel-document.gif
  2. In the Password box, type a password, and then click OK. You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.
  3. In the Reenter password box, type the password again, and then click OK.
  4. To save the password, save the file.
Set a password to modify a Excel 2007 Spreadsheet In addition to setting a password to open an Excel spreadsheet, you can set a password to allow others to modify the spreadsheet.
  1. Click the Microsoft Office Button office.gif , click Save As, and on the bottom of the Save As dialog, click Tools.
  2. On the Tools menu, click General Options. The General Options dialog opens.
  3. Under File sharing, in the Password to modify box, type a password.
  4. In the Confirm Password dialog, re-type the password. Click OK.
  5. Click Save.
Remove password protection from an Excel spreadsheet
  1. Use the password to open the spreadsheet. (Note: If you don't know the open password, you have to recover Excel password with the third Excel password recovery tool)
  2. Click the Microsoft Office Button office.gif , point to Prepare, and then click Encrypt Document.

    excel-document.gif

  3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.
  4. Save the spreadsheet.
Recover Excel 2007 password with Excel Password Unlocker Excel Password Unlocker is a popular Excel password recovery tool that can recover Excel password from Excel 97 to Excel 2007
Related Office 2007 document password tips:
How to set, modify, remove and recover Word 2007 password?
How to set, modify, remove and recover PowerPoint 2007 password?

on May 21, 2010 | Computers & Internet

2 Answers

Have a excel password protected file. have forget my password. help me in opening my file


How to Crack Excel Spreadsheet Passwords by Petri IT Knowledgebase Team - January 8, 2009 Often when an employee departs, they take important Excel passwords with them. This guide outlines how to use a simple Excel password recovery application to crack lost or forgotten passwords, allowing you to unlock password-encrypted Microsoft Excel documents quickly as possible.
Step 1: Download and Install the Office Password Recovery Utility To perform the following recovery steps, you'll need to grab the download of Office Password Recovery Pro, available directly here. (2.1Mb)
Once you've downloaded the program, run the install with the default options.
Step 2: Navigate to the Protected File and Begin the Recovery Process Click the Open button on the top left, navigate to the protected spreadsheet file:

May 09, 2009 | Computers & Internet

1 Answer

Gateway Computer .


to unhide th column.
click on the upper most left corner (the box on top of the row1 and column c). the enter spreadsheet should be highlighted. then go to format>>unhide. you should have the column A and B.
as far as the lost numbers. if you did not close the work sheet, you can retrieve them by using the back button on the tool bar. you can't retrieve lost number if you close the worksheet and reopen it again.

Apr 27, 2009 | Computers & Internet

1 Answer

I get the following message when i try open an excel spreadsheet. i cannot see and info on the sheet. Compatibility Report for Info2008.xls Run on 10/17/2008 18:01 The following features in...


Either you need to upgrade your version of Excel or the person creating the spreadsheet needs to save it in a format for compatability. For example, the person who created the workbook simply needs to do File and Save As. Under type, one can choose a format for older versions of Excel.

Hope this helps!

Oct 18, 2008 | Computers & Internet

1 Answer

PREVENTING REPEAT ENTRIES IN A RECORD ENTER BOX OR REPEAT ENTRY OF EARLIER ENTRY


The only reference I find is that you may have a duplicate filter. Check the filters and delete the duplicate on.
Also, to create a reliable database, I would use Excel or OOpenOffice, which has a spreadsheet program compatible to Excel.

Download and install the free, open source OpenOffice.org office suite (www.openoffice.org)-- it include a spreadsheet compatible with Excel spreadsheets (along with a good, MS Word compatible word processor, and a good MS PowerPoint-compatible presentation program).

Good Luck,
Joe

Oct 08, 2008 | Microsoft Computers & Internet

2 Answers

I am computer illiterate and i am wanting to do a household budget. i have the program office suite 2008 but don't know how to work it. any help would be greatly aprecated.


Hi
learn word 2007 from this site.so that u can easily understnd 2008
all the best




http://www.trainsignal.com/index.asp?PageAction=VIEWPROD&ProdID=107

Aug 12, 2008 | Computers & Internet

1 Answer

I "fat-fingered" something while typing some numbers into my excel spreadsheet, and now only the suport "upper case" of the numbers of my number section work--so I am unable to now type...


Does your k/b have a "shift lock" button... if so press it to disable the "shift lock"

If using the numeric keypad, ensure you have "num lock" ON

HIH

Jul 19, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

3,216 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

joecoolvette
joecoolvette

Level 3 Expert

5660 Answers

kakima

Level 3 Expert

98694 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...