Question about Computers & Internet

Ad

I hope when somebody advertised and said we can help you free they really can do it

Posted on Apr 15, 2009

Ad

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

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.

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

Well, the equation is Ax=b and we want so solve for x

There are several ways of entering the data, but this is one way

Code: A=[15+35i 29+1i; 46+13i 62+3i]

b=[0;0]

x=A\b which has the trivial solution x=[0;0] (the ";" means "next row", a space next column.) To input a matrix use APPs then Data/Matrix Editor then New. Then change Data to Matrix. Put in the name such as "AA" in the variable field. Then enter row and column dimensions. Then edit as a spread sheet. Use F6(util) to delete a column or row. To manipulate matrices, exit the matrix application, then go to MATH then Matrix. Notice that J(RowOpps) is available. Good luck and thank you for using FixYa! We would sure appreciate a 4 "thumbs-up" rating for this answer. Happy holidays!

There are several ways of entering the data, but this is one way

Code: A=[15+35i 29+1i; 46+13i 62+3i]

b=[0;0]

x=A\b which has the trivial solution x=[0;0] (the ";" means "next row", a space next column.) To input a matrix use APPs then Data/Matrix Editor then New. Then change Data to Matrix. Put in the name such as "AA" in the variable field. Then enter row and column dimensions. Then edit as a spread sheet. Use F6(util) to delete a column or row. To manipulate matrices, exit the matrix application, then go to MATH then Matrix. Notice that J(RowOpps) is available. Good luck and thank you for using FixYa! We would sure appreciate a 4 "thumbs-up" rating for this answer. Happy holidays!

Dec 05, 2010 | Texas Instruments TI-84 Plus Calculator

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

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

error 7e means "no head parameters stored in the eeprom".

1) locate the head data sticker at the front left of the machine. it should have a 12 digits number at the top row and headx..... at the second row. the data is the 12 digits number. if the sticker is missing somehow, there's another one at the head/carriage unit.

2) enter maintenance mode.

3) enter 6 and 8 for property data entry

4) enter 2 5 8 0 within 2 seconds and you're at the data entry state.

5) key in the 12 digits number. use # and 1 to 6 to enter letter a to f.

6) hit the ok button. machine should beeps and display "input accepted". if it say "input error" there's a checksum error, meaning you keyed the number in wrong. it will return you to the data entry state.so just key the number in again (step 5).

7) exit maintenance mode. done.

1) locate the head data sticker at the front left of the machine. it should have a 12 digits number at the top row and headx..... at the second row. the data is the 12 digits number. if the sticker is missing somehow, there's another one at the head/carriage unit.

2) enter maintenance mode.

3) enter 6 and 8 for property data entry

4) enter 2 5 8 0 within 2 seconds and you're at the data entry state.

5) key in the 12 digits number. use # and 1 to 6 to enter letter a to f.

6) hit the ok button. machine should beeps and display "input accepted". if it say "input error" there's a checksum error, meaning you keyed the number in wrong. it will return you to the data entry state.so just key the number in again (step 5).

7) exit maintenance mode. done.

Nov 21, 2009 | Brother MFC-5440CN All-In-One InkJet...

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

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

lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Computers & Internet

Hi,

Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970

The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.

The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.

Hope this helps.

Glad to be of assistance - please rate the solution I can learn from you. Thanks

Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970

The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.

The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.

Hope this helps.

Glad to be of assistance - please rate the solution I can learn from you. Thanks

Oct 24, 2008 | Microsoft Office 2003 Basic Edition...

Assuming that all of your data is in a single row number 4 and between columns N and PF

Try:

{=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

Regards,

Daryl

Try:

{=OFFSET(N4,0,MATCH(TODAY(),N4:PF4,0)+1,1,1)}

The MATCH function looks up the value of today() in the range N4 to PF4 and returns the number of columns offset from the beginning of the range. (The 0 here does an exact match)

The OFFSET function returns a value from a cell a specified number of columns from a reference cell, in this case N4, which is the first column that contains the search data. We need to add on to this value to skip the Interest column.

Regards,

Daryl

Jan 25, 2008 | Computers & Internet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Computers & Internet

at first select the 1st page data and select data-subtotal from the upper menu list.

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

Jun 19, 2018 | Computers & Internet

Jun 19, 2018 | The Computers & Internet

19 people viewed this question

Usually answered in minutes!

×