Waffle Bytes

(Part of my administrative assistant series on Google Sheets.) There are several ways to insert rows and/or columns in a spreadsheet in Google Sheets.  The easiest way is to highlight the row (or column) you want to add next to by clicking on the row or column name (the letter or number...).  Then use one of these methods: Go to the Insert Menu and select Row above or Row below, as wanted Right click on select Row above or Row below, as wanted But what about if you want to insert more than one row?  Do you have to add one row at a time? NO - you do not. You can instead highlight as many rows (or columns) as you wish to add - Then using one of the two methods above add MULTIPLE rows or columns at one time - A time saver for those of you that were adding individual rows or columns :-)

I'm working with several people whom are dealing with very large spreadsheets right now.  Unfortunately it took me too long to realize that they were unaware of this very useful Sheets feature - the ability to freeze some of the rows and columns so they could always view (in their case) the student names in the first column, and the data fields in the first row. Here is a spreadsheet with some sample data.  I want to always see the top row (Row 1) and the first column (Column A) - Go to the View menu, mouse over the first option of Freeze, and you get a pop-up that shows your choices for freezing rows and columns - The options 1 row/column and 2 rows/columns are available as they are the most common needs.  But occasionally you need more than that, so there is the customizable option of Up to the current row/column - this is based on the cell you current have active (selected) on the spreadsheet. Once you select what you want to freeze, a think gray border li...