Solved

Needing Instructions for Deleting a geometric box within Excel 2003

Posted on 2006-11-04
3
155 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 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

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

Suggested Solutions

Title # Comments Views Activity
Best cloning software for Windows 7 (Physical System Drive) 5 132
Batch convert .doc to .docx 13 177
Ransomware attacks 5 85
PDFMate free PDF Merger. Security concern 8 87
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.

920 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

15 Experts available now in Live!

Get 1:1 Help Now