Simply right-click one of the data markers in the chart and you can over-write the label.
Monday 22 November 2010
Thursday 18 November 2010
Starbucks - How to Make a Card the Default Card
Posted on 19:17 by Unknown
If you wish to set up a default
Under the words “Card Management” on the “Manage My Cards” page, click on the image of the card you would like to make your default. When the image and information is brought up, click on “change this card’s nickname”. On the next page, you can select “Make this my default card and display it first in my card library.”
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.
Friday 12 November 2010
Excel | Conditional Formatting - How to color adjacent or remote cells
Posted on 07:36 by Unknown
Use a formula like this:
=FIND("Own",$D119)
=FIND("Order",$E119)
=FIND("Own",$D1)
=FIND("Own",$D119)
=FIND("Order",$E119)
=FIND("Own",$D1)
Sunday 7 November 2010
Delete all Hyperlinks in Excel
Posted on 21:55 by Unknown
Here is how to delete all hyperlinks in an Excel worksheet:
Then:
- Open your Excel spreadsheet that you wish to remove the hyperlinks from.
- Press
-F11 to go to the Visual Basic editor. - Create a new module. You can do this by selecting Module under the Insert menu.
- Paste the following code into your new module:
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Then:
- Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.
- Now, go to the sheet that contains the hyperlinks that you wish to delete.
- Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button.
Excel - Deleting All Graphics
Posted on 18:59 by Unknown
Here is how to delete all graphics at one time in a worksheet:
Press F5 to display the Go To dialog box.
Click on the Special button. Excel displays the Go To Special dialog box.
Select the Objects radio button.
Click OK. All the graphics in your worksheet are selected.
Press the Del key. All the graphics are deleted.
Thanks to: http://excel.tips.net/Pages/T003018_Deleting_All_Graphics.html
Press F5 to display the Go To dialog box.
Click on the Special button. Excel displays the Go To Special dialog box.
Select the Objects radio button.
Click OK. All the graphics in your worksheet are selected.
Press the Del key. All the graphics are deleted.
Thanks to: http://excel.tips.net/Pages/T003018_Deleting_All_Graphics.html
Saturday 6 November 2010
Internet Explorer - Runtime Error
Posted on 14:36 by Unknown
Here is how to fix IE for this error message:
Microsoft Visual C++ Runtime Library Runtime Error! This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.
IE should be closed, then:
Go to control panel and internet options.
Microsoft Visual C++ Runtime Library Runtime Error! This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.
IE should be closed, then:
Go to control panel and internet options.
"Delete cookie, delete files; and then go to settings and then view files and delete them all. Then click ok (this is all under the general tab).
Thanks! to Hsherriff @ http://www.cybertechhelp.com/forums/showthread.php?t=44910
Thanks! to Hsherriff @ http://www.cybertechhelp.com/forums/showthread.php?t=44910
Subscribe to:
Posts (Atom)