Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Needing Instructions for Deleting a geometric box within Excel 2003

Posted on 2006-11-04
3
Medium Priority
?
181 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 2000 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Invest in your employees with these five simple steps to improve employee engagement and retention.
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

704 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