Question about Business & Productivity Software

1 Answer

Can we replace column & rows label with each -other if yes ,How?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 36 Answers
Re: Can we replace column & rows label with each -other...

First, select all the data you wish to transpose, and hit <CTRL>+<C> to copy it. Next, open a new sheet, and select the cell you want to be the top-left cell of your data (usually A1). Now, go to the Edit menu, select "Paste Special" and select "Transpose" from options presented.

If you choose, you can copy this sheet back to the original location.

Posted on Dec 30, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Sum numbers in a column down until you come to a blank, then start again

Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC


How to find no. of rows and columns in Worksheet.

Hello everybody, this would be my first tip on Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
This is how you can find out.
1. Select A1 cell in the worksheet
2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

on Jul 27, 2010 | Microsoft Excel for PC

1 Answer

Cell freeze 3 rows together at a time.

Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.

Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.
Freeze or lock rows and columns
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
Open the Excel spreadsheet.
Navigate to the "View" tab on the top menu.

3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.


Select the "Freeze Top Row" option to freeze the top row.


Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.


Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.


Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.


Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns

Open the Excel spreadsheet.


Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.


Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.


Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.


Navigate to the "View" tab on the top menu.


Click on "View," then click on "Freeze Panes." A drop-down menu opens.


Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.


Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.


Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."
Freeze or lock rows and columns
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Business & Productivity...

1 Answer

My worksheet has a lot of pages visible and so my columns and rows are very small..How can i manage this?

The number of pages you have is not related to the size of the columns and rows. You can set those to any size you wish.
By "a lot of pages" do you mean there are many colums or many tabs?
If you have lots of columns, just resize them to a good size. Each tab acts like a separate sheet and the columns and rows can be sized independently of the others.
So, right-click on the column letters and choose the column size you want.
Right-click on the row numbers and do the same for row height.

Mar 28, 2010 | Microsoft EXCEL 2004 for Mac

2 Answers

How to number a column. I can't remember the short formula, something like a1+1= which would make the number two pop up in the cell underneath.

You can number rows in a column by entering a number in cell A1 (usually the number 1 but youcan start with any number) and the formula (=A1+1) in the next row. The result there will be 2. Copy that formula down the rows you want to number and they will be numbered 3, 4, 5, etc. Each row adds 1 to the previous row so if you do anything that disrupts the sequence (like inserting a row between two others) you will have to copy the formulas down again to restore the sequence. You can also use the Edit-Fill-... menu command to put a series of numbers into rows. Put the starting number in th efirst row. Highlight it and the rows that you want to number and select Edit-Fill-Series... Those numbers will not change if you insert columns or move the formulas.
Or you can use the formula =ROW(A1) in any cell to return the number of that row. (The result of =ROW(A1) is the number 1 in cell A1, the result of =ROW(A2) is the number 2 in cell B2, etc. In this case inserting rows will not affect the numbering (i.e. row A5 will always be numbered 5 even if the data in it is moved down.)

Sep 18, 2009 | Microsoft Excel for PC

2 Answers

Ranking values based on the number of times they appear/repeat

=SUM(IF((Ax:Ay="xxxxx"),1,0) Ax=starting cell Ay=ending cell "xxxxx"=text"

Jun 08, 2009 | Microsoft Excel for PC

1 Answer

Freezing column and rows simultaneously

in Excel
go to window/split; move the bars to the row and column you want to freeze; the go to window/freeze panel

Jan 06, 2009 | Business & Productivity Software

1 Answer

About formula

One way of finding (and removing) duplicate entries is to sort the column and put a simple formulate in a temporary column next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press <ctrl>-D to extend the formula in B2. Wherever there is a duplicate you'll see "DUP" in column B. If you want to remove the duplicates copy column B and Edit / Paste Special... with "values" selected (to wipe out the formula). You can then sort the spreadsheet on column B and remove rows with DUP in column B.

If you can't delete the duplicate rows and the order is important first include a column that captures the order - same trick except put row() in that column, copy / paste special the values and then you can re-sort after doing the above to have both the DUPs marked and the original order.

Hope that helps.

Aug 08, 2008 | Microsoft Business & Productivity Software

1 Answer

If function in exel

For Current Date - you can use the =Now() function in your cell where you want the date.

For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL

Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Jul 15, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??

hi this my id plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

52 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides