Over 1 million tech questions and answers.

highlight dynamic cells when they tick in excel

Q: highlight dynamic cells when they tick in excel

Hello,
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.

regards,

RELEVANCY SCORE 200
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
RELEVANCY SCORE 87.6

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
RELEVANCY SCORE 87.6

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
RELEVANCY SCORE 77.6

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.

Code:

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
Else
'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
RELEVANCY SCORE 69.2

Hi,

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
RELEVANCY SCORE 68.4

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*.
Range("A2").Select
' 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
Loop
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?

Thanks!
 

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
enter
=A1=""
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

Code:

ActiveCell.Interior.ColorIndex = 36

- theres 56 preset colours
 

Read other 1 answers
RELEVANCY SCORE 68.4

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
Bharath
 

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
RELEVANCY SCORE 66.4

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)

SM
 

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

Read other 14 answers
RELEVANCY SCORE 66

Hi

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.

Thanks
 

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.

Code:
Sub FindFormulas()

For Each vcell In ActiveSheet.UsedRange

If vcell.HasFormula = False Then

vcell.Font.ColorIndex = 5

Else

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'Replace with your code to execute if cell contains formula
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

End If

Next vcell

End Sub

Regards,
Rollin
 

Read other 1 answers
RELEVANCY SCORE 59.6

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
RELEVANCY SCORE 58

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
RELEVANCY SCORE 56.4

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
RELEVANCY SCORE 56

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

then
$C5 = today()+1

in the conditional format formula and apply to
$A$5:$Z$5
or whatever column you need

a sample spreadsheet would be useful , you can attach here
 

Read other 1 answers
RELEVANCY SCORE 56

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

Using excel 2010.

Thanks
Carla
 

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
RELEVANCY SCORE 56

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
RELEVANCY SCORE 56

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
RELEVANCY SCORE 55.6

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

Cheers

Mark
 

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
RELEVANCY SCORE 55.2

Hallo,
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.

Ta
Gram
 

A:Excel - compare 2 lists & highlight differences

"Conditional Formatting"

This will do exactly what you want.

Hope that helps,

Drew
 

Read other 3 answers
RELEVANCY SCORE 55.2

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
RELEVANCY SCORE 55.2

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
RELEVANCY SCORE 55.2

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
RELEVANCY SCORE 54.8

Hello,

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.

Thanks!
 

A:Compare data in two excel WORKBOOKS and highlight difference

Read other 12 answers
RELEVANCY SCORE 54.8

Hi,
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
RELEVANCY SCORE 54.8

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
=A1=MAX($A1:$A11)

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

Any suggestions welcome

Pedro
 

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

Read other 7 answers
RELEVANCY SCORE 54.8

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
RELEVANCY SCORE 54

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
RELEVANCY SCORE 54

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:\Windows\system32\taskeng.exe
C:\Windows\system32\Dwm.exe
C:\Windows\Explorer.EXE
C:\Program Files\Windows Defender\MSASCui.exe
C:\Windows\System32\rundll32.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
C:\Users\Pat\Desktop\HiJackThis.exe
C:\Windows\system32\NOTEPAD.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
RELEVANCY SCORE 53.2

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
RELEVANCY SCORE 53.2

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
RELEVANCY SCORE 53.2

I've created a row of calculated values based upon variables (some of which might be 0). The resulting row of calculated values will sometimes display #DIV/0. So, I used conditional formula, =IF(A2=0,"",A4) ... to properly display results, with blank cells in place of the #DIV/0. Now I'd like to graph the results. When I do, I get a 0 value in place of the blank cell (which has resulted from the conditional IF function). When I do a =ISBLANK on the blank cell, the answer is .F. When I do a =ISTEXT on the blank cell, the answer is .T. Does anyone have any ideas on how to create a formula which will eliminate the #DIV/0 with a truly blank cell, so that the graphical representation won't represent that data point?

Many thanks.
Jack
 

A:Excel? Blank Cells

>> =IF(A2=0,"",A4)

=IF(A2=0,#N/A,A4)

instead should suppress the 0 values in the chart. If you then don't want the #N/As to show on the sheet, use conditional formatting (e.g. Formula is =A2=0, with a white font Format).

HTH,
Andy
 

Read other 1 answers
RELEVANCY SCORE 53.2

Hi, Using Excel I would like to create a macro:
I have several rows of products, I enter a qty next to some of them but not all,
would like to have a macro that filters and reduces my list to the rows that have a qty only.
Please help with macro code. Thanks Frosty
 

A:Excel Filter Cells

Read other 11 answers
RELEVANCY SCORE 53.2

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?

ron40
 

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
RELEVANCY SCORE 53.2

I have a lot of cells like this:

Code:
<img src="whatever">
<table><tr>
<td class="odd">data here</td>
</tr>
<tr>
<td class="even">different data here</td>
</tr>
</table>
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:

Code:
data here
Another new cell would be:

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

Read other answers
RELEVANCY SCORE 53.2

Hi
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
RELEVANCY SCORE 53.2

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!

THANX!!
 

A:Formatting cells in Excel

Read other 12 answers
RELEVANCY SCORE 53.2

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
RELEVANCY SCORE 53.2

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

hth

Hew
 

Read other 1 answers
RELEVANCY SCORE 53.2

Hi,

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,
miniman
 

A:Excel - Cells & Lines

Read other 16 answers
RELEVANCY SCORE 53.2

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
RELEVANCY SCORE 53.2

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

Scott
 

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
RELEVANCY SCORE 53.2

Hi,

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

A B C D
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,

Malcolm
 

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
RELEVANCY SCORE 53.2

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
RELEVANCY SCORE 53.2

Hi,

I'm trying to create a macro or some kind of script to merge two cell's information into 1.

this is how it looks like:

Row A have first name
Row B have last name
Row C will merge first and last name together.

Row A is the first name and row B is the last name. It's easy using micro; however, the problem is that the report generate randomly everyday and sometimes it will have more entries and some day it will have less entries. is there a way to merge the first and last name together in a new cell with both names. It will need to be able to merge any extra rows that pop up everyday.
 

A:Excel - Merging Cells and more

Sounds strange. Are you sure you don't mean that first names are in column 1, last names are in column 2 and you want them merged in column 3?

That would be (assuming no blank rows):

Sub test()
LastRow = Range("A" & Rows.Count).End(xlUp).Row
Range("C1:C" & LastRow).FormulaR1C1 = "=RC[-2]&"" ""&RC[-1]"
Columns(3).Value = Columns(3).Value
End Sub
 

Read other 2 answers
RELEVANCY SCORE 53.2

IT's been a while since I used excel.

How can I select a group of cells and make them float above the others, so that I can move them around the screen at will?

I don't want to freeze cells, I need them to float

Thanks
 

A:Floating Cells (Excel)

Read other 8 answers
RELEVANCY SCORE 53.2

I have a remote user who is quite Excel savvy. She has used an existing workbook as a template for a new one and when she tried to alter a named cell she ran into problems. I talked her through the process of deleting the old cell name and adding a new one but a formula that referenced the named cell failed to work. I suggested she save and close the workbook and reopen it. This seems to have done the trick but she'd like to know if there's an easier way to do this for future reference. Is it simply that this process has to be followed if a sheet or book with a named cell is to be altered in this way?

Thanks in advance for any help you give.

N03L.
 

A:Naming cells in Excel

Some names are used in multiple worksheets, which is just plain bad form. Might what to choose that Show Dependents before renaming named ranges too.

Why delete the old name? Why not just add the new one? A cell can have two names.
 

Read other 1 answers
RELEVANCY SCORE 53.2

The following question was asked but left unresolved on this site in 2003. It's been 9yrs and I'm hoping Excel has progressed enough to enable an answer.

I want to have a defined group of cells floating beside data on a worksheet. Is this possible?

Thanks for your help
 

A:Floating Cells in Excel

Hi, welcome to the forum (after 9 years? )
I doubt there exists any function you are asking for.
I am not sure what you really want to see but with some vba code (macro) and a user form something could be written that would allow for a 'floating' userform but you will need to trigger if for a particular area of the sheet or a right-click function.

I have no idea but sounds like a nice challenge
 

Read other 1 answers