Skip to main content

Posts

Showing posts from February, 2018

Copy a Google Sheet, Into Another Workbook. Sure, Sounds Easy...It's not copy & paste.

Copy a Google Sheet, Sure, Sounds Easy... Sometimes someone will send you some information that is in its own workbook. One sheet, one workbook, per person who sends you information. Sound familiar? Then you have to select all, Ctrl + C, and Ctrl + V it into the main workbook you were already working in. Then...start reformatting. Been there, done that. Over it. There's an easier way. At the bottom of your page, click on the drop-down arrow next to the sheets title, most likely it'll say 'Sheet 1' unless your sender organizes their sheets.  In the pop-up, click 'Copy to' Select the workbook you want it to go into, it does NOT even have to be open at this time.  Type the title or keywords of the workbook you're seeking in the search bar Click on Recent and select the workbook you are seeking If you're not the owner of the master workbook you're seeking, look in the 'Shared with me' section.  Click the blue select button after the...