How Can I make a cell flash in Excel
I am looking to highlight certain cells in a column of data and would be helpful to make them flash, as oposed to just standard formatting
Cumbo
excel.misc
78881 articles. 
5 followers.
2 Replies
864 Views
Hi flashing would require VBA (using for example the OnTime method). But I strongky recommend against it: - slows down Excel - has IMHO nothing to do with serious spreadsheets - requires VBA and won't work if macros are disabled If you still want to go on with this search the Google archives for 'blinking cell' "Cumbo" wrote: > I am looking to highlight certain cells in a column of data and would be > helpful to make them flash, as oposed to just standard formatting
frank.kabel(Excel 2003 Windows XP)
Hi Frank;
1. I've read with great interest your reply to Cumbo, and I agree with most
of it.
2. In my particular application, it is absolutely critical that I've some
kind of text effects in a single cell so that I may adjust certain algorithms
associated with a complex non-linear optimization. I've chosen blinking cell.
3. The VBA one-second timer macros, Ontime method, events, conditional
format formula, etc. are all working fine. There is, however, one side
effect!
4. The Excel Screen, mouse Pointer, task bar Ready, macro Buttons, etc. are
"jiggling" or "pulsating", whether the conditional format formula is
returning TRUE or FALSE !!!!!
5. This nauseating behaviour has been encountered:
5.a (even) on a new w/b with a blank w/s that has absolutely nothing
on it (except the timer macro and the events)
5.b on two different computers
5.c with two different versions of Excel (XL2000 SP-2, XL2003)
5.d in two different versions of operating systems (windows 95,
Windows XP)
Your suggestions on how to suppress this side effect would be greatly
appreciated.
Thank you.
Incedentally, What is Google archives ??
"Frank Kabel" wrote:
> Hi
> flashing would require VBA (using for example the OnTime method).
> But I strongky recommend against it:
> - slows down Excel
> - has IMHO nothing to do with serious spreadsheets
> - requires VBA and won't work if macros are disabled
>
> If you still want to go on with this search the Google archives for
> 'blinking cell'
>
> "Cumbo" wrote:
>
> > I am looking to highlight certain cells in a column of data and would be
> > helpful to make them flash, as oposed to just standard formatting
monir
Similar Artilces:
How to get SUMPRODUCT on filtered cells
I'm currently using the formula =SUMPRODUCT((F2:I1475>=1)*(F2:I1475<=9999)) This gives me the number of the full range of cells but I need this to update whenever I use a variety of filters. Any help is greatly appreciated Sam.D Say we have data in A1 thru B29 like: flia value 0 pass 2 pass 1 pass 2 pass 1 pass 2 pass 0 pass 2 pass 1 pass 2 pass 1 pass 0 pass 2 pass 0 pass 1 pass 1 fail 1 fail 0 fail 2 fail 1 fail 0 fail 1 fail 2 fail 1 fail 1 fail 1 fail 1 fail 2 fail and are appling autofilter to column a. We want to use sumpr...
Comments in Cells disappear after time
A colleague has a spreadsheet with lots of comments in the cells and apparently after a while the comments 'disappear'. Does anyone have any ideas why this happens? Could it be there is a maximum number of comments, or do they have a life expectancy? The sheet is opened in Excel 2000 & Excel 2003 depending on the user. Thanks for your help. Comments don't normally disappear on their own. Perhaps your colleague is accidentally deleting the rows or columns in which the comments occur. Or comments could disappear if another cell, with no comment, is dragged onto a cell ...
Too many rows for Excel output from Access 2000
All: In my application I am exporting several records to excel file dynamically using a query,when the number of records exceeds 50000 records in one of the scenarios I am getting this error :There are too many rows to output, based on the limitation specified by the output format or Microsoft access Dim stDocName As String stDocName = "Query11" DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , 1 Can any one suggest the solution to this problem, Thanks in Advance, VT IIRC, OutputTo uses an earlier Excel format that limits to 16K rows. Use the TransferSp...
Multiple hyperlinks in one cell
Hey, I'm stuck with an excel problem which I cannot solve. I want to pu different messages in one cell and add a hyperlink to some of thes messages. For example I want to put this information all into one cell "message1 - message2(with hyperlink) - message3(with hyperlink) message4" I really hope it is possible to create multiple hyperlinks within on cell, but for now I can only add a hyperlink to a cell. If you would know how I could fix this issue I would be reall gratefull. Thx in advance, Veroniqu -- Message posted from http://www.ExcelForum.com If it's really...
VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add. I avoided using them because I'm not sure how/why they are created - i.e. maybe some user's defaults would only create 1 empty sheet or none. So, form MS Access's VBA I'd like to do: On Error Resume Next .Worksheets("Sheet1").Delete .Worksheets("Sheet2").Delete .Worksheets("Sheet3").Delete .Worksheets("Sheet4").Delete On Erro...
how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break, then a time when I leave work. Following that I want to be able to add up the amount of hours that I have worked. This will enable me to plan my week ahead and ensure I only allocate a specific amount of time to a project. http://www.cpearson.com/excel/datetime.htm#WorkHours -- Kind Regards, Niek Otten Microsoft MVP - Excel "Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message news:37D03D72-5525-4D6E-8ED7-2911B16248B0@microsoft.com... >I want to insert a time when I start work and...
Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is there a setting that I can use so that it opens each new excel file in a new excel window so I can drag different ones to each monitor? Is there a similar setting for Word? I am using Excel 2002 and Word 2002. Thank you. Hi, Yes, you can check the Windows in Taskbar checkbox in Tools; Options. This is on the View tab for both Word and Excel. >-----Original Message----- >I am using multiple monitors for work and it is great! Is >there a setting that I can use so that it opens each new >excel file in a new excel ...
Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400 server. I have created pararmeters within Access which asks for certain fields which works. I then go into Excel and create a pivot table with the external data source that I have created in access. When I go to enter a pararmeter within Microsof Query I get a reply saying that "Parameters can not be used with this Query", what I want to do is setup a parameter on the Excel spreadsheet which then goes and gets the data i require from this parameter. I would be very grateful if someone could help me with thi...
Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it possible to email to the address of what ever is in A34 is? The email body should say: this has been submitted for cell B34 and todays date. Thanks. Check out Ron De Bruins "Send-Mail" tips: http://www.rondebruin.nl/sendmail.htm Micky "Neil Holden" wrote: > If i type in the cell A34: neil.Holden@test.com and press a button is it > possible to email to the address of what ever is in A34 is? > > The email body should say: this has been submitted for cell B34 and...
go to next cell and paste question
I am writing a macro that is supposed to take certain cells from a "interface" page, remove them, and paste to a string of cells o another. That is easy, but I cant figure out how to make them go t another set of cells, if the ones I recorded are filled. Example: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8/4/2004 by Lane Lacy ' ' ActiveWindow.LargeScroll ToRight:=17 ActiveWindow.ScrollColumn = 239 ActiveWindow.SmallScroll ToRight:=10 Range("IV2:IV7").Select Selection.Copy Application.CutCopyMode = False Selection.Cut Sheets("productivity&qu...
Illegal operation error while printing EXCEL or WORD Files
Hi, I am facing an illegal operation error when i try to print any file from excel (any no. of pages), this happens in stand alone printer as well as a networked printer. When we press the print button, it flashes this message, but still prints, but once the printing is completed, i will have to restart the PC. Due to this error other applications PRINTING also will NOT HAPPEN and the only way out is, restart the PC. This happens not only in EXCEL, it happens in all the MS applications (outlook, access, front page, powerpoint also). When I check the print manager (before restart),...
can't send anything in Outlook 2002
I just sent a post asking for help because I can no longer send email with attachments. After sending in the post, I went back to Outlook and clicked on the Send/Receive button just to check if I had any new mail. I got the same message: "The operation failed". So I am totally out of business with Outlook. How to solve the problem? Marilyn Did it work before? Did you change anything in yr settings? Are you sure your internet mail account settings are valid (correct username, pw, smtp/pop3 servers)? ------------ "Marilyn Fogelquist" <fogel@cablespeed........
Making Serious Money Online
From: Ocie Lewis <olewis10550@yahoo.com> Date: Thursday, June 6, 2009, 6:08 PM --- ~~~~, I Want To Personally Introduce You To An Internet Millionaire! Hi ~~~, {Ocie} here with an major announcement... http://www.MyPartnersInProfit.com/bootcamp/?id=10286 For 25 people, this will be the most important e-mail you ever receive. (I hope you're one of them!) Because my new partner and I are looking for 25 people who are ready to take part in the greatest Internet marketing joint venture of all time. This joint venture is open to anyone. Even if you have a business alrea...
make column lists for select query.
sheet1 table1 col1_1 table1 col1_2 table1 col1_3 table1 col1_4 table1 col1_5 table1 col1_6 table2 col2_1 table2 col2_2 table2 col2_3 table2 col2_4 .... .... sheet2 table1 col1_1,col1_2,col1_3,col1_4,col1_5,col1_6, table2 col2_1,col2_2,col2_3,col2_4, .... .... I want to make column lists for some table listed in sheet1. for example, select column_lists from table1 without vba is it possible? thanks. I think you may want some dependent lists. http://www.contextures.com/xlDataVal02.html HTH, Barb Reinhardt "kang" wrote: > sheet1 > table1 col1_1 > table1 col1_2 >...
How can I drop a flyer from Publisher into PowerPoint as a slide?
I have created a flyer in Publisher but I now need to drop it into PowerPoint as a slide, is this possible? No, not really. You could open up both instances, Powerpoint and Publisher, and then drag and drop/copy and paste from the Publisher window to the Powerpoint window, the reformat as needed. -- Brian Kvalheim Microsoft Publisher MVP http://www.publishermvps.com This posting is provided "AS IS" with no warranties, and confers no rights. "melann" <melann@discussions.microsoft.com> wrote in message news:58EE1229-ED29-4A5F-B4D6-BDE863876DB0@microsoft.com... &...
Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump drive so I can work on them at home. I attempted to work on a Word documents which had an Excel worksheet inserted in it. I tried double clicking on the worksheet to edit it and Word and Excel shut down. Now when I attempt to open Excel at home it asks for my Office XP Professional installation cd. (I have Office XP at home with Windows XP). I'm having a hard time locating my original discs. Does anyone have any suggestions or experience anything like this? ...
How can Journal be used if Project is not installed, or on the net
How can Journal be used if Project is not installed, or on the network -- Rusty Nichols Network Support Technician The Journal folder works without Project being installed at all. It's an integral part of Outlook. What functionality are you seeking? "Rusty" <w_r_nichols_iii@yahoo.com> wrote in message news:7EA79673-AE35-44D2-A09E-EBF73E7EC414@microsoft.com... > How can Journal be used if Project is not installed, or on the network How can Journal potentially affect the Exchange server, and I would like more information on Journal for a Outlook foundation class? ...
Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other templates not available in Excel today - speedometer charts, multi-dimension comparitive charts, charts that build information overlays. I regularly create these in a manual way for executive and customer summaries but would appreciate the ability to automatically generate these types of charts allowing for real time viewing of "what if" scenarios. Steve, there are tons of these things out there to review, few better than this collection: http://www.andypope.info/charts.htm Andy Pope has put together...
Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me what keystroke allows me to edit a cell? Before I switched to a Mac it was the F2 button. Please help. Thank you. See the answers in the m.p.mac.office.excel newsgroup. In article <1176582208.958694.269620@q75g2000hsh.googlegroups.com>, ssears@indy.tds.net wrote: > Switched to Microsofts version of Excel for Mac. Can anyone tell me > what keystroke allows me to edit a cell? Before I switched to a Mac > it was the F2 button. Please help. Thank you. ...
Merge Cells #5
I know how to merge two cells using formula =A1&B1, but can someone tell me how to insert spacing between the two within the new cell. I'm merging a part number and description, and need spacing between them. Use =A1&" "&B1 the " " is showing that you want to insert text, and that the text is a space character. It could be "-" or ".", etc. "R. Stevens" <R. Stevens@discussions.microsoft.com> wrote in message news:B02E936E-5947-4F1B-A8E5-F5A30343E549@microsoft.com... > I know how to merge two cells using formula =...
EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a number of changes is causing me problems when I re-open the file. Windows task manager goes to 100% CPU activity, and i cant do anything within the excel file. However, if I set recalculation to manual before I open the file, all seems fine. Obvioulsy I have a problem. But how do i find that problem ? Thanks in advance. I have had some experience running large spreadsheets lately. Above a certain size, the recalculation time seems to climb very fast. While Excel is recalculating, you can't do anything anyway. Best in my v...
How Can I Tell What Button Was Just Clicked?
I have a bunch of images on the sheet that calls ONE function. Is there a way I can tell which button was clicked within the function? I'd hate to make a function for each image. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ See one technique at your other thread. kenji4861 wrote: > > I have a bunch of images on the sheet that calls ONE function. > > Is there a way I can tell which button was clicked within the > function? > > I'd h...
How can I tell if our GP 9.0 is updated to the latest SP and patch
We recently upgraded our GP to 9.0, but I'm not sure we are at SP1 or the latest patches have been installed. Is there a way to tell from the versions numbers displayed in the "About Microsoft Dynamics GP" box? Or, maybe asked a different way, if at the latest updates, what should the Dexterity and GP 9.0 version numbers be at? hello, You know if it's Dynamics GP SP1 when you see that: Dynamics GP - 9.00.0259 Dexterity - 9.00.0068.0 rgds, timber On Oct 6, 6:35 am, dcnjoe60 <dcnjo...@discussions.microsoft.com> wrote: > We recently upgraded our GP to 9.0, bu...
Multiple conditional formating for one cell
I have a workbook with several sheets. Sheet1 has several hundred rows of text. Some of the same text will appear in multiple rows of Sheet1. On Sheet2 I have I have a cell that allows my users to free hand type in a keyword(s) to search for in Sheet1. This cell is also has a reference name of "Special_Char". Now comes the question..... I like to for the user to type the keywork into "Special_Char" and any or all the rows in Sheet1 that contain the keyword as part of its text to turn yellow. Is there a way to do this? Please keep in mind that the keywork i...
In Excel program shows a broken line and don't know how to get ri.
I am trying to put in entries in Excel program and when I go to Print Preview, it only shows part of the entries I put in. When I go to the last entry that it shows in Print Preview, there is a broken line between it and the next entry. I don't know what I did. I could use some help You probably have multiple areas selected for your print area. you can check this by <view><page break preview> One possibility to correct this would be <file><print area><clear print area> or specifically select the area you want printed and <file ><Print area>...
I'm currently using the formula =SUMPRODUCT((F2:I1475>=1)*(F2:I1475<=9999)) This gives me the number of the full range of cells but I need this to update whenever I use a variety of filters. Any help is greatly appreciated Sam.D Say we have data in A1 thru B29 like: flia value 0 pass 2 pass 1 pass 2 pass 1 pass 2 pass 0 pass 2 pass 1 pass 2 pass 1 pass 0 pass 2 pass 0 pass 1 pass 1 fail 1 fail 0 fail 2 fail 1 fail 0 fail 1 fail 2 fail 1 fail 1 fail 1 fail 1 fail 2 fail and are appling autofilter to column a. We want to use sumpr...
Comments in Cells disappear after time
A colleague has a spreadsheet with lots of comments in the cells and apparently after a while the comments 'disappear'. Does anyone have any ideas why this happens? Could it be there is a maximum number of comments, or do they have a life expectancy? The sheet is opened in Excel 2000 & Excel 2003 depending on the user. Thanks for your help. Comments don't normally disappear on their own. Perhaps your colleague is accidentally deleting the rows or columns in which the comments occur. Or comments could disappear if another cell, with no comment, is dragged onto a cell ...
Too many rows for Excel output from Access 2000
All: In my application I am exporting several records to excel file dynamically using a query,when the number of records exceeds 50000 records in one of the scenarios I am getting this error :There are too many rows to output, based on the limitation specified by the output format or Microsoft access Dim stDocName As String stDocName = "Query11" DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , 1 Can any one suggest the solution to this problem, Thanks in Advance, VT IIRC, OutputTo uses an earlier Excel format that limits to 16K rows. Use the TransferSp...
Multiple hyperlinks in one cell
Hey, I'm stuck with an excel problem which I cannot solve. I want to pu different messages in one cell and add a hyperlink to some of thes messages. For example I want to put this information all into one cell "message1 - message2(with hyperlink) - message3(with hyperlink) message4" I really hope it is possible to create multiple hyperlinks within on cell, but for now I can only add a hyperlink to a cell. If you would know how I could fix this issue I would be reall gratefull. Thx in advance, Veroniqu -- Message posted from http://www.ExcelForum.com If it's really...
VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add. I avoided using them because I'm not sure how/why they are created - i.e. maybe some user's defaults would only create 1 empty sheet or none. So, form MS Access's VBA I'd like to do: On Error Resume Next .Worksheets("Sheet1").Delete .Worksheets("Sheet2").Delete .Worksheets("Sheet3").Delete .Worksheets("Sheet4").Delete On Erro...
how do I add times in Excel and result in hours & mins
I want to insert a time when I start work and a time when I take a break, then a time when I leave work. Following that I want to be able to add up the amount of hours that I have worked. This will enable me to plan my week ahead and ensure I only allocate a specific amount of time to a project. http://www.cpearson.com/excel/datetime.htm#WorkHours -- Kind Regards, Niek Otten Microsoft MVP - Excel "Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message news:37D03D72-5525-4D6E-8ED7-2911B16248B0@microsoft.com... >I want to insert a time when I start work and...
Opening a new instance of Excel
I am using multiple monitors for work and it is great! Is there a setting that I can use so that it opens each new excel file in a new excel window so I can drag different ones to each monitor? Is there a similar setting for Word? I am using Excel 2002 and Word 2002. Thank you. Hi, Yes, you can check the Windows in Taskbar checkbox in Tools; Options. This is on the View tab for both Word and Excel. >-----Original Message----- >I am using multiple monitors for work and it is great! Is >there a setting that I can use so that it opens each new >excel file in a new excel ...
Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400 server. I have created pararmeters within Access which asks for certain fields which works. I then go into Excel and create a pivot table with the external data source that I have created in access. When I go to enter a pararmeter within Microsof Query I get a reply saying that "Parameters can not be used with this Query", what I want to do is setup a parameter on the Excel spreadsheet which then goes and gets the data i require from this parameter. I would be very grateful if someone could help me with thi...
Emailing in excel 2003 02-26-10
If i type in the cell A34: neil.Holden@test.com and press a button is it possible to email to the address of what ever is in A34 is? The email body should say: this has been submitted for cell B34 and todays date. Thanks. Check out Ron De Bruins "Send-Mail" tips: http://www.rondebruin.nl/sendmail.htm Micky "Neil Holden" wrote: > If i type in the cell A34: neil.Holden@test.com and press a button is it > possible to email to the address of what ever is in A34 is? > > The email body should say: this has been submitted for cell B34 and...
go to next cell and paste question
I am writing a macro that is supposed to take certain cells from a "interface" page, remove them, and paste to a string of cells o another. That is easy, but I cant figure out how to make them go t another set of cells, if the ones I recorded are filled. Example: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8/4/2004 by Lane Lacy ' ' ActiveWindow.LargeScroll ToRight:=17 ActiveWindow.ScrollColumn = 239 ActiveWindow.SmallScroll ToRight:=10 Range("IV2:IV7").Select Selection.Copy Application.CutCopyMode = False Selection.Cut Sheets("productivity&qu...
Illegal operation error while printing EXCEL or WORD Files
Hi, I am facing an illegal operation error when i try to print any file from excel (any no. of pages), this happens in stand alone printer as well as a networked printer. When we press the print button, it flashes this message, but still prints, but once the printing is completed, i will have to restart the PC. Due to this error other applications PRINTING also will NOT HAPPEN and the only way out is, restart the PC. This happens not only in EXCEL, it happens in all the MS applications (outlook, access, front page, powerpoint also). When I check the print manager (before restart),...
can't send anything in Outlook 2002
I just sent a post asking for help because I can no longer send email with attachments. After sending in the post, I went back to Outlook and clicked on the Send/Receive button just to check if I had any new mail. I got the same message: "The operation failed". So I am totally out of business with Outlook. How to solve the problem? Marilyn Did it work before? Did you change anything in yr settings? Are you sure your internet mail account settings are valid (correct username, pw, smtp/pop3 servers)? ------------ "Marilyn Fogelquist" <fogel@cablespeed........
Making Serious Money Online
From: Ocie Lewis <olewis10550@yahoo.com> Date: Thursday, June 6, 2009, 6:08 PM --- ~~~~, I Want To Personally Introduce You To An Internet Millionaire! Hi ~~~, {Ocie} here with an major announcement... http://www.MyPartnersInProfit.com/bootcamp/?id=10286 For 25 people, this will be the most important e-mail you ever receive. (I hope you're one of them!) Because my new partner and I are looking for 25 people who are ready to take part in the greatest Internet marketing joint venture of all time. This joint venture is open to anyone. Even if you have a business alrea...
make column lists for select query.
sheet1 table1 col1_1 table1 col1_2 table1 col1_3 table1 col1_4 table1 col1_5 table1 col1_6 table2 col2_1 table2 col2_2 table2 col2_3 table2 col2_4 .... .... sheet2 table1 col1_1,col1_2,col1_3,col1_4,col1_5,col1_6, table2 col2_1,col2_2,col2_3,col2_4, .... .... I want to make column lists for some table listed in sheet1. for example, select column_lists from table1 without vba is it possible? thanks. I think you may want some dependent lists. http://www.contextures.com/xlDataVal02.html HTH, Barb Reinhardt "kang" wrote: > sheet1 > table1 col1_1 > table1 col1_2 >...
How can I drop a flyer from Publisher into PowerPoint as a slide?
I have created a flyer in Publisher but I now need to drop it into PowerPoint as a slide, is this possible? No, not really. You could open up both instances, Powerpoint and Publisher, and then drag and drop/copy and paste from the Publisher window to the Powerpoint window, the reformat as needed. -- Brian Kvalheim Microsoft Publisher MVP http://www.publishermvps.com This posting is provided "AS IS" with no warranties, and confers no rights. "melann" <melann@discussions.microsoft.com> wrote in message news:58EE1229-ED29-4A5F-B4D6-BDE863876DB0@microsoft.com... &...
Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump drive so I can work on them at home. I attempted to work on a Word documents which had an Excel worksheet inserted in it. I tried double clicking on the worksheet to edit it and Word and Excel shut down. Now when I attempt to open Excel at home it asks for my Office XP Professional installation cd. (I have Office XP at home with Windows XP). I'm having a hard time locating my original discs. Does anyone have any suggestions or experience anything like this? ...
How can Journal be used if Project is not installed, or on the net
How can Journal be used if Project is not installed, or on the network -- Rusty Nichols Network Support Technician The Journal folder works without Project being installed at all. It's an integral part of Outlook. What functionality are you seeking? "Rusty" <w_r_nichols_iii@yahoo.com> wrote in message news:7EA79673-AE35-44D2-A09E-EBF73E7EC414@microsoft.com... > How can Journal be used if Project is not installed, or on the network How can Journal potentially affect the Exchange server, and I would like more information on Journal for a Outlook foundation class? ...
Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other templates not available in Excel today - speedometer charts, multi-dimension comparitive charts, charts that build information overlays. I regularly create these in a manual way for executive and customer summaries but would appreciate the ability to automatically generate these types of charts allowing for real time viewing of "what if" scenarios. Steve, there are tons of these things out there to review, few better than this collection: http://www.andypope.info/charts.htm Andy Pope has put together...
Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me what keystroke allows me to edit a cell? Before I switched to a Mac it was the F2 button. Please help. Thank you. See the answers in the m.p.mac.office.excel newsgroup. In article <1176582208.958694.269620@q75g2000hsh.googlegroups.com>, ssears@indy.tds.net wrote: > Switched to Microsofts version of Excel for Mac. Can anyone tell me > what keystroke allows me to edit a cell? Before I switched to a Mac > it was the F2 button. Please help. Thank you. ...
Merge Cells #5
I know how to merge two cells using formula =A1&B1, but can someone tell me how to insert spacing between the two within the new cell. I'm merging a part number and description, and need spacing between them. Use =A1&" "&B1 the " " is showing that you want to insert text, and that the text is a space character. It could be "-" or ".", etc. "R. Stevens" <R. Stevens@discussions.microsoft.com> wrote in message news:B02E936E-5947-4F1B-A8E5-F5A30343E549@microsoft.com... > I know how to merge two cells using formula =...
EXCEL TROUBLESHOOTING #2
I have an excel file (2000 format), that after I made a number of changes is causing me problems when I re-open the file. Windows task manager goes to 100% CPU activity, and i cant do anything within the excel file. However, if I set recalculation to manual before I open the file, all seems fine. Obvioulsy I have a problem. But how do i find that problem ? Thanks in advance. I have had some experience running large spreadsheets lately. Above a certain size, the recalculation time seems to climb very fast. While Excel is recalculating, you can't do anything anyway. Best in my v...
How Can I Tell What Button Was Just Clicked?
I have a bunch of images on the sheet that calls ONE function. Is there a way I can tell which button was clicked within the function? I'd hate to make a function for each image. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ See one technique at your other thread. kenji4861 wrote: > > I have a bunch of images on the sheet that calls ONE function. > > Is there a way I can tell which button was clicked within the > function? > > I'd h...
How can I tell if our GP 9.0 is updated to the latest SP and patch
We recently upgraded our GP to 9.0, but I'm not sure we are at SP1 or the latest patches have been installed. Is there a way to tell from the versions numbers displayed in the "About Microsoft Dynamics GP" box? Or, maybe asked a different way, if at the latest updates, what should the Dexterity and GP 9.0 version numbers be at? hello, You know if it's Dynamics GP SP1 when you see that: Dynamics GP - 9.00.0259 Dexterity - 9.00.0068.0 rgds, timber On Oct 6, 6:35 am, dcnjoe60 <dcnjo...@discussions.microsoft.com> wrote: > We recently upgraded our GP to 9.0, bu...
Multiple conditional formating for one cell
I have a workbook with several sheets. Sheet1 has several hundred rows of text. Some of the same text will appear in multiple rows of Sheet1. On Sheet2 I have I have a cell that allows my users to free hand type in a keyword(s) to search for in Sheet1. This cell is also has a reference name of "Special_Char". Now comes the question..... I like to for the user to type the keywork into "Special_Char" and any or all the rows in Sheet1 that contain the keyword as part of its text to turn yellow. Is there a way to do this? Please keep in mind that the keywork i...
In Excel program shows a broken line and don't know how to get ri.
I am trying to put in entries in Excel program and when I go to Print Preview, it only shows part of the entries I put in. When I go to the last entry that it shows in Print Preview, there is a broken line between it and the next entry. I don't know what I did. I could use some help You probably have multiple areas selected for your print area. you can check this by <view><page break preview> One possibility to correct this would be <file><print area><clear print area> or specifically select the area you want printed and <file ><Print area>...