• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

Computer Notes

Library
    • Computer Fundamental
    • Computer Memory
    • DBMS Tutorial
    • Operating System
    • Computer Networking
    • C Programming
    • C++ Programming
    • Java Programming
    • C# Programming
    • SQL Tutorial
    • Management Tutorial
    • Computer Graphics
    • Compiler Design
    • Style Sheet
    • JavaScript Tutorial
    • Html Tutorial
    • Wordpress Tutorial
    • Python Tutorial
    • PHP Tutorial
    • JSP Tutorial
    • AngularJS Tutorial
    • Data Structures
    • E Commerce Tutorial
    • Visual Basic
    • Structs2 Tutorial
    • Digital Electronics
    • Internet Terms
    • Servlet Tutorial
    • Software Engineering
    • Interviews Questions
    • Basic Terms
    • Troubleshooting
Menu

Header Right

Home » Excel » Rows & Columns in Excel 2010
Next →
← Prev

Rows & Columns in Excel 2010

By Dinesh Thakur

The tabular format of MS Excel is made up of rows and columns.

  • Column runs vertically, while Row runs horizontally.
  • The row number, which runs vertically down the left side of the sheet, identifies each row.
  • The column header, which runs horizontally across the top of the sheet, identifies each column.

In MS Excel 2010, row numbers range from 1 to 104857, for a total of 1048576 rows, and column numbers range from A to XFD, for a total of 16384 columns.

Navigation with Rows and Columns 

Let’s look at how to get to the last row or column.

  • Pressing Control + Down Navigation arrow will take you to the last row.
  • Control + Right Navigation arrow will take you to the last column.

Excel ColumnsCell Introduction  

The intersection between rows and columns is called a cell.

The column header and row number are used to identify each cell.

For example: A1, A2

Intersection of Column and rowColumns add a row to a worksheet

To add a single row, select the entire row or a cell in the row above which you want to add a new row. For example, click a cell in row 5 to add a new row above row 5.

To add multiple lines, select the lines above which you want to add lines. Select the same number of rows as the number of rows you want to add—for example, select three lines to add three lines.

To add non-contiguous rows, hold down the CTRL key while you select non-contiguous rows.

Select a cell, range, row, or column

On the Home tab, in the Cells group, click the arrow under Insert, and then click Insert Sheet Rows.

Note: You can also right-click the selected rows and click Add.

Note: When you insert rows in your worksheet, all references affected by the insertion, whether relative or absolute cell references will be adjusted accordingly.

The same behavior applies to deleting rows unless the deleted row is directly associated with a formula. If you want the references to be set automatically, it is better to use range references where they fit with your formula rather than specifying individual cells.

Adding columns to the worksheet

To add a single column, select the column just to where you want to add a new column or a cell in that column. For example, if you want to add a new column to the left of column B, click a cell in column B.

To add multiple columns, select the columns just to the right of where you want to add columns. Select the same number of columns as the number of columns you want to add. For example, select three columns to add three new columns.

To add non-contiguous columns, hold down the CTRL key while selecting non-contiguous columns.

Select a cell, range, row, or column

On the Home tab, in the Cells group, click the arrow next to Insert, and then click Add Page Columns.

Note: Also, right-click on the selected cells and Add

Note: To immediately repeat the column insert action, click where you want to add a column and press CTRL + Y.

If the cells you moved or copied contain formatting, you can use the Insert Options icon to adjust the formatting of the inserted columns.

Cell Sizing

The width of a cell depends on the column, and its height depends on the row. A cell alone cannot be sized. All cells in that row or column are sized. We can do the sizing in the following ways:

  1. Drag between row/column headers.
  2. Double click between the column headers. (The column will be sized according to the longest data contained in the cells in the cells).
  3. Format-Row-Height, Format-Column-Width.
  4. To make the height and width of multiple rows the same, drag is applied between headings after the column or rows are selected.

Show or Hide Columns and Rows

You can hide a row or column using the Hide command; however, rows and columns are also hidden when row height or column width is set to 0 (zero). You can have them reappear using the Show command.

You can redisplay specific rows and columns or re-view all hidden rows and columns at the same time. Reworking the first row or column of the worksheet is a bit tricky but can be done.

Hiding one or more rows or columns

Select the rows or columns you want to hide.

Click Format in the Cells group on the Home tab. Do one of the following:

Under Visibility, point to Hide and Show and click Hide Rows or Hide Columns. Under Cell Size, click Row Height or Column Width and type 0 in the Row Height or Column Width box.

Note: You can also right-click a row or column (or a selected range of rows or columns) and click Hide.

Displaying One or More Rows or Columns

To view hidden rows, select the rows above or below the rows you want to view.

To view the hidden columns, select the adjacent columns on either side of the columns you want to view.

To display the first hidden row or column in a worksheet, select it by typing A1 in the Name Box item next to the formula bar.

Note: You can also select it using the Go To dialog box. Under Editing on the Home tab, click Find and Select, and then click Go. Type A1 in the reference box, and then click OK.

  1. Click Format in the Cells group on the Home tab.
  2. Under Visibility, point to Hide and Show and click Show Rows or Show Columns.
  3. Under Cell Size, click the Row Height or Column Width option and type the value you want in the Row Height or Column Width box.

Note: You can also right-click the visible row and column selection next to hidden rows and columns and click Show.

Displaying All Hidden Rows and Columns Simultaneously

Selecting all cells on the worksheet for doing one of the following:

Click the Select All button or press CTRL + A. Click Format in the Cells group on the Home tab. Do one of the following:

  1. Under Visibility, point to Hide and Show and click Show Rows or Show Columns.
  2. Under Cell Size, click the Row Height or Column Width option and type the value you want in the Row Height or Column Width box.

You’ll also like:

  1. Working with Excel 2010
  2. Excel 2010 Components
  3. Zoom IN/OUT in Excel 2010
  4. BackStage View in Excel 2010
  5. Managing Data in Excel in 2010
Next →
← Prev
Like/Subscribe us for latest updates     

About Dinesh Thakur
Dinesh ThakurDinesh Thakur holds an B.C.A, MCDBA, MCSD certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps.

Dinesh Thakur is a Freelance Writer who helps different clients from all over the globe. Dinesh has written over 500+ blogs, 30+ eBooks, and 10000+ Posts for all types of clients.


For any type of query or something that you think is missing, please feel free to Contact us.


Primary Sidebar

Excel 2010

Excel 2010 Tutorials

  • Excel - Started
  • Excel - Tour
  • Excel - BackStage View
  • Excel - Entering Values
  • Excel - Navigating Workbook
  • Excel - Save Workbook
  • Excel - Open/Close Worksheet
  • Excel - Managing Worksheet
  • Excel - Managing Data
  • Excel - Rows & Columns
  • Excel - Copy & Paste
  • Excel - Find & Replace
  • Excel - Spell Checker
  • Excel - Zoom In/Out
  • Excel - Paginated View
  • Excel - Insert Comments
  • Excel - Insert Text Box
  • Excel - Undo/Redo
  • Excel - Formatting Cells
  • Excel - Formatting Worksheets
  • Excel - Working with Formula
  • Excel - Quick Access Toolbar
  • Excel - Name Field
  • Excel - Formula Bar
  • Excel - Status Bar
  • Excel - Full Screen Mode
  • Excel - Grid and Indexing Fields
  • Excel - Preferences Window
  • Excel - Color Scheme

Ribbon Tab

  • Excel - Ribbon Tabs
  • Excel - Show and Hide Ribbon
  • Excel - Adding Ribbon Groups
  • Excel - Active Label of Ribbon Group
  • Excel - Customizing the Ribbon
  • Excel - Contextual Ribbon Tabs

Other Links

  • Excel - PDF Version

Footer

Basic Course

  • Computer Fundamental
  • Computer Networking
  • Operating System
  • Database System
  • Computer Graphics
  • Management System
  • Software Engineering
  • Digital Electronics
  • Electronic Commerce
  • Compiler Design
  • Troubleshooting

Programming

  • Java Programming
  • Structured Query (SQL)
  • C Programming
  • C++ Programming
  • Visual Basic
  • Data Structures
  • Struts 2
  • Java Servlet
  • C# Programming
  • Basic Terms
  • Interviews

World Wide Web

  • Internet
  • Java Script
  • HTML Language
  • Cascading Style Sheet
  • Java Server Pages
  • Wordpress
  • PHP
  • Python Tutorial
  • AngularJS
  • Troubleshooting

 About Us |  Contact Us |  FAQ

Dinesh Thakur is a Technology Columinist and founder of Computer Notes.

Copyright © 2023. All Rights Reserved.