Solved

Needing Instructions for Deleting a geometric box within Excel 2003

Posted on 2006-11-04
3
165 Views
Last Modified: 2012-05-05
Hi Everyone:
 
       I finally have the spreadsheet ready to print.  Unfortunately, on the last page there is a geometric box occupying cells A48-A51 as indicated within the Print Preview Screen.  Could someone provide the steps necessary for getting rid of this box?

       Thank you.

       George
0
Comment
Question by:GMartin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 17875488
George,
If the box is cell borders, then:
1) Select the cells
2) Open the Format...Cells...Border menu item and choose the "None" option for cell borders

If the box is a shape object, then:
1) Try to click on the border of the box. If you see selections "squares" at the corners and midpoints, then try to delete the shape by hitting the Delete key

If all else fails, consider posting your file. The preferred method at this time is to use the Experts-Exchange file sharing site. It is available to all registered Experts-Exchange members and it is free.
1) Zip your file or files
2) Navigate to http://www.ee-stuff.com, and click Login in the upper right corner
3) Enter your Experts-Exhange user name and password
4) Click the Login command button, then click the tab for "Expert Area"
5) Click "Upload a new file"
6) Copy the complete URL of the question and paste it into the text box labeled "Question". Alternatively, paste just the question number (e.g. 22049353).
7) Click the "Browse..." button and select the zipped copy of your file to upload
8) Type a comment describing the file. You must type something, but it doesn't need to say much more than here is GMartin's file
9) Click "Upload" button to upload the file
10) Please post a link to the file in a Comment. You'll find this link in the dialog displayed after you click the "Upload" button.

Many ISP allow their customers to create a personal web page. If so, you can post your file there, and then put the link in a Comment. This is the approach that I used to take.

You can post your file for free at Geocities:  http://geocities.yahoo.com/ps/learn2/HowItWorks4_Free.html
Another popular free site is AngelFire http://www.angelfire.lycos.com/doc/subscriptions/index.html
Google is also trying to encourage people to post files with them. http://base.google.com/base/default 

If you don't want to sign up for one of the above services, then RapidUpload.com provides a free service at http://www.rapidupload.com/

If none of the above work out for you, I would be willing to post a link to your file if you e-mail it to me. My address appears at the bottom of my Experts-Exchange profile-- http://www.experts-exchange.com/M_1064321.html If you mail me the file, please put a link to your question in the e-mail.


Hoping to be helpful,

Brad
0
 

Author Comment

by:GMartin
ID: 17875503
Hi Brad:

       Thank you so much for the tip on this one.  Great job!!! May I add how impressed I am with your indepth knowledge and skills with Excel 2003.  It is like having a professional consultant to guide me every step of the way.  

        Incidentally, since the box was created through manipulation of the cells, your firs suggestion involving going into the Borders area and selecting None did the trick here.

        Thanks so much again.

        George
0
 
LVL 81

Expert Comment

by:byundt
ID: 17875581
George,
You are one of the more prolific questioners on Experts-Exchange, and it is always a pleasure to try to offer help.

Thanks for the grade!
Brad
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A list of useful business intelligence software.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
This video shows how use content aware, what it’s used for, and when to use it over other tools.
Viewers will learn how to use the Hootsuite Dashboard.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question