?
Solved

Excel Spreadsheet Modification

Posted on 2014-03-17
8
Medium Priority
?
210 Views
Last Modified: 2014-03-17
I have an Excel spreadsheet (attached), the rows end at row number 101 and the columns end at column L. My question is, how does one create a spreadsheet like this, that ends at selected rows and columns without any additional rows or columns being visible and apparently being removed completely?
Comment-Matrix.xlsx
0
Comment
Question by:Lord_Dragon
[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
  • 3
  • 3
  • 2
8 Comments
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39934835
by definition/design Excel has so many rows/columns.
If you cut/paste the range into another app (Word?) you will have just the range - hope this helps.
0
 
LVL 26

Expert Comment

by:pony10us
ID: 39934862
In this particular case it appears that the width/heigth of all the columns/rows that are to be hidden were changed to "0" making them "invisible".
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39934878
That would work (labour intensive); your statement 'how does one create a spreadsheet  .. apparently being removed completely' gave me the impression you wanted them removed.
0
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 

Author Comment

by:Lord_Dragon
ID: 39934890
Cutting/pasting the range into another app (Word?) would mean it is no longer an excel spreadsheet and no longer has the functionality of excel so that isn't the way to go but thanks.

In response to Sage, what are the steps for what you suggested? Excel rows and columns go on forever so how would I select the range? Thank you for your response as well.
0
 
LVL 26

Accepted Solution

by:
pony10us earned 2000 total points
ID: 39934894
To remove all colums after column L you whould highlight column M. Then press the End key and the right arrow to highlight all columns to the right. Right click any highlighted column and select column width. Type "0" in the box and press enter.

Repeat for the rows starting at 102 only use the down arrow and row heigth set to "0"

You will have to manually do any other columns/rows such as A-F in your example.
0
 

Author Comment

by:Lord_Dragon
ID: 39934970
Sage, you are the man. It worked perfectly. Thank you sir.
0
 

Author Closing Comment

by:Lord_Dragon
ID: 39934977
Great answer!
0
 
LVL 26

Expert Comment

by:pony10us
ID: 39934995
Glad to be of assistance.   :)
0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn the different options available in the Backstage view in Excel 2013.

800 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