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.
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
Advertisements