Over 1 million tech questions and answers.

Solved: Excel 2010 unable highlight mutliple words & toolbar problems

Q: Solved: Excel 2010 unable highlight mutliple words & toolbar problems

Hi,
I know this is probably an easy question, but I've searched repeatedly on the web and I can't find advice there or in the forums because I'm missing some kind of terminology.

I want to be able to highlight multiple words in Excel and see the home toolbar open every time I open a spreadsheet.
Longer explanation:
I'm using Microsoft Vista 2007 with Excel 2010. I use Excel to make quite a few spread sheets to study for school, and I often have to selectively highlight multiple certain words by hitting ctrl and holding ctrl while highlighting the words. Next I would underline all of the highlighted words. About a month ago it was working fine.
Suddenly out of the blue whenever I try to highlight multiple words by holding ctrl in Excel it won't work. Also, previously when working in excel 2010 the top menu bar would stay on home toolbar with all the option listed, meaning I could keep tinkering with the font uninterrupted. Now after underling just one word at a time the toolbar keeps disappearing with the File tab highlighted green, and I have to keep clicking back to the home tab, then click underline. Have to repeat highlighting each individual word,, clicking home tab, and then underlining. Ugh!
I would love to hear some advice before I tear my hair out in frustration.

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel 2010 unable highlight mutliple words & toolbar problems

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: Solved: Excel 2010 unable highlight mutliple words & toolbar problems

Read other 6 answers
RELEVANCY SCORE 88.4

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 71.2

Greetings,

We have several computers all running the same versions of Office 2010 here, and it seems there was an update of Windows 7 this week that mucked something up, and while I stretched my GoogleFu as much as possible, I can't find any pointers. So last resort, gotta ask people directly.

Two things happened after the patch (maybe more, but this is the most visible).

-The view panes resets itself to a default setting that I can't even explain. I usually use a 'right' reading pane and close up the calendar on the right side, but it doesn't save, it returns to a 'email list' only pane and expands the calendar.
-The search function seems much slower, it used to show results immediately as I type something, but now it REQUIRES that I push enter, and it does not highlight the options. Everything is checked in my search options, and it was working before the patch, it simply stopped.

My Googling produced these results, which I have attempted already :
-Tried checking off and back on the search options, no dice. Even closing Outlook in between.
-Tried running as Administrator and Safe Mode, no changes.
-Turned off and back on Windows Search in the features.
-Turned on Windows Indexing in the features.
-Used the Windows Index Option to rebuild Index (Outlook was checked in the list of programs, but I tried removing and reenabling it for good measure).
-The Indexing option in Outlook itself is grayed out, so I couldn't use that, I even tried to search how enabl... Read more

A:Outlook 2010 Search Highlight and Views problems

And of course as soon as I post this and talk about my googlefu I see this other thread like 4 posts below :
After yesterdays updates, Outlook has mind of it own

Let's try it, keep you posted.

Read other 2 answers
RELEVANCY SCORE 70.4

I have a user try to print from his words and excel file, every time he print document the paper comes out blank. I have try to re-installed the MS200 and also deleted user profile from AD and is still not work. Any one with help over there pls
 

Read other answers
RELEVANCY SCORE 68.8

Hi. All of the sudden my PC is unable to open excel or word files received via email. Message says that I do not have sufficient available memory or disk space which is not correct. Please see pic of message in attached. PDF. Thank you.
 

A:Unable to open excel or words file that I receive via email.

It looks like it might be related to the problems we thought we had fixed before
https://forums.techguy.org/threads/my-lap-top-says-i-have-no-space-left.1213489/#post-9524235

run FRST again & lets see what shows this time, Make sure you check the addition txt in the extra files section
post both new logs back here

If there is space then it is likely that the message is slightly wrong.
Do you save the files first or try to open directly from the email
Try saving them to downloads folder first, rather than trying to open directly form the email
 

Read other 8 answers
RELEVANCY SCORE 68.4

Hi,

I have a text file of commonly misspelled words and phrases. I would like to write a macro in Microsoft Word 2007 which goes through the text file and highlights any words from the file which appear in the current Word doc. I would also like to specify the colour of the highlight.

I have written/recorded macros for Excel, but I don't know much about Word VBA. Is this possible, and would someone be able to help start me off with this project?

Thanks!

Sixhobbits

Windows 7 home basic
Office Suite 2007
 

Read other answers
RELEVANCY SCORE 68.4

My x86 win 8.1 desktop continues to highlight misspelled words, wether this option is enabled or disabled in Settings, PC and Devices, Typing or not.

I have checked the relevant registry keys, and both values are 0.

The only cause I can think of is Skydrive Sync my settings across devices..
When I initially added a device, a Surface 2, settings on both machines differed, and then I enabled Sync on both.

It's a small annoyance, but that little red squiggly line is really beginning to bug me o_o

A:Highlight misspelled words will not disable

Hi Gossy, Welcome to EightForums.

My suggestion would be to delete all your sync data to ensure it is not being restored on the machine.

Link: http://www.eightforums.com/tutorials...s-8-1-pcs.html

After you have deleted the sync data try the registry edit again to ensure it is set properly. Restart or logoff to apply the setting.

Link: Spell Checking - Turn On or Off in Windows 8

Read other 2 answers
RELEVANCY SCORE 66

Hi there,

In the attached spreadsheet, I'm trying to sum up the sales of a product line, by a particular sales rep, product and date. I'm getting an answer, that at first glance looks correct, but if I total up the yearly sales using an independent formula, I arrive at a different figure.

I think the problem is stemming from sales on the month-end dates, but I can't work out how to correct it. Any help would be much appreciated.

Note: At first glance the spreadsheet seems to contain confidential data. I'm happy it's not.
 

A:Solved: Excel 2010: Problems with SUMIFS and dates

Read other 9 answers
RELEVANCY SCORE 65.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 65.6

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 64.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 64.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 64.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 64.4

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 64

Afternoon everyone!

As the title suggests, I have some issues with formatting the x-axis of a column graph (the graph is to show air consumption rate over a period of 30 minutes) in Excel 2010 (the file in question is attached). As you can see in the attached picture, the graph currently has the x-axis formatted such that it starts in the middle of the ticks. Ideally, I am looking for a way to start "0" from the y-axis intercept without shifting the graph as is currently the case when changing the horizontal axis options.

Could you possibly help me sort this out? I need to present it for a university project and I'd like to have the graph presented in this manner. It would also help if I could learn the method so I can do this in future. Thank you for your help in advance!
 

A:Solved: Problems fixing horizontal axis on column graph in Excel 2010

Read other 6 answers
RELEVANCY SCORE 62.4

Excel Help Request How to remove duplicate words in a row

Example:
Row1:
I am writting to tech support guy tech support for help
Required result: I am writting to tech support guy for help

Row2:
I am sure I will am sure get help
Required result: I am sure I will get help

Row3: .....
Row4: .....

Thanks in advance
 

A:Solved: Excel Help Req: How to remove duplicate words in a row

Read other 16 answers
RELEVANCY SCORE 60.4

Hi,

When I copy a column or a row and insert it, excel inserts it but it vanishes in a split second. When I copy a column and paste it (not insert) it does the job but it is overwritten that I don't want to do.

Help!

Thanks in advance
 

A:Unable copy and paste column or row in Excel 2010

Can you explain more?
Your explanation does not say anything about what and how you'rw doing it
Does it happen with every Excel file (new blank ones) or with one inparticular?
Do you have any special Add-Ins installed?
Have you been testing m,acro's that influence the right-click mouse buttons?
Please try and paint a complete picture so that the reader has information to troubleshoot and help.
 

Read other 3 answers
RELEVANCY SCORE 59.6

Hi
I am trying to use conditional formatting and a FIND formula to be able to highlight a word selected from a drop down list in a a work sheet.

I have created a drop down list of a number of different words (countie names)
I would like to be able to select one of those words at a time and have excel locate and highlight that specific word whithin my worksheet.

To better explain I have created a schedule with county names listed, I need to be able to select a country from my drop down list and see how many times I have that country listed in my schedule. i.e to look for time overlaps or double bookings.
I have seen this done before but cant figure it out.

Can anyone help with this problem??
Im sure its quite simple but cant seem to get it.
 

A:Solved: How to find specific words in a drop down list whithin an excel worksheet.

Read other 12 answers
RELEVANCY SCORE 59.2

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help
 

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers
RELEVANCY SCORE 59.2

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers
RELEVANCY SCORE 59.2

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers
RELEVANCY SCORE 58.8

How to change MS 2010 Highlight color? Currently my highlight color is black i want blue or light blue.

Screen shot.

A:How to change MS 2010 Highlight color?

I wonder if this is what you are looking for:
There is a drop down menu from the 'font' tab on the ribbon - however, this will highlight text in a document.

If you mean the highlight selected text to, say, 'copy' or 'cut' and paste, then it's not necessarily the answer. As you can see from my illustration below, the selected text is highlighted in blue, which was automatically applied.
.
.

Read other 9 answers
RELEVANCY SCORE 57.6

I just added my wife as a second "log on" user on our XP system. The problem is that changes that are made her exployer (mostly on the favorites list) are tranfering over to the other users exployer (mine). Her favorites change when I change my favorites list and visa vera...Is this suppose to happen?
 

A:Mutliple user problems

did you make a user account with her own icon and password ?
 

Read other 2 answers
RELEVANCY SCORE 56.8

Hello.
 
I'm making a new referral form for the company I work for to be used by the council. I'm having problems with the active X boxes in Excel 2010.
 
I work on a remote server but I don't think this would be the issue. On sheet one the boxes work fine and as intended however on sheet two the boxes on the left side are only usable once and while on the right side they work as they're meant to.
 
I have no idea why it's doing this so I thought maybe someone here can help me out. I've tried roaming the web as much as possible but can't find a solution to my problem. I have attached a picture to show which boxes I mean.
 

A:Having problems with ActiveX box's in Excel 2010

No one able to help?
 
I really am stumbed on this and would like to get this form up and running before scrapping it and trying a new one.

Read other 2 answers
RELEVANCY SCORE 56.8

Hi All,

So recently I've been having trouble with numerous Excel Spreadsheets on Excel 2013/2010

Issues have included excel freezing, taking a long time to open multiple (large) spreadsheets, copying and pasting taking 3 minutes or more.

Just to give some background; let me start by stating that the excel sheets in question are large in size with lots of links to external sources. I would also add that these spreadsheets where originally created on 2010 rather than 2013. My computer is also running on a corporate network for which i'am an admin.

However, the spec of the machine i'am using, in my opinion, should be more than capable of running these large sheets:

HP Z240
Xeon CPU 3.30GHz
16GB
250GB SSD
Win 7 Pro

To remedy these problems i have tried numerous troubleshooting including:
Increasing the RAM to 32GB
Turning off protected view via GP
Installing Excel 2010 alongside 2013
Installing 2010 x32
Ensuring all macro's are enabled via GP
Rebuilding the box entirely (software)

None of these have resolved the issues.

I've now found that i have exhausted my knowledge on this issue and so, I'am reaching out to see if any one has any suggestions with how to fix this.

Any help anyone can provide is greatly appreciated!

Read other answers
RELEVANCY SCORE 56.8

Hi there,

My computer has many issues right now. First, when I start up the computer, the computer, the screen is blue and then it goes black and mentions something about windows security center. I googled this and it said this was something with windows sp2 and to open control panel, but control panel is missing on my computer. A window pops-up and says vedxg6ame4.exe has encountered a problem and must close and then another windows comes up saying that c:/winsows/shell.exe is missing. Also something was mentioned about kernel32.dll. I tired to change the background for black to a picture and the computer won't let me. Please help, Norton can't fix this! Thanks
 

A:Help with Mutliple Virus/Spyware Problems

Read other 11 answers
RELEVANCY SCORE 56.8

Hello,

I used Google Toolbar to translate spanish words to french, moving the curser near the word of an internet page, but with windows 8 that doesn't work !

Thank you for your help

A:Google Toolbar with windows 8 to translate words

It's possibly not updated for IE10 yet and of course isn't compatible with other browsers any more and Chrome has it's own version. Keep a shortcut to Google Translate handy.

Read other 3 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.4

I have recently installed Microsoft Office 2010 on a brand new computer running on Windows 7.

When I save a word document the only way you can view it is by saving it in Word document 97-2003.
When saving a spreadsheet in Excel, and you try to open it, it displays as a Adobe document which cannot be opened.

Can someone explain if I have done something wrong, and how do I rectify this problem.

Many Thanks.
 

Read other 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

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 55.6

Morning,

I've been racking my brains about this one lately as we have more users switching over to Windows 7.

I'm convinced it's Excel causing memory problems, but I'm unsure.

When working with excel for a short time, we're unable to switch to any other window on the taskbar. It's as if Excel is taking priority over anything else that is open on the taskbar. For example, if we have Outlook, Internet Explorer & Excel open, when we click out of Excel to go into Outlook, nothing will happen, but it seems as if it's bringing the window up in the backgroud.

We can fix this by closing Excel and starting it up again, but alas, some more usage and it starts again.



Both Windows 7 and Office are right upto date.

Any ideas anyone? Your help is much appreciated.

A:Windows 7 + Excel 2010 causing taskbar problems

Hi,

Mmm, I have been using Outlook2010, Excel2010 and Windows 7 Ultimate x64 for a while now and never encountered this at all.

Are you able to nail it down any better? For example, do you get the same problems if Excel is NOT open? Is there anything in Group Policies that could be controlling this?

Have you tried using TaskManager or Resource monitor to see what is hogging the focus?

Regards,
Golden

Read other 4 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 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 55.2

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

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,
 

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 54.8

Posted this on another forum on this site and didn't get a solution.., come on Bomb#21 etc - don't let me down...

I have attached a screen shot which shows 3 programs running on the task bar at the foot of the screen.

Immediately prior to taking the screen shot, I had clicked on the middle program button which read "5 Microsoft Outlook", as (for the slow of mind) I had my Outlook inbox open and 4 mail messages/attachments open. The 5 Outlook 'files' were then displayed at the foot of the screen and I could click on any one to switch to it.

To the right of the Outlook button I have an Excel button which doesn't tell me how many Excel files I have open (there were actually 3 at that point) and (here's the problem !) doesn't allow me to click on the task bar button and click again on the file I want to switch to.

It's not a major problem, but it is a major source of annoyance.

At the risk of sounding like an ungrateful git, could someone tell me how to sort this once and for all, rather than "try this" or "try that".

A few weeks ago it was definitely do-able and I don't know what I have done to change things. I have tried changing the toolbar properties to group/not group similar files, but can't seem to get the result I want.

OK - rant over. I'm using XP Pro (2002 SP2) and the Excel version is 2000 (9.0).
 

A:Solved: Excel/Task toolbar problem...

Read other 6 answers
RELEVANCY SCORE 54.8

I have an add-in that installed its own menu item on the ribbon bar. From the ribbon there are a bunch of functions that can be inserted as well as toolbars. The functions work fine but I can't see any of the toolbars.
 

A:Solved: Can't see 3rd party toolbar in Excel 2007

Hi sync

Can you give us the name of the add-in and post a link to the third party program you are using?
 

Read other 3 answers
RELEVANCY SCORE 54.8

Hey Tech guys,

I have a document with large data,
collected from various sources, and duplication is there,
I wanted to find these duplicated words, emails, names and delete them,
using windows 7 / MS word 2010,
Kindly help to solve this,
thank you
 

Read other answers
RELEVANCY SCORE 54.8

I just started playing with PowerShell (Wait, let me finish.) and as I find scripts that I think I can use later on I copy them to a Word document and put some explanation of how I understand the script to work. Currently I have one document with about 50 scripts that I have collected so far, so that I can search one document when I am looking for an example.

Before I spend a lot of time trying to write a Word macro, (Which I have never done) or trying to reinvent the wheel, does anyone know if someone has already written a macro to color code the script portion of the Word document? Iím thinking I would select the PowerShell code and then execute this macro that would color code the words, much like TextPad.

Hope someone can help and guide me in the right direction, if I am going to have to write something.
 

A:Color code words in Word 2010

Read other 10 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.4

I've been trying to set up a toolbar button in Excel that when clicked will bring up the Windows Calculator, but I just can't seem to find the way to do it. I know it can be done because I used to have it on my previous installation of Excel (Office Basic 2003 and my current installation is the same version).

Now I know I can just click on the Start Menu while I'm in Excel and then just go to Accessories and Calculator, but this is just a personal preference to have a toolbar button that will do the same thing.

I thought there was a Command Option that would allow me to just type in "calc.exe", but there's not. I tried a hyperlink to "Windows/System 32/calc.exe" and that works for the button (Custom button), but it gives a bunch of warnings before the Windows Calculator comes up. And as I recall, I never got those warnings before (one warns about hyperlinks and the other is similar).

And I looked on all the toolbar choices and I couldn't find any Windows Calculator button. There IS an Excel calculator button(s) to recalculate spreadsheets, but that's NOT what I want - I want the Windows Calculator.

I tried recording a macro and assigning it to the button, but the minute you go out of Excel the macro recorder doesn't record.

I also tried VBA, but I couldn't find any simple code to execute the calc.exe program. I thought maybe there would be a simple "run" statement, but I don't think there is. Actu... Read more

A:Solved: Excel toolbar button for the Windows Calculator

Actually... I'm running Office 2003 Pro and it has the Windows Calculator as a button called "custom". Under Toolbars> Customize> Commands Tab, clicked on Tools in the left window and scrolled about 2/3 of the way down in the right window. I've got two "Custom" buttons listed after "Camera" and before "Select Names"; one with a deck of cards icon and the other with a calulator icon. Drug it up to my tool bar, saved the settings, and the Windows calculator opens from it. Solitare opens with the deck of cards icon

I didn't even know they were there.... cool.
 

Read other 2 answers
RELEVANCY SCORE 54

I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):

(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.

I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.

Nothing has worked. Iím barely able to get anything done! Please help, Iím dying here!
 

A:Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

Read other 16 answers
RELEVANCY SCORE 54

I am working in a spread sheet with the following simple formula =SUM(B2,C2) and the result is in D3
in some instances the result is a negative number and the result is shown as (10) but the number/text colour is black what I want to do is have a formula which changes the colour of the result to red if the result is negative and to remain black if the result is positive, is this possible and if yes how do I do it

Many thanks
Brobilly
 

A:Solved: excel 2010

Hi Brobilly,

Yes it's possible. Have a look at Conditional Formatting. Set the format to red if the value is less than 0 and set the format to black text if the value is greater than 0 (or greater than or equal to 0 if you class 0 as positive).

if you want to have brackets around the number write the formula as ="(" & sum(B2,C2) & ")".
 

Read other 1 answers
RELEVANCY SCORE 54

Hi There,

What I have is a spreadsheet with several sheets. I have created a summary sheet that I want to pull all the active information out if it meets a certain criteria.

I have the formula's put together so that it pulls the info correctly, but I need to know how to format the page so that it auto sizes the number of rows shown. I did it once before abotu 4 years ago.. but I can't figure it anymore.

I hope I'm explaining myself well. but here is a second go just in case. The formula to pull the data from each sheet is placed on the entire sheet (so that when that cell is populated the summary sheet will update) but I don't want the summary sheet to show hundreds of empty cells until they meet the criteria, I'd like it to only increase what you can see when they are populated. Thank you!!!
 

A:Solved: Excel Help 2010

Read other 7 answers