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

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.

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

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

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

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

13 rows and 4 in the top row

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:


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!

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.)

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;;@