Solved

Needing Instructions for Deleting a geometric box within Excel 2003

Posted on 2006-11-04
3
153 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
  • 2
3 Comments
 
LVL 80

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 80

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now