Archive for November 2017
Quickly Move Cell Ranges in Google Sheets
There’s no need for using copy/paste when moving your data in Google Sheets. You can simply select a range of cells and drag them to a new location, retaining all formatting. Moving Cell Ranges This example shows some data that isn’t in the best order. It would probably be better to have the “First” name column…
Read MoreTranspose Data In Google Sheets
Sometimes we end up with data in a column then later realize that it needs to be in a row, or vice versa. This is called transposing. Fortunately, Google Sheets makes it very easy to quickly transpose your data. How to Transpose Data This example shows weekdays listed down one column, and names of people…
Read MoreGmail Out-of-Office Auto Reply
When you’re on vacation, out of the office for any reason where you won’t be answering emails, it’s always a good idea to set up an auto reply so that people know you’re gone and when to expect you back. This way you (hopefully) won’t be bombarded by emails that you will have to sift…
Read More