Content of the material
- Recent Posts
- How it works: Pull data from multiple sheets of a single Google Sheets doc
- Frequently Asked Questions
- How to Link a Paragraph in Google Docs
- Option 2 – How to Add a Paragraph Border in Google Docs
- Step 6: Customize the appearance of the horizontal line as needed, then click the Apply button.
- How to link to section in Google Docs?
- Google Docs link to Section
- Does adding publicly shared file to your Google Drive reveal your identity?
- Can I import data in Google Sheets from another sheet including formatting?
- Navigation-Friendly Documents
- #EduDuctTape: Al Thomas – Visual Storytelling in the Classroom
- #EduDuctTape BONUS: Overthrowing Education
- #EduDuctTape: Chris Nesi – Podcasting in the Classrom
- Tools for Student-Paced Learning
- #EduDuctTape: Stephanie Howell – Student Choice Activities in Google Slides + Design Tips
How it works: Pull data from multiple sheets of a single Google Sheets doc
We have a Google Sheets doc with five sheets that contain data about deals for different years: 2016, 2017, 2018, 2019, and 2020:
Instead of manually copying data from each sheet or building a complex IMPORTRANGE formula, we can simply specify the names of sheets as follows:
Click “Save & Run” and the data from the sheets will be pulled into our destination sheet. What are the main benefits? You’ll get a column indicating which sheet a data set belongs to. Besides, the title rows from each sheet except for the first one are skipped, so you get a smooth merge of data.
If you wanted to do the same using IMPORTRANGE, here is what your formula should look like:
It’s important to specify exact data ranges like
2018!A2:EU972, otherwise you’ll get multiple blank rows between the data. And do not expect to get your data right away – IMPORTRANGE works pretty long. In our case, we had to wait a few minutes before the formula pulled in the data.
Frequently Asked QuestionsHow do I make a vertical line in Google Docs?
You can add a line between document columns by going to Format > Columns > More options and checking the box next to Line between columns.You can add a border line to a paragraph by going to Format > Paragraph styles > Borders and shading then choosing the settings for the the left or right border.Is there a keyboard shortcut for a horizontal line in Google Docs?
No, there is not keyboard shortcut in Google Docs for adding a horizontal line. You can underline selected text by pressing Ctrl + U, however, or you can strikethrough selected text with Alt + Shift + 5.
How do I remove a horizontal line in Google Docs? Click at the start of the line below the horizontal line, then press the Backspace key on your keyboard to delete it. As mentioned earlier, you may also be able to select the line and delete the selection as well. However, whether or not you are able to use that method will depend on how you chose to insert a horizontal line in your document.
There are many other objects and items that you can add to your documents, some of which aren’t visible. For example, learn how to add a page break in Google Docs if you need to start the next page of your document before Google Docs automatically does it for you.
How to Link a Paragraph in Google Docs
It’s easy to link a chapter or section of a document using the Heading option. If you want to link a paragraph, line, or a word, you can use the bookmark option in Google Docs. Here’s how you can use it.
Step 1: Open the document in Google Docs. Move the cursor to the particular paragraph or line which you would like to link.
Step 2: Now select on the Insert menu at the top and choose the Bookmark option from the list. A bookmark symbol will appear where the cursor was placed.
Step 3: Now head over to the text which you wish to link to this bookmark.
Step 4: Highlight the text and use the Ctrl+K shortcut to open the link menu. In there, expand the ‘Headings and bookmark’ option to select the bookmark created in Step 2.
The linked text will appear as blue underlined text and you’ll be able to jump to that particular bookmark by clicking on the linked text. To remove the created bookmark, simply tap on the bookmark icon next to the text and choose Remove.
Option 2 – How to Add a Paragraph Border in Google Docs
While this isn’t technically the same thing as adding a horizontal line, it does offer a similar effect. Plus you can customize paragraph borders a little bit, which can be preferable to some Docs users.
Step 6: Customize the appearance of the horizontal line as needed, then click the Apply button
You will have the ability to change the Border width, Border dash, Border color, Background color, and Paragraph padding of your horizontal line.
The final method for adding a horizontal line to your document is by using the Drawing tool, which we discuss in the next section.
How to link to section in Google Docs?
Here, we will discuss how to link a section within a google doc. Follow the below steps.
Step 1: To link to the bookmark, you set already, go to the section of the document that you want to link.
Step 2: Select the word, an entire sentence, or a paragraph that you want to be part of the link and then right-click on it.
Step 3: From the menu that opens, select ‘Link’
Step 4: A new field will appear that lets you choose what you want to link to. You can choose from either headings or bookmarks which are external URLs. Or simply paste the link you have copied and click the blue ‘Apply’ button.
The link to the section is done and now you can go straight to the bookmark you set! In this way, you can link a section within Google Docs.
Google Docs link to Section
Do you want to use the Google Docs link to section option to give your readers instant access to information in another section of the same Google Docs document?
Fortunately, you can add hyperlinks easily to other sections of your Google Docs document using text. By using the Google Docs link to sections, you can provide information to your readers without repeating the same information on different pages.
Does adding publicly shared file to your Google Drive reveal your identity?
Shared documents have a “Add to My Drive” feature that lets you create a shortcut to the file in your Google Drive. This feature is only meant for convenience, organization and easy access to shared files. It doesn’t reveal your identity to the owner of the file. Also take note that this feature doesn’t create a copy of the file in your Google Drive. If the owner revokes access, you will not be able to access the file anymore.
Bottom line: If a shared file appears in your Google Drive, it doesn’t mean the file’s owner knows about your identity. They won’t even know you’ve added the file to your drive.
Can I import data in Google Sheets from another sheet including formatting?
Unfortunately, neither of the options above will let you import the formatting of the cell(s) you reference to. The logic of IMPORTRANGE, FILTER and other Google Sheets native options does not entail the actual transfer of data. They only reference and display data from the source cells. Coupler.io is the only option that copies the data from the source, but it only imports the raw data without any formatting. At the same time, you can use Coupler.io to link Excel files, as well as Excel and Google Sheets.
BUT, you can always use the benefits of Google Apps Script to create a custom function for your needs. For example, the following script will let you transfer data from one sheet or spreadsheet to another:
You need to go Tools > Script editor. Then insert the script in the Code.gs file and specify the required parameters:
- ID of the source and destination spreadsheets
- Names of the source and destination sheets
(If you’re importing data between sheets, the source and destination spreadsheet ID will be the same)
When ready, click “Run” and your data including formatting will be imported into the destination sheet.
Note: This solution may not be a fit for your project, so you’ll need to update the script whatever you require.
Link paragraphs or sections is a helpful feature to make your documents richer in Google Docs. That is useful to solve navigation and scrolling woes between sections while working on long documents, brochures, custom templates, etc.