HomeExcel Row Vs ColumnExcel Row Vs Column - Convert Row to Column, How to Hide...

Excel Row Vs Column – Convert Row to Column, How to Hide & Freeze

Understanding Excel Row Vs Column enables users to get better insights into using the Excel software. This post will discuss the properties of Excel Row Vs Column, How to hide, unhide and freeze rows-columns, and how to convert row to column and delete contents in a row.

What is Excel Row Vs Column

The data that is represented horizontally is termed as Row. Rows are arranged from left to right. When you open a blank workbook in excel, you see numbers on the extreme left side of the page which indicates Rows. There are a total of 1,048,576 rows in an Excel blank Workbook. Default height of Row is 18.75 pt.

Intro to Excel Row Vs Column

Fig. 1 – Introduction to Excel Row Vs Column

The data that is represented vertically is termed as Column. They are arranged from top to bottom. When you open a blank workbook in excel, you see letters or alphabets on the top of a page which is actually the column heading. Cell is the area that represents intersection of Row and Column. Number of columns is limited to 16,384. Default width of a column is 8.43 pt.

Row Vs Column

Fig. 2 – Excel Row Vs Column

How to Hide Row/ Column

Select the Rows or Columns you wish to hide and right click. Pop up window comes up with option to Hide. Alternatively, you can click on ‘Format’ Menu under ‘Home’ Tab to Hide a Row or Column.

How to Unhide Row/ Column

To Unhide specific Row/ Column, you need to select the entire Row above and below the hidden Row. Right Click and choose the option to Unhide.

Hide and Unhide of Rows Vs Columns

Fig. 3 – Hide/ Unhide Row and Column using (a) Right Click (b) Format Menu

How to Increase Row Height

Select the Row for which you wish to increase the height and right click. Click on ‘Row Height’ option and enter the required dimension.

How to Increase Column Width

Select the Column for which you wish to increase the Width and right click. Click on ‘Column Width’ option and enter the required dimension.

How to Delete Contents of Row/ Column

Select the required Row/ Column and right click. Click on the option ‘Clear Contents’. It will clear the data.

How to Convert Row to Column

It is easy to convert Row to Column using the ‘Transpose’ feature of Excel using the below steps:

  • Select the data you want to Transpose.
  • Click on Copy.
  • Click on any blank Cell where you want to copy the transposed data.
  • Click on ‘Home’ Tab and select drop down arrow under ‘Paste’.
  • While hovering your mouse on the different icons, you will see Transpose option.
  • Click on Transpose and it changes Row to Column.

Transpose in Excel

Fig. 4 – Converting Row to Column using Transpose Feature

How to Freeze Excel Row Vs Column

Freeze option helps you to keep the top Row and first Column visible though you scroll through the entire worksheet.

How to Select Multiple Rows/ Columns

To select Multiple Rows, select one Row initially and hold down Shift key or Ctrl key and select the other Rows/ Columns. Note that it works for adjacent Rows and Columns.

Also Read:
iOS VS Android- Definition, Features, Pros and Cons, the Best One
What is Radio Frequency I Type I Features I Uses I How to Improve

latest articles

explore more

6 COMMENTS

  1. Thank you for the sensible critique. Me and my neighbor were just preparing to do a little research on this. We got a grab a book from our local library but I think I learned more clear from this post. I’m very glad to see such magnificent info being shared freely out there.

  2. Howdy, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam responses? If so how do you reduce it, any plugin or anything you can suggest? I get so much lately it’s driving me insane so any help is very much appreciated.

  3. Have you ever considered writing an ebook or guest authoring on other sites? I have a blog centered on the same ideas you discuss and would really like to have you share some stories/information. I know my viewers would value your work. If you’re even remotely interested, feel free to shoot me an e-mail.

  4. I’m impressed, I need to say. Actually not often do I encounter a weblog that’s both educative and entertaining, and let me tell you, you’ve got hit the nail on the head. Your concept is excellent; the problem is one thing that not sufficient individuals are speaking intelligently about. I am very glad that I stumbled throughout this in my search for one thing regarding this.

  5. Throughout the great scheme of things you get a B+ with regard to hard work. Where you actually confused me personally was in the specifics. You know, as the maxim goes, the devil is in the details… And that couldn’t be more true in this article. Having said that, permit me tell you exactly what did deliver the results. The authoring is definitely extremely engaging and that is most likely the reason why I am taking the effort in order to comment. I do not really make it a regular habit of doing that. Secondly, even though I can notice a jumps in reason you make, I am not convinced of just how you appear to connect your details which inturn help to make the actual conclusion. For now I will, no doubt yield to your issue however wish in the foreseeable future you link the dots much better.

LEAVE A REPLY

Please enter your comment!
Please enter your name here