Over 1 million tech questions and answers.

highlight dynamic cells when they tick in excel

Q: highlight dynamic cells when they tick in excel

I have a large spreadsheet that has dynamic cells being fed by a pricing engine. I need to monitor when a price changes. How can i make the cell highlight everytime a price ticks so that i can immediately see the change.


Preferred Solution: highlight dynamic cells when they tick in excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: highlight dynamic cells when they tick in excel

can you upload a dummy set of data
what do you mean by
price ticks

have a look at conditional formatting

Read other 2 answers

Yes, can anyone help me figure out how to use the Find and Replace command (Ctrl-F) in excel to highlight the cells that's been found in yellow or any color.

Sometimes, I would have to verify and match serial numbers from a hardcopy and file that was sent to me. It would be great (and would make life easier) if I could have excel or the Find and Replace command to automatically highlight each cell that is found. Thanks

A:Excel: Highlight Find/Search Cells

Read other 11 answers

I know this is probably very simple, and I am going to hit myself once the answer is found, but I cannot seem to think of the solution for the question below.

I need to highlight all the cells in a column that does not contain a zero. How would I go about doing this with code?

A:Solved: Excel Macro - Highlight Certain Cells

Read other 9 answers

I have a macro that marks correct answers based on the correct value in B2 - B17 and AI2 - AI17 being the wrong answer.
Also if B2 - B17 is entered incorrectly that cell color turns red. If the answer is correct the cell color turns yellow and is added up at the bottom.

What my macro does not do is change the cell color to red if C2 - AI2 does not match B2 or AI17. Also if AI2 - AI17 is not entered correctly the cell color should change. Here is the macro. Also a file is attached with the macros. When the changes are made to the macro it should find mistakes in the attached file, some of the cells that are wrong are C2, D2, C3, D3, C15 there are others that are wrong.


Sub Update()
Dim Rng1 As Range
Dim Rng2 As Range
Dim bMatch As Boolean
Dim origRng As Range
Dim compRng As Range

On Error Resume Next

Set origRng = Range("B2:B17")
If origRng Is Nothing Then Exit Sub

For Each Rng1 In origRng
'Check contents of Rng1
If Rng1.Text = "" Then
'Rng1 is blank, skip this row
Range("B" & Rng1.Row & ":AI" & Rng1.Row).Interior.ColorIndex = 0
'Rng1 is not blank, run match code
Set compRng = Range("C" & Rng1.Row & ":AI" & Rng1.Row)
bMatch = False
For Each Rng2 In compRng
If InStr(UCase(Rng2), UCase(Rng1)) = 1 And Rng2 > "" Then
... Read more

A:Highlight cells if they don't match one of two cells (macro)

Any ideas?

Read other 3 answers


I want to be able to highlight all my cells in the row that is complete,

I know how to do conditional formating, but this is for just one cell?

What I want is to have all entries along the row highlighted green when all the entires have been entered in, other than that it will remain with no highlight,

is this clear enough????

A:Automatically highlight cells

Read other 7 answers

Hello! I am new to Macros and have absolutely zero experience in Visual Basic. I am trying to record a Macro that will loop through an Excel 2007 document and highlight all empty cells. I found this online....

Sub HighlightEmptyCells()
' Select cell A2, *first line of data*.
' Set Do loop to stop when an empty cell is reached.
Do Until IsEmpty(ActiveCell)
' Insert your code here.
' Step down 1 row from present location.
ActiveCell.Offset(1, 0).Select
End Sub

But do not know what code will highlight the empty cells. Or, if this code will loop through the entire spreadsheet. Any suggestions?


A:Macro to Highlight Empty Cells

you could just use conditional formatting across the spreadsheet
In Cell A1
Format Cell
Conditional Format
change to formula is
The change the format ot a fill pattern or what ever you want for true
and then copy
paste special
and copy to all the active cells you want to test
for the macro this should work


ActiveCell.Interior.ColorIndex = 36

- theres 56 preset colours

Read other 1 answers

I have attached a sheet in which if I click the 'click here to schedule a surgery' button ....a userform will open....If I enter the details in the userform then it will be automatically saved under specific columns in the excel sheet....what I need is

If I choose 'surgery code' from the drop down then the scheduled cells should be highlighted with a colour........(If I schedule a surgery from 7 to 10 in OR 1 and if I choose the surgery code as '1' then cells from 7 to 10 under OR1 should be highlighted with yellow colour......similarly If I choose surgery code as '2' then it should be highlighted with green......similarly If I choose surgery code as '3' then it should be highlighted with blue...)
Thank you

A:Solved: how to highlight cells using a colour.....using VBA

The easiest way to achive that is to store the "Surgury Code Selection" on the Sheet where you currently "Merge the Cells" and use Conditional Formatting to change the Colour.

Read other 3 answers

Hi there,

may somebdoy please advise (I am pure newbie at Macros):
*I want to create button (I can dot that) and assign Macro to it:
*Copy selected cells (C3:N3)
*Paste values against respective product code (product code can be changed manually in A2)

It happens in the same working sheet (or not a problem if haapens in another sheet)

Many thanks in advance (this would save me some time and efforet)


A:Solved: Copy selected cells to chosen cells in Excel with Macro

Read other 14 answers


I am wondering if there is a simple macro that would allow me to format cells throughout a workbook based on whether they contain an input (ie number/text etc) vs. a calculation (anything with a formula).

Basically I'm looking for an automated way to colour my inputs in blue font and calculations in blank font across all worksheets in a workbook.

Any ideas would be great.


A:Excel macro to format input cells vs calculation cells

I wanted to point out that this can be done without using a macro. In Excel you can click EDIT >> GOTO >> SPECIAL and put a check in the option labeled "Formulas." After clicking OK all your formula cells should be automatically selected on the sheet. Once all cells have been selected you can change the font, background color, etc. for all the selected cells at once. If you prefer to use a macro instead you can try the code I provided below.

Sub FindFormulas()

For Each vcell In ActiveSheet.UsedRange

If vcell.HasFormula = False Then

vcell.Font.ColorIndex = 5


'Replace with your code to execute if cell contains formula

End If

Next vcell

End Sub


Read other 1 answers

Hello. I am terrible with Excel and trying to learn how to use it. I created this chart with various functions but I cannot figure out how to get rid of tick type marks that go along 2 columns that I have. They appear in the upper left of each cell going down the column. Any help appreciated. Thanks

A:Solved: Tick marks in Excel on columns

Read other 6 answers

I have a file with a worksheet containing an Excel Table, in which data will be pasted into, say, columns A thru W. Columns X thru Z contain formulae.

I want to be able to protect these formula columns, so they are locked, yet will still expand (autofill) when new data is pasted into columns A - W.

I have successfully done this in one Excel file, but now I come to do it again, I find that the data will not paste in if the worksheet is protected. It looks like it's trying to paste in, as the paste range gets highlighted, but no data is visible.
If I do the same thing with the sheet unprotected, the data pastes in no probs, and the formulae autofills.

I can't for the life of me work out how I did it last time around, and all advice I can find on the internet says it's not possible, yet it clearly is cos I've done it once.

In both instances (the working file and the new non-working file), I first unlocked all cells, then locked cells W1:Z2 (formula column titles and first line of formulae), and then protected the worksheet.

I guess I must have done something else with the original file, but I don't know what....

Any ideas?

A:Excel 2007 - locking cells in an Excel Table

Read other 6 answers

Hi All

I want to change the color of a cell when it is highlighted or selected. i don't want to change the background color of the cell. does any one know how to do this? I've searched the menu's and have cum up stumped. Maybe there is a rule i could insert in to the page.

Thanks Chris

A:Excel highlight color

Read other 7 answers

Hey guys and gals,

Here's what I'm trying to do: I have an Excel spread sheet with 3 columns and many rows depending on the data. I need to be able to search the data in column C for about 10 or so words and highlight them. The problem is, the words in column C have been exported by a program so each word ends with a comma then the next word begins with no space so it's difficult to search. Example, Text1,Text2,Text3 and so on. Is there a macro or software that I can use that will search all the rows for column C and highlight the group of words I choose? I'm using Excel 2007.

Thanks for your help!

A:Excel Macro to highlight words?

Read other 7 answers

Is there a way to automatically highlight subtotal rows? Without going through each one?

Using excel 2010.


A:Excel Subtotals Highlight Automatically?

As far as I know not directly

And there is no need to shout

I haven't come across this myself.
Did you inster the subtotal formula yourself?
If so, you could use Conditional formatting to check if the cell is a formula for the subtotals

Read other 1 answers

I am trying to create a code that will highlight an entire row the day before the date entered into a cell on that row.

A:Excel/Highlight Row Based on Date

use conditional format
add a formula

=cell with the date = today()+1
that will be true if the date

just to make sure we understand

today() is 7th August
the date in the cell is 8th august
so you want it highlighted

so cell = 8th
today + 1 = 8th
it highlights

now to highlight the row
use a $ on the cell that has the date and apply to the whole row

so if the date is in column C and say row 5

$C5 = today()+1

in the conditional format formula and apply to
or whatever column you need

a sample spreadsheet would be useful , you can attach here

Read other 1 answers

Unknown loud tick tock noiseI can send you a video of the noise

A:Tick tick internal noises

G'day Macarius, and Welcome to BC.
A stray wire being touched by a fan blade ?
Something caught in the fan under the graphics card ?

Read other 18 answers

Hi all
I was trying to install and new SATA card to my folks HP XW4600. Everthing fine then...the computer powered off!

I turned it back on and all that happens is the fans spin a little, a crackle is heard from the speaker and a ticking sound (every ~4 secs) comes from the PSU. This continues untill I unplug the desktop.

I've unplugged the fans from the PSU - no change. Unplugged the hard drives/dvd from PSU - no change.

Only after unplugging the motherboard do I get a change; the DVD and hard drive are making the noises expected as the system boots and it sounds fine - obviously, as soon as I plug the motherboard back into the PSU - it dies!

What I'd like to know is:

1) is it the PSU? - I don't think so, must be the motherboard. If so..
2) can I just buy a motherboard for a HP xw4600, replace it and see if that's the culprit? If so, I've never replaced a motherboard before. Are there obvious problems I should be aware of?
3) Is it something else?

thanks everyone, as always, any advice is good advice



A:Turn pc on, tick...tick..tick from PSU? what to do?

I dealt with a "ticking" PSU only last week on my son's PC. It co-incided with the PSU's fan playing stop-go, although the actual ticking came from the circuitry behind the fan. A visit to a PC parts shop and an hour later his PC was fine -- new PSU. I took the opportunity to fit a slightly more powerful PSU than the faulty one too.

Read other 2 answers

This may be an easy one; I searched but couldn't find it.

I have a project name sheet1 in a workbook with a column of hyperlinks to the right of each project. When clicked, it highlights the cell in sheet 2 with the notes for that project.
I would like to make all the text on the notes sheet white, and when a cell is highlighted, have the font be a different color only then.
In other words, I need a way to make the highlighted (linked) cell stand-out from the page.
Sorry if this is really simple; I just can't figure out how to do it.
Thanks in advance.

A:Excel Text Cell Highlight Question

Read other 16 answers

I have 2 worksheets. the main worksheet that I want to have the conditional formatting on has a connection to an Access database. I want to take this worksheet and have it compare to another worksheet in the same workbook. I am comparing cell to cell. Example - D5 on each page. But I have many cells to compare. I would like to have the highlights happen on the connected worksheet, but I am not sure if that is possible. There are 13 columns and 880 rows to conditional format

I have created a 3rd worksheet that uses =ISNA(MATCH(Summary!E5,'Last Summary'!E5,0)) to get some true false results. but I still cannot seem to get it incorporate into the main connected worksheet.

Read other answers

I'd like to set up a macro, whereby I can enter two lists of chassis numbers and compare them, so it will identify all of the numbers in list A that do not appear in list B, and all of the numbers in list B that do not appear in list A.

So, my lists may look like:
List A - List B
A123 - A123
A124 - A124
A125 - A126
A126 - A127
B555 - B555
B557 - B556
B558 - B559

So, I need to highlight A125 in List A and B556 in List B.
List A - List B
A123 - A123
A124 - A124
A125 - A126
A126 - A127
B555 - B555
B557 - B556
B558 - B559

Is there a simple way to do this?

I've been messing around trying to find a way to do this quickly - I tried colouring each list in a different colour and then using the "Unique Records" filter, but it didn't seem to work correctly.


A:Excel - compare 2 lists & highlight differences

"Conditional Formatting"

This will do exactly what you want.

Hope that helps,


Read other 3 answers

This is a reopening of another thread. I still have not found any answers that help. And we won't discuss the lack of support from MS.

I am running Windows XP, Excel 2007.

I have noticed the problem with extremely light shading in xp-excel. It makes things especially difficult when selecting multiple, remote cells or text using the 'ctrl' function, as you cannot see which section has been highlighted or not (note, many people do not understand the nature of the problem as when selecting one cell/group of cells there is a box around the selection, making it easier to visualise, however in selecting many cells, there are no boxes to assist).

I work with spreadsheets constantly and need to highlight for deleting purposes and this is giving me headaches, etc.

Thank you.

A:Solved: Excel Selection highlight color

Read other 16 answers

In range A2:A11 I have a range of numbers .
What I want is for a CF or code that would find the highest number in that range and hightlight it in say green and also the full row that contains this highest number.

Have tried this CF formula , based on a google search

Result is only cell in column A is highlighted (say A6) and not the whole of row 6.

Any suggestions welcome


A:Solved: Highlight whole row depending on 1 cell ,excel 2003

Read other 7 answers


As per the title I want to compare the data between two excel files not work sheets in the same file (if that males a difference).

So I want to compare the old data with the new data and highlight the differences in red or any color on the new sheet.


A:Compare data in two excel WORKBOOKS and highlight difference

Read other 12 answers

I want to Highlight Multiple Values with an Excel Macro. I want the macro to loop though and grab the list/range of values from another sheet and use it in the Array.

I want to avoid having to enter such a big list of values for the Array. I want to use something like "SearchVal() = Range("Lists!A2:A62").Value" but I get an "out of range" error. Here is my code now.

Sub Highlight()
Dim SearchVal() As Variant
SearchVal() = Array("ALM", "AXV", "AZZ", "BCT", "BHN", "CRE", "CSI", "CVM", "DCH", "DEK", "DER", "ESE", "GCV", "HCO", "HND", "HSI",
"IBO", "ILW", "KCM", "LEO", "LES", "LPA", "MCY", "MEX", "MHS", "MRM", "MSL", "NCL", "NTX", "NZI", "PHC", "PLA", "PPH", "PSE", "PUV",
"PVN", "PWL", "RKC", "RSN", "SCM", "SEL", "SGA", "SHC", "SRG", "SVL", "SYV", "TGC", "THA", "TSL", "VAV", "VID", "VTA", "WHE", "WHH",
"WIH", "WWJ&qu... Read more

A:Solved: Highlight Multiple Values with an Excel Macro

Read other 8 answers

This is probably a very simple macro but programming isn't my strong point.
I need an Excel Macro that will be able to scan the first column of a worksheet row by row for certain document numbers i.e. "09-005", "09-1052", "586463" and highlight them. There is a substantial list of these.
I managed to figure out that I need a range and how to highlight, but am getting stuck on how to find the multiple document number values.
Any and all help is greatly appreciated
Thanks in advance

A:Solved: Highlight Multiple Values Excel Macro?

Read other 8 answers

What can I use (formula, etc) to check if a cell has a fill color or not? I have thousands of records with some with a yellow fill color. I need to move those that are filled to another sheet.

A:Solved: Excel: Formula to check cell color highlight?

Read other 8 answers

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 1:53:17 AM, on 1/26/2008
Platform: Windows Vista (WinNT 6.00.1904)
MSIE: Internet Explorer v7.00 (7.00.6000.16575)
Boot mode: Normal

Running processes:
C:\Program Files\Windows Defender\MSASCui.exe
C:\Program Files\Synaptics\SynTP\SynTPStart.exe
C:\Program Files\Java\jre1.6.0_03\bin\jusched.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\ESET\ESET NOD32 Antivirus\egui.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\Mozilla Firefox\firefox.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Page = http://go.microsoft.com/fwlink/?LinkId=54896
R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://go.microsoft.com/fwlink/?LinkId=69157
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://go.microsoft.com/fwlink/?LinkId=69157
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Search_URL = http://go.microsoft.com/fwlink/?LinkId=54896
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Search Page = http://go.microsoft.com/fwlink/?LinkId=54896
R0 - HKLM\Software\Microsoft\Internet Explorer\Main,Start Page = http://go.microsoft.com/fwlink/?LinkId=69157
R0 - HKLM\Software\Micr... Read more

A:[AmenNew] "C:\ProgramData\face tick tick.0uet2wm"

Please Download NoLop to your desktop from one of the links below...
Link 1
Link 2
Link 3
[*]First close any other programs you have running as this will require a reboot
[*]Double click NoLop.exe to run it
[*]Now click the button labelled "Search and Destroy"
<<your computer will now be scanned for infected files>>
[*] When scanning is finished you will be prompted to reboot only if infected, Click OK
[*] Now click the "REBOOT" Button.
[*] A Message should popup from NoLop. If not, double click the program again and it will finish Please Post the contents of C:\NoLop.log along with a fresh HijackThis log
--If you receive an error, "mscomctl.ocx or one of its dependencies are not correctly registered," please download mscomctl.ocx to your system32 folder then rerun the program.


Download SDFix and save it to your Desktop.

Double click SDFix.exe and it will extract the files to %systemdrive%
(Drive that contains the Windows Directory, typically C:\SDFix)

Please then reboot your computer in Safe Mode by doing the following :
Restart your computer
After hearing your computer beep once during startup, but before the Windows icon appears, tap the F8 key continually;
Instead of Windows loading as normal, the Advanced Options Menu should appear;
Select the first option, to run Windows in Safe Mode, then press Enter.
Choose your usual account.

Open the ex... Read more

Read other 1 answers


I need some help with this one. I am merging cells in an xls spreadsheet which contain simple strings: for example:

1 Smith Bill
2 Larry Jones
3 Hotel Bar The
4 Jones David

should be:

1 Bill Smith
2 Larry Jones
3 The Hotel Bar
4 David Jones

I used the formula B1 =(D1&C1) then did a fill and any cell that needed the prefix added to the cell had it done. Problem is, I need the string values of column B. When I attempt to copy this column to another file I cannot transfer the text.

How do I keep the text info and erase the functional basis of each cell?

Many thanks for any help,


A:Excel - merging cells

malcolmd3111 said:

How do I keep the text info and erase the functional basis of each cell?Click to expand...

1. Select the formulas

2. Copy

3. Edit > Paste Special > Paste Values > OK.

Read other 3 answers

Hey, i have a friend who owns a Resturant and i he wanted to do a roster by getting one cell, putting a diagonal line from right to left and putting text on both sides of the line in the single cell... i have seen this done but i dont know how to do it myself... thankyou

A:Splitting Cells in Excel

Read other 16 answers

I have a recurring problem when using Microsoft Excel. When I click on one cell in the worksheet in automatically selects the one or two cells next to it. No matter where I click I will not allow me to select one singe cell. This makes it twice as difficult to use formulas because it selects extra cells when doing so.

Anyone have any ideas as to what is causing the multiple selection?

All ideas welcome!

A:Multiple Cells in Excel

Read other 12 answers

on a worksheet in cell E1 is a name copied from another worksheet in the workbook and in cell E22 is a calculated figure based on entries made in other cells, what i would like to happen is when the figure in cell E22 reaches a certain figure i.e. 50, cells k19-q19 change colour, i would prefer to use vba code, any idea's

A:Solved: excel cells

Try This....

Private Sub Worksheet_Change(ByVal Target As Range)

Dim wsk As Worksheet

Set wsk = Sheets("Sheet1") 'Change this to whatever your sheet is named

If Target.Address = "$E$22" Then

wsk.Range("K19:Q19").FormatConditions.Add Type:=xlExpression, _

wsk.Range("K19:Q19").FormatConditions(1).Interior.Color = 255 'Color is Red

End If

End Sub

Read other 3 answers

I wish to set up a spreadsheet on a shared documents area of a network. The spreadsheet needs to have preset cells with fixed content and the rest open to edit until such time as a value is entered. These cells must then automatically lock. I, as administrator, would be able to unlock, edit and delete the cell value.
Any ideas?

A:Excel - Locking cells

in excell when saving click tools wihch is in the top right of the dialog box then select the security option

Read other 2 answers

I hope someone can help. This is driving me nuts.

I want to select and copy groups of cells and paste them into something else (final destination actually a page of a blog). I want to take the gridlines and the general appearnce with it.

I am highlighting, either Ctr + C, followed by Ctr + V, or via the edit dropdown.

ONCE it came out right, all other times I just get cell contents.

Please help!!!!

A:Copying cells FROM Excel

Read other 10 answers

Using excel, I am trying to format certain cells that have formulas attached to them - this way I cannot accidentally delete a formula by typing in the cell.

I do NOT want to lock the entire document, as I need access to the other cells (i.e. to type in the data). There must be a way to lock the formula of just one individual cell .... ANY IDEAS?!?

A:EXCEL HELP! - Locking Cells

Hi hoosieriu,

You in essence have to think of this the other way around.

By default all cells are already locked, but this has no affect until the s/s is protected.

So what you have to do is unlock the cells where input is allowed , then protect the spreadsheet.

1. Format / Cells / Protection Untick 'Locked'
[Click on the intersection at the very top left of row and column to selct ALL cells if it would be quicker to unlock all first then lock specific cells afterwards]

2. Tools / Protection Protect Sheet



Read other 1 answers

I have a price list that is done in Excel and some of the items need to have the text wrapped because the description is longer then the row allows to print out on 8.5 x 11 paper. The problem is whenever I add a new title (they are alphabetical) and insert a row, it messes up the formatting of any of the items below the inserted row by hiding the wrapped text of items w/longer descriptions. The line description of a wrapped text item doesn't show - only what wraps onto the second line is visible - and I then have to go down the list and resize all the items that require more room. I have already set the rows to 'wrap text' under formatting for the whole page. How can I get this file to automatically allow the row height to adjust for the wrapped text when needed as well as larger font sizing? All the row heights that have larger font sizing in them will also 'squish' down to only show 1/2 of the text so that the top portion of the letters are cut off. I dread editing this file because I have to do a major overhaul on all the row heights whenever I insert any new rows for new items! HELP!


A:Formatting cells in Excel

Read other 12 answers

Hello all,
Well I'm rather new to Microsoft Excel and we have just opened up a storage facility at work which is now up and running.

I have a spreadsheet laid out with the product (A1), then chargable amount(B1), the charge per week (C1) then the total per week (D1) but how can I get B1 + C1 to mutiply with the total being displayed in D1?

Also im not sure if this is correct but I need to somehow lock this formular to just row 1 so I can continue the process onto row 2 with a seperate formular so therfor if stock is taken or received it will calculate a different total.

Then say at the end of the month I can work out a formular going down the D collum for a total of the storage?

Your help would be much appreciated! I'm not sure if im coming accross this way but im a very desperate man right now!!

Many Thanks


A:Multiplying cells in excel????

in D1 type =b1*c1
use the summation button (it looks like an m on it's side) in the cell at the bottom of your values in column D
or you can type in =sum( and then highlight the values in column D and then close the brackets with ) and it will do the same thing.

Read other 3 answers

Hi there, 
Is there a function or macro I can use that I can quickly (i.e. without having to type in formulas (not my forte!) calculate multiplication of multiple cells.  See below image, e.g. 19 x 0.50 = [to insert into the blank cell as shown] ...and so on...

At the moment I am doing each row manually and it's driving me nuts.  Need a quicker way - I am not keen on formulas - to me it seems to take just as long and I always manage to eff it up somehow so a recommendation for an existing function key or clickable
option would be great - or a macro e.g. so I can just set this up and click it once each time I want the selected cells multiplied.   Is this possible? 

Thanks in advance, 

Read other answers

Has anyone figured out a SIMPLE way to swap data cells?? IE: H3 and G4, or C6 and D8 - just take the data in one, put it in the other, while the other's data is put in the first???

A:swapping Excel cells

Read other 9 answers

i want to create a worksheet, lets call "inventory"

on that sheet will be

item, qty

i will have another sheet called "changes"

on that sheet will be

date, item, change
qty on inventory = sum of change on changes where item(changes) = item(inventory).

any help would be awesome.

A:Excel: how to: sum of like quantities in cells

Read other 6 answers

I think that this is a very simple problem but I can't find the solution.

Is there a command or function in excel that will allow me to take 48 cells (columns) of data & place it in a 6 X 8 table?


A:Arranging cells in excel

Dont know if this is gonna help, but you can make the cells in a row to appear as the cells in a column by doing a 'Paste Special' and selecting 'Transpose' in the dialog coming up.

Read other 3 answers

I designed a Visual Basic form from within excel to input currency values onto a spreadsheet. The cells on the spreadsheet have been formatted to 'currency', but when I type in a value on the form thats only a number (without the dollar sign) it only inputs a number on the spreadsheet even though the spreadsheet cell is formatted for currency. Why does this happen?, is there a way to make the VB form input boxes automatically convert a normal number to currency?

Read other answers


It's been a while since last I used Excel and the problem is that I forgot how to make lines. What I mean is I remember that when I click at an edge of a cell then comes a line, so you can create columns, boxes or whatever! Normally I don't want to make a line around the whole cell, in that case I know how to do it(right click on the cell/ format cells/ border).

I want to make only a single line where I click with left button. For example if I click at the bottom of the cell it comes a line only there and the same story if I click only on the right, left and on top of the cell.

It's been already two days trying to make these lines but I really can't. So my question, is there any help?

Thanks in advance,

A:Excel - Cells & Lines

Read other 16 answers

How can I add the cells within a worksheet, not the contents of the cells, the number of cells into another cell within that same file.

A:adding excel cells

Read other 7 answers

I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks

A:Excel un password cells

Open Excel. Go to the help function (?), and type in password. You will get a lot of information.

I don't know how easy it is to completely remove password protection if you were not the person that developed the worksheet.

Read other 9 answers

Hi all
I need to number a large amount of cells. is there anyway you can highlight 200 cells in a collum and then automatically number them from 1 to 200 in one go.
Thanks in advance for the help.

A:Numbering cells in excel

Read other 6 answers

I have a lot of cells like this:

<img src="whatever">
<td class="odd">data here</td>
<td class="even">different data here</td>
Cells can also just have the img src, just one td class, or 3+ td class parts.

I am trying to find a way in Excel to split up each td class into its own cell. So like the above would end up as:
One new cell would be:

data here
Another new cell would be:

different data here
Any ideas? I think I have to use vbScript?

Read other answers