Skip to content
Live2Tech
Menu

Rows

How-to guides and tutorials about topics involving rows that you add, edit, or remove from your documents or spreadsheets.

Excel worksheet with the formula =A2^B2 in the formula bar and the result highlighted in column C

How to Expand All Rows in Excel for Office 365

September 24, 2026February 9, 2023 by Kermit Matthews

Expand all rows in Excel for Office 365: open grouped rows with outline numbers, unhide hidden rows, AutoFit row height, and clear filters. Continue Reading How to Expand All Rows in Excel for Office 365

Categories Excel Tags Rows
Google Sheets View menu with Freeze open and 1 row highlighted

How to Lock a Row in Google Sheets

September 24, 2026July 19, 2022 by Kermit Matthews

Lock a row in Google Sheets by freezing it with View > Freeze so it stays visible, or protect it with Data > Protect sheets and ranges. Continue Reading How to Lock a Row in Google Sheets

Categories Google Sheets Tags Featured Sheets Guides, Rows
Google Sheets right-click menu on row numbers with Resize rows highlighted and the Resize rows dialog set to a specific height

How to Set Row Height in Google Sheets

September 24, 2026April 28, 2022 by Kermit Matthews

Select rows, right-click, and choose Resize rows. Enter a height in pixels or pick Fit to data. How to drag, resize every row, and use the mobile app. Continue Reading How to Set Row Height in Google Sheets

Categories Google Tags Featured Sheets Guides, Rows
Google Docs table with a row selected and the right-click menu showing Insert row below highlighted

How to Add a Row to a Table in Google Docs

September 24, 2026February 8, 2022 by Kermit Matthews

Right-click a cell and choose Insert row above or below, or press Tab in the last cell to add a row at the end. Steps for several rows and the mobile app. Continue Reading How to Add a Row to a Table in Google Docs

Categories Google Docs Tags Rows
Spreadsheet with the Data tab Group button highlighted and three selected rows grouped with an outline bar and collapse button in the left margin

How to Group Rows in Excel for Microsoft 365 (Collapse and Expand)

September 25, 2026March 4, 2020 by Kermit Matthews

Group rows in Excel for Microsoft 365 to collapse and expand sections, with shortcuts, nested levels, Auto Outline, Subtotal, and how to ungroup. Continue Reading How to Group Rows in Excel for Microsoft 365 (Collapse and Expand)

Categories Excel Tags Rows
Online spreadsheet with rows 3 through 5 selected by their row numbers and the right-click menu open with Copy highlighted

How to Copy Multiple Rows in Google Sheets

September 26, 2026December 18, 2019 by Kermit Matthews

Copy multiple rows in Google Sheets: click the row numbers with Shift, press Ctrl + C, then paste. Plus non-adjacent rows and values-only paste. Continue Reading How to Copy Multiple Rows in Google Sheets

Categories Google Sheets Tags Featured Sheets Guides, Rows
Spreadsheet Paste Special dialog with the Transpose checkbox selected to paste a vertical column as a horizontal row

How to Paste Vertical Data Horizontally in Excel (Transpose)

September 25, 2026May 18, 2017 by Kermit Matthews

Paste vertical data horizontally in Excel, or the reverse, with Paste Special Transpose, the Ctrl+Alt+V shortcut, or the TRANSPOSE function. Continue Reading How to Paste Vertical Data Horizontally in Excel (Transpose)

Categories Excel Tags excel 2013, Rows
Spreadsheet View tab with the Freeze Panes menu open and Freeze Top Row highlighted

How to Keep the Top Row Visible in Excel

September 25, 2026January 6, 2017 by Kermit Matthews

Keep the top row visible in Excel with Freeze Top Row, freeze multiple rows or columns, unfreeze panes, and fix Freeze Panes when it’s grayed out. Continue Reading How to Keep the Top Row Visible in Excel

Categories Excel Tags excel 2013, Rows

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2026
  • Popular
  • iPhone
  • Excel
  • Word
  • Docs
  • Sheets
  • Tutorials