MS Excel: Rows - TechOnTheNet

TechOnTheNet Logo
  1. Home
  2. MS Excel
  3. Rows
totn Excel MS Excel: Rows

In Microsoft Excel, a row runs horizontally in the grid layout of a worksheet. Horizontal rows are numbered with numeric values such as 1, 2, 3. Vertical columns are numbered with alphabetic values such A, B, C.

Microsoft Excel

Each row in the worksheet has its own row number which is used as part of a cell reference such as A1, A2, or M16. You can select an entire row by clicking on the row heading (ie: the number running along the left side of the grid layout). In the example above, we have selected row 3.

There are many things that you can do with rows in Excel such as inserting, deleting, hiding, unhiding, and resizing rows as well as conditional formatting. Here is a list of topics that explain how to use rows in Excel.

Insert / Delete

  • Insert a new row in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
  • Delete a row in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003

Hide / Unhide

  • Hide a row in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
  • Unhide a row in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
  • Unhide row 1 in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003

Sizing

  • Change the height of a row in Excel 2016 | 2013 | 2011 | 2010 | 2007 | 2003
  • Stop "wrap text" when pasting in Excel 2013 | 2011 | 2010 | 2007 | 2003

Conditional Formatting

  • Automatically alternate row colors (one shaded, one white) in Excel 2010 | 2007 | 2003
  • Automatically alternate row colors (two shaded, two white) in Excel 2010 | 2007 | 2003
  • Automatically alternate row colors (three shaded, three white) in Excel 2010 | 2007 | 2003
Share on:

Databases

  • SQL
  • Oracle / PLSQL
  • SQL Server
  • MySQL
  • MariaDB
  • PostgreSQL
  • SQLite

MS Office

  • Excel
  • Access
  • Word

Web Development

  • HTML
  • CSS
  • JavaScript
  • Color Picker

Programming

  • C Language

More

  • ASCII
  • Unicode
  • Linux
  • UNIX
  • Techie Humor
clear filter down caret

Excel Topics

  • Array Formulas
  • Cells
  • Charts
  • Columns
  • Filters/Sorting
  • Formulas/Functions
  • Hyperlinks
  • Macros/VBA
  • Pivot Tables
  • Question/Answer
  • Ranges
  • Rows
  • Sheets
  • Workbooks

Home | About Us | Contact Us | Testimonials | Donate

While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy.

Copyright © 2003-2026 TechOnTheNet.com. All rights reserved.

Tag » A Record In Excel Means