Calculate Formulas in Highlighted Cells Only--not whole sheet

In office 97 I was able to recalc only the cells highlighted (control + L) as 
opposed to the entire sheet or workbook.  In Excel 2002, how do I recalc only 
the cells I have highlighted?  Thanks
0
D (176)
11/3/2004 12:11:04 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
971 Views

Similar Articles

[PageSpeed] 21

I don't recall this shortcut in xl (any version).

I'm guessing that you had a macro that did something special.

In xl2002, you could use a macro like this (assigned to ctrl-shift-l)

Option Explicit
Sub testme()
    Selection.Calculate
End Sub

But I think I've read posts that calculating a single range can be bad--it can
screw up the calculation dependencies.

I think that Charles Williams has posted some comments that recommend not doing
this.

Here's one thread.
http://groups.google.com/groups?threadm=uR8sJ6vLEHA.3216%40TK2MSFTNGP12.phx.gbl

Charles has some more info at:
http://www.decisionModels.com/calcsecretsh.htm

Tony D wrote:
> 
> In office 97 I was able to recalc only the cells highlighted (control + L) as
> opposed to the entire sheet or workbook.  In Excel 2002, how do I recalc only
> the cells I have highlighted?  Thanks

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
11/3/2004 1:38:18 AM
Reply:

Similar Artilces:

problem with index formula
The following fomula is contained in cell C16 and returns the correct values: =VLOOKUP(B6,'Active Clients'!$B$2:$K$954,10,FALSE) The following formula is contained in cell L18 and uses the result in C16 as a lookup value in the first "match": =INDEX(L21:M44,MATCH(C16,L21:L44,1),MATCH(M16,L21:M21,-1)) My promlem is that when I try to match on cell C16 my index formula returns an error. However, when I change the index formula to reference another cell (let's say cell D16) and I type in the value shown in cell C16, the index formula works fine. I think my problem has ...

How do I display a formula calculation in plot area of a chart?
I want to add a text box in the chart that returns the value from a formula that was entered on the data page. The formula value is not related to any series value. WiseGuyOne: You need to build your text expression in a cell, then insert that expression to the chart. First, to build your text expression: 1. Select your cell 2. Enter = first to let Excel =know you are adding a formula 3. You can now enter text within quotes and cell values .. here's an example =" Yesterdays average temperature was " & sheet1!$a$3 Note that the & is used to add ...

What is the cell data reference for 5th row and 7th column called
Can someone help me with this question? I need to get the answer for my homework. Thanks for your help. I'm guessing, but might it be G5? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Shy-di@verizon.net" <Shy-di@verizon.net@discussions.microsoft.com> wrote in message news:A0979494-228B-435E-98F7-6BD26C900266@microsoft.com... > Can someone help me with this question? I nee...

IF FORMULAS #2
Looking for help...... In column A1:A16, I have names. In B1:B16 I will assign random numbers to those names from 1-16. In another part of the sheet I have 16 columns lets say D:S, (D) being column 1 and (S) being column 16. when I assign a number in column B, I want the name to the left to appear above the appropiate column. EX, If B1 is 16 then the name in A1 will appear above column S. I am using Excel 2007 Windows Vista. I find this site to be the place for answers,everyone is great. Thanks in advance. D1: =INDEX($A$1:$A$16,MATCH(COLUMN()-3,$B$1:$B$16,0)) Fill to S1. "JOHN...

tab between sheets
Any way to select a different sheet without using the mouse -- Message posted from http://www.ExcelForum.com Hi CTRL-PGUP and CTRL-PGDOWN -- Regards Frank Kabel Frankfurt, Germany > Any way to select a different sheet without using the mouse? > > > --- > Message posted from http://www.ExcelForum.com/ In Excel Go to Help, type in keyboard shortcuts This will give you tons of information "laneman >" <<laneman.14pfas@excelforum-nospam.com> wrote in message news:laneman.14pfas@excelforum-nospam.com... : Any way to select a different sheet witho...

how do i see the numbers of pages at the bottom of my work sheet?
i used to see the page numbers at the bottom of the screen when i worked on a multi-page document, so i could easily move from page to page. now i have to go to edit- then go to page- which is very inconvenient. what happened maggiekins wrote: > i used to see the page numbers at the bottom of the screen when i > worked on a multi-page document, so i could easily move from page to > page. now i have to go to edit- then go to page- which is very > inconvenient. what happened ============================= View / Status Bar. -- ******John Inzer******** **MS Picture It! MVP** ...

Cell Contains Data.
How can I tell a cell that IF a cell contains data (numbers, text, whatever) do x or y. How can I identify data?? I don't want to tell the function to look for a specific number or text, just data, just something in the cell... =IF(A1<>"","Data","No Data") "GEM" <GEM@discussions.microsoft.com> wrote in message news:07916799-F312-4E89-A926-59356B74ED89@microsoft.com... > How can I tell a cell that IF a cell contains data (numbers, text, > whatever) > do x or y. How can I identify data?? I don't want to tell the function ...

Active cell highlight
Hi, I would like to know if there was a way to have an active cell always in yellow or any color. Example: If the active cell is moved around, the active cell will be always in yellow. Thank you in advance maybe.... you may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm E wrote: > > Hi, > > I would like to know if there was a way to have an active cell always in > yellow or any color. > > Example: If the active cell is moved around, the active cell will be always > in yellow. > > Thank you in advance -- Dave Pet...

Need to separate multiple numbers in one cell
I have multiple number in one cell and i need to somehow put each number into one separate cell for each number: I have : column A row1 2 5 8 10 I want: column B column C column D column E row1 2 5 8 10 How do I do it on Excel 2007? thanks EggHeadCafe - Software Developer Portal of Choice Map Stored Procedure Output To Class Properties http://www.eggheadcafe.com/tutorials/aspnet/2853a1aa-5db7-40d0-9cde-46847fa770ef/map-stored-procedure-outp.aspx Hi, Use Data > Text to columns and specify the delimiter as space ...

Need Formula to Average Monthly Increase
I have a spreadsheet where there are columns for each month of the year Each cell contains a number of loan submissions that graduall increases per month as we gain more business from each mortgage vendor I need a formula that can look at multiple cells in a row (i.e Jan-Dec) per vendor and then give me a result that shows the averag monthly percentage increase factor in submissions... Example: MONTH Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec A SUBS 1 5 18 29 30 40 57 85 150 275 ......... ..I will be using this data fo forecasting future submissions ...

copy value in cell above to cell below for a whole column
I have a spreadsheet that was saved from a report. this report only lists the employee name once. There is a way to copy the value of the cell above to the cell below. I can get as far as highlighting the blank cells with the Go To function, then I can not remember the steps to tell excel to copy the data into the blank cells. Can anyone help? Ctrl+D will copydown the value of the top cell to the highlighted cells below. "tarthur" wrote: > I have a spreadsheet that was saved from a report. this report only lists > the employee name once. There is a way to copy th...

How can I remove the previous lock cells and keep the new ones.
Could you please help me?... I locked and protected the cells A1:H20 in the sheet 1 two months ago. However, yesterday I wanted to unlock and unprotect these cells and locked and protected the cells A21:H40 instead. However, for some reason the cells A1:H20 are still lock and protect. How can I remove the previous lock cells (A1:H20) and keep the new cells (A21`:H40) only. Thanks. Maperalia In EXCEL 2007 take the following actions to unlock cells A1 to H20:- 1. Home / Cells group / Format / Unprotect Sheet / enter the password to Unprotect Sheet / OK / highlight cells A1 t...

Existing formula
I'm working with a spreadsheet that was built by someone else and cam across a formula in some of the cells that I'm puzzled by. The formul begins with "=", but the next character is "+", then a reference t another worksheet and cell. The "+" is what I'm wondering about, haven't seen it used in this context before, can someone help me ou here? Some examples of what I'm looking at are: =+Inputs!G9 =+H17-R20 Thanks, wwhit -- Message posted from http://www.ExcelForum.com It's an unnecessary character that is there because the person ...

Going Back in History formula?
How can I express a formula that would back 300 rows and look at every other row for the 3 cells with random single digits from 0 to 9 and calculate, the how many rows back since the oldest 0-9 digit occurred in cell 1 answer, cell 2 answer and 3 answer, then calculate which 0-9 digit has not occurred in cell 1, cell 2 and cell 3 the longest and displays how many row back since the last occurrence. So that would be 4 separate formulas ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.Exc...

How do I enter a time formula into a worksheet that determines if.
How do I, set about entering a formula within a worksheet that determines if the Time is greater or less that the time in a certian cell; eg =if(now()>K17,"then display this","") K17 holding the Value 08:30 AM formated to time =IF(MOD(NOW(),1)>K17,"then display this","") HTH Jason Atlanta, GA >-----Original Message----- >How do I, set about entering a formula within a worksheet that determines if >the Time is greater or less that the time in a certian cell; >eg =if(now()>K17,"then display this","") ...

formulas changing when emailed
At work, I have created a spreadsheet that has links to workbooks in a user drive..called the "U: drive." When I transfer this excel project to others via email, I make sure that the other workbooks also have the same name in their U: drive as well. However, whenever I email it... I have to change many of the formulas at their computers bc the references in my formulas change to a really long string. I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't work for me bc I have "+" "=" elsewhere in my formulas....

Adding data from multiple cell and linking to a new worksheet
I have data in a sheet with names and amounts due. Like A 500 B 300 A 600 B 300 C 400 C 200 There is a second sheet named summary. I want the totals of each person to appear in the summary sheet. These should be linked cells and any change in data in sheet 1 should be updtaed automatically Create a PivotTable http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Dave Hawley www.ozgrid.com "Rashmi" <Rashmi@discussions.microsoft.com> wrote in message news:56DC0F3A-8D60-4FE2-B778-3A07790EFE8A@microsoft.com... >I have data in a sheet wi...

Move cells down to match cells
A B C D E 1 000801025-8 009601025-3 2007 000801025-8 2007 2 000801026-9 009601026-4 2004 000801026-9 2004 3 000801028-1 009601028-6 2006 000801028-1 2006 4 000801036-8 009601036-3 2008 000801036-8 2008 5 000801044-5 009601044-0 2007 000801044-5 2007 6 000801044-5 009601055-0 2004 000801055-5 2004 7 000801055-5 009601064-8 2001 000801064-3 2001 8 000801055-5 009601091-2 2006 000801091-7 2006 9 000801064-3 009601095-6 2002 000801095-1 2002 10 000801091-7 009601097-8 1998 000801097-3 1998 11 000801091-7...

using data from another cell
I would like to type a name in one cell(1) then check in list (different column) if the same name is there, and if it is there get a value of another cell locate in the same row where. Can some one help me? Create your second list and use VLOOKUP as follows: Name is typed in: A1 List of names and values in: C1:D10 =VLOOKUP(A1,$C$1:$D$10,2,FALSE) "leo" <reani1996@hotmail.com> wrote in message news:OiO5fCTWDHA.2268@TK2MSFTNGP11.phx.gbl... > I would like to type a name in one cell(1) then check in list (different > column) if the same name is there, and if it is t...

How to exclude cells from a datasource?
Hi, I have an XY chart in excel97 that uses a range of cells for the data source. Every now and then I would like to exclude a XYnode from the chart. Without having to reselt the datasource. Is there a value one can enter in the cell that exludes it from the graph (compare: putting text in a cell excludes it from the SUM() function). For example point X Y a 1 1 b 2 2 c 3 3 Gives a graph with two lines connecting the three points While point X Y a 1 1 b ? ? c 3 3 Should give a graph with one line connecting point a and c. Point b is left out. Or is the...

What must I do to get gridlines printed for both filled and empty cells?
Hi, What must I do to get gridlines printed for both filled and empty cells? I'm a teacher, and I'm trying to replicate and print, in Excel, an attendance book format, with a series of tiny squares next to each student's name. The printed form of this would allow me to register if a student were present or absent on a particular day. Hubert -- Hubert Earl, vendor of fine Jamaican art, coffee, etc. on eBay: http://www.stores.ebay.com/id=12295024&ssPageName=L2?refid=store; Fine Jablum Blue Mountain Coffee sales page: http://stores.ebay.com/Jamaican-Coffee-Art-and-More-Store_Jab...

Copying formatting of entire sheet
I made an Excel 2007 workbook which includes my monthly business income, parts bought, a logbook for car mileage dividing into personal and work and finally a financial end of year total constantly updated by the income or parts bought over the financial year. What I would like to know, please, is how to copy the entire logbook (12 sheets, 1 per month then 1 for end of financial year totals and 1 for car miles) FORMATTING so that I can have it all ready for the next financial year. I live in Australia and our financial year ends Jun 30 and starts the new one July 1. What I would like t...

Macros on Protected Sheets #2
Hi , Now I have tried Alan's Solution to be able to run my Macros in Protected sheets but as I am not VB literate, I think I have made a Syntax mistake. Sub Newaction() Sheet("Critical Path").Unprotect ("My Password") ' Newaction Macro ' Macro recorded 17/11/2004 by Clifford ' ' Selection.AutoFilter Field:=1, Criteria1:="=" Sheet("Critical Path").Protect ("My Password") End Sub I receive a message "Compile error" "Sub or function not defined" Can you tell me what's wrong ? Regards ...

Excel 2003 - VBA
Hi Guys: I'm drawing a blank and need some help. I have a table with row 3 containing sheet names (currently pointing at 106 sheets). In rows 4-250 I want to put formulas that will look for something (located in Column B) in each of the sheets named in row 3. The first cell in the target sheet contains the last row with valid data. Example: Cell "D3" = P02-05 Cell "B5" = 123456789IBM In cell "D5" I want to generate a formula that will look in sheet P02-05, search for the contents of "B5" throughout the sheet and return the Value in colum...

Excel Cell Formatting #3
How do I centeer a picture in an Excel cell? Hi you can't as such objects 'float' above the cells in Excel -- Regards Frank Kabel Frankfurt, Germany "Tom Coffey" <Tom Coffey@discussions.microsoft.com> schrieb im Newsbeitrag news:8E7356E1-4318-42F3-B9C6-3D7EDFBBEEA1@microsoft.com... > How do I centeer a picture in an Excel cell? ...