Solved Copy a table in excel without the empty cells quickly (1 Viewer)

[georg0307]

Deae All,

is it possible with a key or combination buttons select a table into a sheet without empty cells.

I explain better, the same way when you insert a pivot table, you select A and automatically takes all the table (sorry but I have italian version):

 

[Minty]

Do you mean to select all the rows / columns of the sheet that have values?

 

[Grumm]

You can add a filter on the selection (you need to select the entire range you want)
Then filter out the empty lines, Now you can copy paste the visible lines into a new sheet.