Solved

Excel Spreadsheet Modification

Posted on 2014-03-17
8
206 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
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 …

777 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