Skip to main content

Ten Second Tech Tip - Add Multiple Rows or Columns Easily to Tables and Sheets!

Do you use Google Sheets or tables in Google Docs?  (I personally love tables for making complex information clearer!)  Both Sheets and tables allow you to add additional rows and columns, but one at a time.  Here is a quick way to add multiple rows or columns with a few clicks!



While in Google Docs:

Using an existing table (you can determine how many columns/rows when you create):

  • Highlight the number of existing rows or columns you would like to add
  • Click Format>Table>Insert Row or Column (you specify where in the table).



The number of rows or columns you highlighted will be added to the table in the Doc!

While in Google Sheets:


Highlight the number of rows or columns you would like to add
Click Insert>Number of rows or columns Left or Right


The number of columns you highlighted will be added in the Sheet in the location you specified!


Comments

Popular posts from this blog

Draftback Replays a Google Document's Changes in Video Format!

Student plagiarism can be a problem.  The world we live in makes it easy for students to copy/paste,  using works not their own. Identifying plagiarism and addressing it is a big part of students learning to be good digital citizens.  My last post outlined the new Originality Reports in Google Classroom, which check student submissions for plagiarism and incorrect or missing citations.    Occasionally, you will have a situation that needs a thorough investigation.  The Google Chrome extension Draftback is your superhero in this situation!  (Shout out to the Science Department, who discovered this gem!) Can't I see a document's version history? You may be aware that you can look at the revision history for any Google Doc or Slide.  Click File>Version History>See version history.   You are provided a right sidebar.  You can click on any revision to review the document at that time.  Changes from the pr...

Google Classroom: Why Are Students Seeing Graded Returned Work as Assigned or Late?

Are students giving you feedback that work you returned to them after grading is now showing as 'late' or 'assigned'?   The addition of the Grading module to Google Classroom has impacted this process.  Read on to understand what is happening and how to fix it! What is happening? Let's follow through the typical workflow in Google Classroom where students are submitting work to you.  You create an assignment in Google Classroom and assign the appropriate points to the assignment .   You assign the work to students, which puts the work in status ' Assigned ' in the student view.   After updating the assignment, students turn in or submit work back to you by clicking the Turn In button.   The work status changes to ' Turned in.' After grading, you return work to students.  This is a necessary step to ensure the student owns the document.   The status now changes to ' Returned ' if you...

Zipgrade - Leverage your phone camera for grading!

If you have used a scantron to grade exams in the past, you may have been frustrated with the Scantron availability, speed, accuracy, and data.  Consider using Zipgrade , a free app that leverages the camera in your cell phone! Why Should I use Zipgrade? Quick -  grade your exams as fast as your phone camera scans! Easy to use! Accurate! Cost effective  - 100 scans per month free! Convenient  - grade tests when you want, not when the machine is available! If you change the answer key, Zipgrade re-grade s all exams automatically! Easy to analyze data by student and question! How do I use Zipgrade? Create Account & Download App Navigate to  https://www.zipgrade.com/login/ and create an account. Download the Zipgrade app from the appropriate app store for your phone: App Store Google Play Create a Class While logged into Zipgrade's web application, under the  Class heading, select Add New Class ...