Solved

Excel Spreadsheet Modification

Posted on 2014-03-17
8
205 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
  • 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
 

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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 26

Accepted Solution

by:
pony10us earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

895 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