[SOLVED] Crop sheet to data or selection

Hello.

I would like to know how can i quickly remove extra rows and columns from a Excel sheet.
Example: I have only 10 rows, with 5 colums (10x5). The rest of this are just empty rows and empty columns

I wanna show only rows and columns that contains data!
Below a image demonstrating what i want to achieve but in Google Sheets:

image_2022-01-11_173851.png

Thanks in advance!

Edit: Solved by Haluk!

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Originally Posted by alansidman

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I don't really understand why someone would want to re-type my data...
The images are for visualization only. As a IT Technician i can confirm that most people understand things faster and better when the explanation comes with visualization...

I honestly feel like you are complicating something that is not that complicated - I just wanna hide the blank/unused rows and columns
But thanks. I appreciante your efforts - I did what Haluk told below and did what i wanted to achieve. it was exactly what i needed and described on the topic!

Thanks for your answer tho. Have a nice day.