Hi
something that has bugged me for years and just wondered if anyone knows a quick way to highlight all the column/rows with data excluding hedings so they can be copied and pasted. I have spreadsheets that can have upwards of 60 columns and 10s of thousands of rows
putting a 0 at the end of the first and last row entry on the column after the last one with data in it helps as a guide to where to scroll but still takes ages.
Any easy way to do this ?
something that has bugged me for years and just wondered if anyone knows a quick way to highlight all the column/rows with data excluding hedings so they can be copied and pasted. I have spreadsheets that can have upwards of 60 columns and 10s of thousands of rows
putting a 0 at the end of the first and last row entry on the column after the last one with data in it helps as a guide to where to scroll but still takes ages.
Any easy way to do this ?