Question about Microsoft MS OFFICE 2007 SBE MLK (NA) SW. (RZ365A#ABA)

I HAVE EXCELL SHEET IN WHICH I HAVE GIVEN FORMULAS IN COLUMN ''B'' SAME WILL BE COPIED FOR 5 COLUMN, C,D,E,F & G

If you want the result of your formula in colum "B" to be appeared in 5 others column, simply put new formula in the other colum with syntax "=CELLID".

i.e:

put "=B1" (withoud quote) in cell C1, D1, E1, F1 and G1. do the same for the others cell, or just drag your cell to the bottom of page. it will copy your formula automatically.

If that not what you want, please update ypur question with more understandable phrase...thank you

Posted on Mar 11, 2009

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

Click on the column-heading to select the entire column.

Right-mouse-click to select "copy".

Move the mouse-pointer to where you want the copy to appear.

Right-mouse-click and choose "insert copied cells".

Right-mouse-click to select "copy".

Move the mouse-pointer to where you want the copy to appear.

Right-mouse-click and choose "insert copied cells".

Sep 16, 2014 | Microsoft 1994 Office Excel Spreadsheet...

Here's what you are looking for. Browse it and you can find it there all you want for shortcut keys. Follow this link below:

Microsoft Excel Shortcut keys

__Enter data by using shortcut keys____To____Press__

Complete a cell entryENTERCancel a cell entryESC**Repeat the last action****F4 or CTRL+Y****Start a new line in the same cell****ALT+ENTER**Delete the character to the left of the insertion point, or delete the selectionBACKSPACEDelete the character to the right of the insertion point, or delete the selectionDELETEDelete text to the end of the lineCTRL+DELETEMove one character up, down, left, or rightArrow keysMove to the beginning of the lineHOME**Edit a cell comment****SHIFT+F2****Create names from row and column labels****CTRL+SHIFT+F3****Fill down****CTRL+D****Fill to the right****CTRL+R****Fill the selected cell range with the current entry****CTRL+ENTER****Complete a cell entry and move down in the selection****ENTER****Complete a cell entry and move up in the selection****SHIFT+ENTER****Complete a cell entry and move to the right in the selection****TAB****Complete a cell entry and move to the left in the selection****SHIFT+TAB****Work in cells or the formula bar by using shortcut keys****To****Press****Start a formula****= (EQUAL SIGN)****Cancel an entry in the cell or formula bar****ESC****Edit the active cell****F2****Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents****BACKSPACE****Paste a name into a formula****F3****Define a name****CTRL+F3****Calculate all sheets in all open workbooks****F9 ****Calculate the active worksheet****SHIFT+F9****Insert the AutoSum formula****ALT+= (EQUAL SIGN)****Enter the date****CTRL+; (SEMICOLON)****Enter the time****CTRL+SHIFT+: (COLON)****Insert a hyperlink****CTRL+K****Complete a cell entry****ENTER****Copy the value from the cell above the active cell into the cell or the formula bar****CTRL+SHIFT+" (QUOTATION MARK)****Alternate between displaying cell values and displaying cell formulas****CTRL+` (SINGLE LEFT QUOTATION MARK)****Copy a formula from the cell above the active cell into the cell or the formula bar****CTRL+' (APOSTROPHE)****Enter a formula as an array formula****CTRL+SHIFT+ENTER****Display the Formula Palette after you type a valid function name in a formula****CTRL+A****Insert the argument names and parentheses for a function, after you type a valid function name in a formula****CTRL+SHIFT+A****Display the AutoComplete list****ALT+DOWN ARROW**

Microsoft Excel Shortcut keys

Complete a cell entryENTERCancel a cell entryESC

on Feb 11, 2011 | Computers & Internet

Hi, Not sure if this is what you have tried:

1: Assuming each run is on a different column

Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..

Then you can use:

=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).

If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)

1: Assuming each run is on a different column

Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..

Then you can use:

=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).

If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)

Oct 21, 2009 | Microsoft Excel for PC

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

lets say you have the column B with the prices. Got to column C right beside the first price cell (I'll take B2 as first cell for example) which is C2 and type

=1.2*B2

Copy this formula in the column C all the way down to the last price Cell. That will give you all the updated prices.

Before you delete the column B where all your old prices are you need to do one more thing. Select the entire C column (new prices) go to edit and click on copy. Before you click anywhere else go back to edit and click on paste special and select value. This will change the formula cell you have created a minute ago to a value cell. Now you can delete the old prices. Good luck :)

=1.2*B2

Copy this formula in the column C all the way down to the last price Cell. That will give you all the updated prices.

Before you delete the column B where all your old prices are you need to do one more thing. Select the entire C column (new prices) go to edit and click on copy. Before you click anywhere else go back to edit and click on paste special and select value. This will change the formula cell you have created a minute ago to a value cell. Now you can delete the old prices. Good luck :)

Feb 25, 2009 | Computers & Internet

You did not respond to my claification request. Here is some code that might help, it copies a selection of cells going down until an emty cell is found and across until an emty cell is found. This is form an earlier version of office but should comeclose to woring in 2007.

Sub copyrange()

'

' copyrange Macro

' Macro written by Royal 11/22/2008.

'

'save the return values

wksname = ActiveSheet.Name

returncell = ActiveCell.Address

searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)

Worksheets(1).Activate

findfor = "A1"

On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _

xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _

False).Address

If findfor = "A1" Then

erwks = ActiveSheet.Name

Sheets(wksname).Activate

er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")

Exit Sub

Else

findfor.Activate

End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries

begcell = ActiveCell.Address

begcl = ActiveCell.Cells.Column

begri = ActiveCell.Cells.Row

'search amaximum of 1000 rows and 676 columns

endri = begri + 1000

endcl = 26 * 26

maxrow = 0

maxcol = 0

For col = Cells.Column To endcl

If Cells(begri, col) = "" Then

maxcol = col

col = endcl

ri = endri

Else

ri = begri

End If

For ri = ri To (Cells.Row + 1000)

If Cells(ri, col) = "" Then

If ri > maxrow Then

maxrow = ri

End If

ri = endri

End If

Next ri

Next col

maxrow = maxrow - 1

maxcol = maxcol - 1

'copy the selected area

endcell = Cells(maxrow, maxcol).Address

crnge = begcell & ":" & endcell

Range(crnge).Select

Selection.Copy

'go back and paste it in

Sheets(wksname).Activate

Range(returncell).Select

' use this if yo want to paste formulas etc.

'ActiveSheet.Paste

' use this code if you want to paste values instead of formulas etc.

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=False

Range(returncell).Select

Sub copyrange()

'

' copyrange Macro

' Macro written by Royal 11/22/2008.

'

'save the return values

wksname = ActiveSheet.Name

returncell = ActiveCell.Address

searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)

Worksheets(1).Activate

findfor = "A1"

On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _

xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _

False).Address

If findfor = "A1" Then

erwks = ActiveSheet.Name

Sheets(wksname).Activate

er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")

Exit Sub

Else

findfor.Activate

End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries

begcell = ActiveCell.Address

begcl = ActiveCell.Cells.Column

begri = ActiveCell.Cells.Row

'search amaximum of 1000 rows and 676 columns

endri = begri + 1000

endcl = 26 * 26

maxrow = 0

maxcol = 0

For col = Cells.Column To endcl

If Cells(begri, col) = "" Then

maxcol = col

col = endcl

ri = endri

Else

ri = begri

End If

For ri = ri To (Cells.Row + 1000)

If Cells(ri, col) = "" Then

If ri > maxrow Then

maxrow = ri

End If

ri = endri

End If

Next ri

Next col

maxrow = maxrow - 1

maxcol = maxcol - 1

'copy the selected area

endcell = Cells(maxrow, maxcol).Address

crnge = begcell & ":" & endcell

Range(crnge).Select

Selection.Copy

'go back and paste it in

Sheets(wksname).Activate

Range(returncell).Select

' use this if yo want to paste formulas etc.

'ActiveSheet.Paste

' use this code if you want to paste values instead of formulas etc.

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=False

Range(returncell).Select

Nov 20, 2008 | Computers & Internet

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.

Good luck.

Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:

=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)

Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!

Terry

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:

=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)

Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!

Terry

Aug 30, 2008 | Microsoft Excel for PC

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):

A1: Part B1: Code C1: Price D1: Find Part E1: Find Code

A2: x B2: 11 C2: 5.00 D2: y E2: 12

A3: x B3: 12 C3: 6.00 D3: y E3: 11

A4: y B4: 11 C4: 7.00 D4: x E4: 12

A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):

A1: Part B1: Code C1: Price D1: Find Part E1: Find Code

A2: x B2: 11 C2: 5.00 D2: y E2: 12

A3: x B3: 12 C3: 6.00 D3: y E3: 11

A4: y B4: 11 C4: 7.00 D4: x E4: 12

A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft 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

104 people viewed this question

Usually answered in minutes!

×