James Halliburton
asked on
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
Comment-Matrix.xlsx
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".
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sage, you are the man. It worked perfectly. Thank you sir.
ASKER
Great answer!
Glad to be of assistance. :)
If you cut/paste the range into another app (Word?) you will have just the range - hope this helps.