Question about Microsoft Computers & Internet

1 Answer

Deleting rows with odd row numbers in one go - Microsoft Computers & Internet

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 1,183 Answers

Hi,
I have found ASAP-Utilities to be excellent for this.

http://www.asap-utilities.com

After you download (free) and install, then in the ASAP menu, go to Columns/Rows, and select the first item ("Conditional Row and Column, select, hide or delete"). The options are clear.



Thanks
Proton

Posted on Sep 13, 2008

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,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to delet empty rows in excel


I am assuming you are using Office version 2003 or newer.
Towards the left border of the sheet there are row numbers; Left click on any number selects the entire row.
Once selected, right click on the row number or anywhere on the selected row and delete from the menu.

To select multiple rows:
1. Hold down the left mouse button and drag till you reach the desired end row. (row selection to be done by clicking on row numbers and not the actual rows)
2. Select a cell (left click), then the combination ctrl+shift+rightArrow. This will select the entire row (only if it is empty). Now use shift+downArrow to select one row at a time or ctrl+shift+downArrow to select all adjacent blank/non-blank rows.

If row number are not visible:
In Office 2007 goto "View" tab. Select "Headings" from the "Show/Hide" group. In other Office versions, use the menu navigation to reach this point.

Jul 11, 2014 | 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

Unable to clear queue on saints row the third


First change the old head with the new box pack head if the problem persist then change carriage unit the problem will be clear.

Jan 01, 2013 | Office Equipment & Supplies

1 Answer

MSI 760gm-p21(fx) MB, JFP1 AND JFP2 PINOUTS I NEED TO SEE A DIAGRAM SHOWING ME EXACTLY WHERE TO PLUG the cables on the MB


http://www.msi.com/product/mb/760GM-P21--FX-.html

Hover your mouse cursor on the Download tab.
(Overview/ Specification/ Download/ Support/ Where to Buy)

In the drop down list click on - Manual
On this page under the subheading Download, click on the blue -
M7641v3.0.zip
On the next page click on the country name nearest yours.

Motherboard User Manual.

This is a Zip file. If you do not know how to open a Zip file, please state in a Comment, and I will guide you.

The front of your computer is the Front Panel.
The area of contact pins on the motherboard, that the main wires from the Front Panel go to, is the Front Panel header.

The Front Panel header is divided into two headers on the motherboard.
This you have stated, JFP1 and JFP2.
(Junction Front Panel 1, and Junction Front Panel 2)

JFP1 is for the Power On switch, HarDDrive activity LED, Reset Switch, and a two wire Power On LED.

JFP2 is for an internal speaker/buzzer, and a three wire Power On LED. (Dual color)

JFP1:
4 pins across the Top row.
5 pins across the Bottom row.

The pins on the Top row are numbered EVEN.
The pins on the Bottom row are numbered ODD.

Starting on the LEFT side coming across to the Right side, Top row;
Pins 2, 4, 6, and 8. There is NO pin 10.

Starting on the LEFT side coming across to the Right, Bottom row;
Pins 1, 3, 5, 7, and 9.

A) Pins 1 and 3 are for the HarDDrive activity LED.
Pin 1 is for the Positive ( + ) wire.
If the HDD LED is dim when the Harddrive is active, switch the wires around.

B) Pins 5 and 7 are for a Reset switch, IF a Reset switch is used.

C) Pin 9 is N/C. Not Connected. It is reserved for the factory to use.

D) Pins 2 and 4 are for a two wire Power On LED.
Pin 2 is for the Positive ( + ) wire.
If the PWR ON LED is dim when the computer is on, switch the wires around.

E) Pins 6 and 8 are for the Power On switch.
F) There is NO pin 10.

JFP2:
4 pins across the Top row.
3 pins across the Bottom row.

The pins on the Top row are numbered EVEN.
The pins on the Bottom row are numbered ODD.

Starting on the LEFT side coming across to the Right, Top row;
Pins 2, 4, 6, and 8.

Starting on the LEFT side coming across to the Right, Bottom row;
Pins 1, 3, and 5. There is NO pin 7.

A) Pins 1, 3 and 5 are for a dual color Power On LED.

Pin 1 is for the Negative ( - ) wire.
Pin 2 is for a Yellow, or Orange part of the dual color Power On LED.
Pin 3 is for a Green part of a dual color Power On LED.

B) Pins 2, 4, 6, and 8, are for a speaker/buzzer.

Pin 2 is for the Negative ( - ) wire of a speaker.
Pin 8 is for the Positive ( + ) wire of a speaker.

Pin 4 is for the Positive ( + ) wire of a buzzer.
Pin 6 is for the Negative ( - ) wire of a buzzer.

For additional questions please post in a Comment.
Regards,
joecoolvette

Jul 28, 2012 | MSI Computers & Internet

1 Answer

Need pinout for A8N-LA front panel to mobo


Mike,

Going to detail it out, so those needing this info in the future also, can use it.

http://h10025.www1.hp.com/ewfrf/wc/document?lc=en&cc=us&docname=c00647121&dlc=en

Scroll towards the bottom of the page for the motherboard illustration, and photo.

The front of a desktop computer is the Front Panel.
The area of contact pins on the motherboard, that the main wires go to from the Front panel, is the Front panel header.

In the illustration, and as the motherboard sits in your computer case, the Front Panel is at the Bottom/Right corner.
In the Illustration it is F_PANEL1.

In the photo it is the black rectangular block, with 9 contact pins.
Two rows of pins.
4 on the Top row, 5 on the Bottom row.

The pins on the Top row are numbered EVEN.
The pins on the Bottom row are numbered ODD.

Starting on the LEFT side on the Top row, going across to the Right;
Pins 2, 4, 6, and 8.

Starting on the LEFT side on the Bottom row, going across to the Right:
Pins 1, 3, 5, 7, and 9.

A) Pins 1 and 3 are for the HarDDrive activity LED.
Pin 1 is for the Positive ( + ) wire.
If the HDD LED is dim when the harddrive is active, switch the wires around.

B) Pins 5 and 7 are for a Reset switch, IF a RST SW is used.

C) Pin 9 is N/C.
Not Connected. Pin is reserved for factory use.

D) Pins 2 and 4 are for the Power On LED.
Pin 2 is for the Positive ( + ) wire.
If the PWR LED is dim when the computer is on, switch the wires around.

E) Pins 6 and 8 are for the Power On switch.

F) There is NO Pin 10. Just a blank spot.

Regards,
joecoolvette

Jul 24, 2012 | ASUS P5PE-VM Motherboard

1 Answer

Front panel configuration


Motherboard installed in computer case;
Processor to the Top, 3 Ram Memory slots to the Right, 5 white PCI slots to the Bottom;

Down in the Bottom/Right corner, is JFP1, and JFP2.

The Front Panel header is JFP1. (Junction Front Panel 1)
The header with two rows of pins, and is positioned Horizontal. It is parallel to the bottom of the motherboard.

(The other Front Panel header is JFP2. It is positioned Vertical, and is above JFP1. You may be using it also. Read on)

There are two rows of pins for JFP1.
5 across the Top, 4 across the Bottom.

The pins on the Top row are numbered ODD.
The pins on the Bottom row are numbered EVEN.

Top row, starting from the Right side, going towards the Left;
Pins 1, 3, 5, 7, and 9.

Bottom row, starting from the Right side, going towards the Left;
Pins 2, 4, 6, and 8. There is NO pin 10.

A) Pins 1 and 3 are for the HarDDrive activity LED light.
Pin 1 is for the Positive ( + ) wire.
If the Harddrive activity LED light is dim, when the harddrive is active, switch the wires around.

B) Pins 5 and 7 are for the Reset switch, IF a Reset switch is used.

C) Pin 9 is N/C. Not Connected. It is/was for the factory.

D) Pins 2 and 4 are for the Power On LED light. A Power On LED light that has 2 wires.
Pin 2 is for the Positive ( + ) wire.
If the Power On LED is dim when the computer is on, switch the wires around.

E) Pins 6 and 8 are for the Power On switch.

Looking at JFP2. (Junction Front Panel 2)
Vertical with two columns of pins.
3 on the Right side, 4 on the Left side.

The Right side is numbered EVEN.
The Left side is numbered ODD.

Starting at the Bottom on the Right side, going Up;
Pins 1, 3, and 5.
Starting at the Bottom on the Left side, going Up:
Pins 2, 4, 6, and 8.

A) Pins 1, 3, and 5, are for a Power On LED light, that has 3 wires.
Pin 1 is for the Positive wire. (Dual color LED )

B) Pins 2, 4, 6, and 8 are for a Speaker. The speaker for BIOS Beep Codes.
Pin 2 is for the Positive ( + ) wire.
Pin 8 is for the Negative ( - ) wire.

Regards,
joecoolvette

Jun 24, 2012 | MSI MS-6580 Motherboard

1 Answer

What is the meaning of rows?


In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:
sgoldberg08_1.jpg

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

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

1 Answer

Excel functions


Here's one way to do it. Your formulas would look like this:

B1:
=IF(OR(J1=1, J2=1, J3=1, J4=1, J5=1),1,0)

B2:
=IF(OR(J1=2, J2=2, J3=2, J4=2, J5=2),2,0)

B3:
=IF(OR(J1=3, J2=3, J3=3, J4=3, J5=3),3,0)

etc.

If you don't want the zeroes to display, format the cells with a custom number format--type: 0;-0;;@

Nov 14, 2007 | Computers & Internet

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

Related Topics:

65 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

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

Answer questions

Manuals & User Guides

Loading...