Fabulous tip on using Google Sheets

[dreamshark]

 Okay, probably nobody reading this will care, but I just learned a great tip on how to make the painfully limited Google Sheets feel a little more like Excel. I like to fiddle, and I am constantly sorting and resorting my tables in different ways (now by first name, now by last name. Can't make up my mind). I often put multiple tables on the same page and of course I want to sort them separately, not mix them all together. Excel has an easy way to quickly select an area of contiguous data, but Sheets does not, so you have to select and drag every time to get the table you want. Similarly with printing just one area of a spreadsheet. Easy in Excel, harder in Sheets. 

Here's the workaround. 

• Select all the cells you want to group together for sorting or printing
• Right-click anywhere in the area and pick "get link to this range"
• Create a text cell somewhere off to the side labeled "print range" or "sort range" and paste the link into it.