Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Excel Spreadsheet Modification

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
Lord_Dragon
Asked:
Lord_Dragon
  • 3
  • 3
  • 2
1 Solution
 
COACHMAN99Commented:
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
 
pony10usCommented:
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
 
COACHMAN99Commented:
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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
Lord_DragonAuthor Commented:
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
 
pony10usCommented:
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
 
Lord_DragonAuthor Commented:
Sage, you are the man. It worked perfectly. Thank you sir.
0
 
Lord_DragonAuthor Commented:
Great answer!
0
 
pony10usCommented:
Glad to be of assistance.   :)
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now