Question about Computers & Internet

1 Answer

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

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 36 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
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
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


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

4

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

5

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

6

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.

7

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.

8

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
9

Open the Excel spreadsheet.

10

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.

11

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

12

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

13

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

14

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

15

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

16

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

17

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



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Computers & Internet

Tip

Deleting Rows & Columns from the table


You can also remove columns or rows from the table. Once a row or column is deleted, it can be undeleted by using Undo command. You can delete the columns or rows or cells by using one of the following ways.
By Table Menu
To delete a row or column by Table menu, follow these steps.
  • Place the insertion point in the column or row that is to be deleted.
  • Click Table menu and then select "Delete" from Table menu, a submenu of Delete is displayed.
  • Select Columns or Rows or Cells command to delete the selected element (column or row or cell) from the table.
By Popup Menu
To delete a row or column by popup menu, follow these steps.
  • Select the column's you want to delete.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Columns" command, the selected columns will be deleted.
OR
  • Place the insertion point in the column or row that is to be deleted.
  • Right click the mouse, a popup menu is displayed.
  • Select "Delete Cells" command, "Delete Cells" dialog box is appeared.
  • Select "Delete entire row" to delete a row or select "Delete entire column" to delete a column etc. from the dialog box and click "Ok" button.

on Jan 29, 2010 | Computers & Internet

1 Answer

I can't find the EXP button on my Casio fx-83GT calculator...help?


Your question is slightly ambiguous.

If you refer to the exponential function (power to base e = 2,7182818...), the key sequence is [SHIFT] [ln]. (rightmost button column, two rows below the ON key).

If you refer to a key allowing to enter powers of 10, like in 3,14 x 10²³, see the button labeled
mib8888_43.gif
its located in the bottom button row, center column.

Feb 24, 2011 | Casio FX82ES Scientific Calculator

1 Answer

Where to plug led swich on motherboard ms-7103


There usually is a group of gold-coloured pins, diagonally opposite from the corner where the keyboard/mouse connectors are,
arranged in a "two-by-many" rectangle of rows and columns.

Look for either a "HD LED" or "PWR LED" label.
Connect the LED leads to connect one pin from the "top" row to one pin on the "bottom" row.

Apr 10, 2010 | Computers & Internet

1 Answer

I need to print mailing labels imported from excel to word in columnar order instead of in order by rows across the page.


hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

Dec 14, 2009 | Microsoft Windows XP Professional

3 Answers

CAN'T PRINT LABELS CORRECTLY


you have not set up the proper size .change settings accordingly.

Jan 24, 2009 | Brother MFC-465CN InkJet Printer

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



DGET(database,field,criteria)
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

1 Answer

Flex Grid


The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)


Private Sub Form_Load()
Call SizeCells
Call CenterCells



grdGrid.Row = 0
grdGrid.Col = 1
grdGrid.Text = "Single Sided; Low Density "
grdGrid.Col = 2
grdGrid.Text = "Double Sided; Low Density"
grdGrid.Col = 3
grdGrid.Text = "Singled Sided; High Density"
grdGrid.Col = 4
grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1
grdGrid.Col = 0
grdGrid.Text = "3 1/2 inch"
grdGrid.Col = 1
grdGrid.Text = "$2.30"
grdGrid.Col = 2
grdGrid.Text = "$2.75"
grdGrid.Col = 3
grdGrid.Text = "$3.20"
grdGrid.Col = 4
grdGrid.Text = "$3.50"



grdGrid.Row = 2
grdGrid.Col = 0
grdGrid.Text = "5 1/4 inch"
grdGrid.Col = 1
grdGrid.Text = "$1.75"
grdGrid.Col = 2
grdGrid.Text = "$2.10"
grdGrid.Col = 3
grdGrid.Text = "$2.60"
grdGrid.Col = 4
grdGrid.Text = "$2.95"

End Sub
Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.


Private Sub SizeCells()
Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4
grdGrid.ColWidth(intColumn) = 2200
Next intColumn

End Sub

Private Sub CenterCells()
Dim intColumn As Integer

For intColumn = 1 To 4
grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
Here is the final result:
lesson97-7.jpg

Mar 26, 2008 | Computers & Internet

2 Answers

Should I use countif or if or what ??


hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

54 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...