• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Rows and Columns in Excel

Home » Excel » Excel Tips » Rows and Columns in Excel

By Jyoti Singh Leave a Comment

Rows and Columns in Excel

Rows and Columns in Excel

Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell. A cell is the intersection of rows and column.

  • In excel we can also tailor the worksheet as per our needs and can make the best use of the available space. The rows and columns can be moved, copied, shaped as per our specific needs that add more value to the blank white space. If we are making a program and have some designing to do than this will surely need to move and resize the area to make the specific designing.
  • The area of the worksheet where we type and do our data work consist of the rows and columns and the intersection of these rows and columns is called a cell.
  • The rows move downward and column moves from left to right. However, a cell goes from left to right, right to left, up to down and down to up. This means that if at any time we have selected any part of worksheet than this means that we have actually selected a cell.
  • Rows and columns work with each other. Generally, data is entered in rows and header of that data is always entered in the columns. This is a universal rule but this can change depending upon the type of data that we have.

Examples of Rows and Columns in Excel

Below are examples of rows and columns in Excel:

Example #1 – Rows of Excel

There are a total of 10,48,576 rows that are currently available in Microsoft Excel. The rows are aligned vertically and are ranked as 1,2,3,4…….10,48,576. If we have to move from one row to another then we need to move downward or upward.

Rows of excel 1

Example #2 – Column of Excel

There is a total of 16384 columns that are available in excel currently. The first column is called “A” and the last column is called “XFD”.

The columns are aligned from left to right, this means that if we need to go to another column then we need to move from left to right.

Columns are horizontally placed.

Column of excel

Example #3 – Cell of Excel

The intersection of rows and column is called a cell, the cell location combines the column number and the row number. Hence a cell is called as “A1”,”A2” and so on.

Cell of Excel

Example #4 – Deleting a Row

A row can be deleted by using the keyboard shortcut that is Ctrl+”-“

Deleting a Row

Example #5 – Deleting a Column

A column can be deleted by using the keyboard shortcut that is Ctrl+”-“.

Deleting a Column

Example #6 – Inserting a Row

A row can be inserted by using the option of ctrl+ ”+”

Inserting a Row

Example #7 – Inserting a Column

A column can be inserted by using the option of ctrl+ ”+”

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Inserting a column

Example #8 – Hiding a Row

A row can be set to hide by using the menu option. First, Go to Home tab then select Format and click on hide rows.

Hiding a row

Example #9 – Hiding a Column

We can also hide a column by using the menu option. Go to Home tab then select Format and click on hide columns.

Hiding a Column

Example #10 – Increasing the Width of the Row

Sometimes the width is also required to be increased if we have more data in the row.

Increasing the Width of the Row

Example #11 – Increasing the Width of the Column

A width of the column needs to increase if the length of the text is more than the width of that column.

Increasing the Width of the Column

Example #12 – Moving a Row

A row can also be moved to another location.

Moving a Row

Example #13  – Moving a Column

A column can also be moved to another location.

Moving a Column

Example #14 – Copying a Row

The data of the row can be copied and pasted into another row also.

Copying a Row

Example #15 – Copying a Column

The data of the column can also be copied in any other column.

Copying a Column

Example #16 – Autofit Height of the Row

This feature will make the height of the row to adjust as per the text length.

Autofit Height of Rows ans columns Excel

Example #17 – Autofit Width of the Column

We can also make the width of column adjust as per the length of the text.

Autofit Height of rows and Columns Excel

Example #18 – Grouping Rows

We can also group the rows and make the data easier to understand.

Grouping Rows and columns in excel

Example #19 – Grouping Columns

We can group the columns and make them as one cluster

Grouping rows and Columns in excel

Example #20 – Setting Default Width of Rows and Columns in Excel

If we want that the height and width of the excel column and rows can be again restored back to one specific defined measures that we can use this option.

Rows and Columns in Excel 18

How to use Rows and Columns in Excel?

#1 – To delete a row and column

To delete any row or column first we need to select that row or column and the right click from the mouse and at last, we need to choose the option of “Delete”.

#2 – Inserting a row and columns

To insert a row and columns we need to first select the location and then select the option of “Insert”.

#3 – Hiding a row or column

We can also hide the row and column by using the menu option. Of hiding.

#4 – Increasing the width

If we need to increase the width of the row and column then we can simply select that row or column and then drag the width.

#5 – Copying

To copy a row or column, just select that row and click on copy and then paste at the required location.

#6 – Autofit

If we want to autofit the height then we can choose this option from the “Format” toolbar and click on autofit.

#7 – Grouping

If we need to group the rows or column then we just need to select the rows and choose the option of “Group” from the data tabs.

Things to Remember

  • The count of available rows and columns in excel cannot be increased but can be reduced as per the need.
  • We cannot change the sequence in which the rows are ranked. The count will always start from 1 and increase by one.
  • No column can be inserted to the left of column “A”.
  • If a column is inserted to the right of a column than all the formatting is also copied from the left cell.
  • Rows are numbered however the columns are arranged alphabetically.

You can download this Rows and Columns Excel Template from here – Rows and Columns Excel Template

Recommended Articles

This has been a guide to Rows and Columns in Excel. Here we discuss how to delete, insert, hide and copy Excel Rows and Columns along with examples and download Excel template. You may learn more about excel from the following articles –

  • Compare and Match Columns in Excel
  • Excel Rows vs Columns – Differentiate
  • Excel Sum Multiple Rows
  • Excel Count Rows
  • VBA LEN
  • How to Insert Multiple Rows in Excel?
  • How to make Alternate Row Color in Excel
  • Rows to Columns in Excel
  • Compare Two Columns in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Excel Tips

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Limited Period Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More