Solved

Needing Instructions for Deleting a geometric box within Excel 2003

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Free HD cloner 11 133
WinX Downloader fails to analyze. 10 104
Krita v3 Linux Mint/Ubuntu 16.04 9 75
Antivirus software for Exchange Mail servers 13 80
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.
Invest in your employees with these five simple steps to improve employee engagement and retention.
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
Viewers will learn how to use the Hootsuite Dashboard.

738 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