How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9655
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I NEED TO INCREASE THE ROWS ON A WORK SHEET. I GET MESSAGE

Customer Question

I NEED TO INCREASE THE ROWS ON A WORK SHEET. I GET MESSAGE THAT OBJECTS CANNOT BE SHIFTED OFF THE SHEET.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  John D replied 1 year ago.
Hi,

There is more than one reason for this error. I need to see the file so I can determine the problem and fix it for you.

Could you go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

If the file has sensitive information let me know before you upload it


Customer: replied 1 year ago.

Just sent the file to you. I ned to be able to insert additional rows in the worksheet so I can do a sort on all the data as required.


 


Bill Landers.

Customer: replied 1 year ago.

Did you receive the file?


 


Do you need any additional information?


 


Bill Landers

Expert:  John D replied 1 year ago.
No Bill you need to give me the File ID or download link so I can get the file (as explained in bold font)

Customer: replied 1 year ago.

What is the link or where do I find the file ID?

Customer: replied 1 year ago.

John,


I am going to bed now. I will conntact you later today (Sunday).


 


Did you receive the file I sent you?


 


Thank you for your assistance.

Expert:  John D replied 1 year ago.

Bill here is the step by step instructions for uploading files

 

 

http://sites.google.com/site/zworkbook/upldws

 

Expert:  John D replied 1 year ago.
I still did not receive the file link. Were able to upload?
Customer: replied 1 year ago.


I uploaded the file three times. What link are you referring to?

Customer: replied 1 year ago.


Send me your email address so I can send the worksheet directly to you. There seems to be a problem with the link. I am becoming frustrated with this matter.

Expert:  John D replied 1 year ago.

hmm.

Did you read my initial instructions in bold font.?

Did you check the DETAILED STEP BY STEP instructions that I gave you, particularly this step.

graphic

 

 




I have really gone out of my way for almost a day now and several messages/instructions trying to help you free with a side issue that is not related to the main question. Not sure what else I can do. Very frustrating indeed

 

This site does not allow exchanging email addresses

 


Thank you in the meantime

 

Customer: replied 1 year ago.


I followed your instructions. I will try again. This will make the fifth time I have tried to send you the file.

Expert:  John D replied 1 year ago.

Why did you give me a negative rating? Was any of that my fault?

Please remove the negative rating as it will sit in my record for good

Customer: replied 1 year ago.


When you solve my problem, I will give you a positive rating.

 

Send me the link again. I tried to copy and paste the link, but it did not work.

 

I copied and pasted the link and uploaded the file. Did you receive it?

Expert:  flopcat98 replied 1 year ago.
How are you trying to add rows ?
how large is the spreadsheet ?

Do you have it set up with print ranges ?

I suspect that you have it locked into a print range and when you add the rows it makes that print range too large to fit on the page that you already defined. try removing the page range for the section you are adding rows to.
Expert:  John D replied 1 year ago.

Ok send the file by email to info@justanswer.com and put "For John D" in the subject line

 

 

 

 

Customer: replied 1 year ago.


Thank you John. I will change the rating.

Expert:  John D replied 1 year ago.

Thanks.

 

I will let you know as soon as JustAnswer forwards the file to me (could take some time depending on the availability of the site moderator and how busy they are)

 

 

 

 

Customer: replied 1 year ago.


Thank you.

Expert:  John D replied 1 year ago.
Nothing received yet!

Bill in the meantime I want you to try this

Open that Excel file and click the Office button on top and then click the Excel Options button (if you are running Excel 2010 click the File tab, then choose Options)

Next click the Advanced tab on the left pane. Scroll down to "Display options for this workbook" settings. Under "For objects, show" select "All" instead of Nothing (hide objects). Then click Ok

Hope this fixes it for you. If so thank you for rate the answer Excellent
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9655
Experience: Bachelor of Science - Engineering Consultant
John D and 5 other Microsoft Office Specialists are ready to help you
Expert:  John D replied 1 year ago.
So did that work?
Customer: replied 1 year ago.

I stil cannot insert rows. HELP!!!!!!!!!!!!!!!!!!!!

Expert:  John D replied 1 year ago.
What happened after you followed that procedure? What error message ate you getting now?
Customer: replied 1 year ago.


Same message. Cannot move objects off worksheet.

Expert:  John D replied 1 year ago.
Ok I received your file. Will check it and get back to you
Customer: replied 1 year ago.


Thank you.

Expert:  John D replied 1 year ago.

Ok I got it fixed. Here you go

 

http://www.ge.tt/#!/6a6OpmS/v/0

 

Hope this helps. Let me know if you have any questions

 

 

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions