Select the portion from where you want to remove all the hyperlinks, press Ctrl + Alt + F9. Done!
I use Word 2007 and it worked for me.
Playing with Fractions and Integers in Excel
April 1, 2009 - Leave a Response
Have you faced a situation in Excel where you want it to automatically show integers as integers and fractions as proper fractions (e.g. 8/3) and not mixed fractions (e.g. 2 2/3) or decimals (e.g. 2.6667)?
Well, I faced that situation today. Excel does not have a direct solution to this.
Yes, you can go to ‘Format Cells’ -> ‘Number’ and choose the format you want.
I will take two numbers to show an example of my problem: 8 and 8/3. I want them to be shown just as I typed them here.
Problem if I use default Fractional format (“# ???/???”): I see those numbers as 8 and 2 2/3.
Problem if I use a custom Fractional format (“???/???”): I see those numbers as 8/1 and 8/3.
Solution:
=IF(MOD(A1,A2)=0,TEXT(A1/A2,”#”),TEXT(A1/A2,”???/???”))
NOTE: A2 could be 1.
Here I have used A1 and A2 as example cells. For my application, I needed the formula,
=IF(MOD(B$4,(2*$A5))=0,TEXT(B$4/(2*$A5),”#”),TEXT(B$4/(2*$A5),”???/???”))
My Favorite Stylish Styles for Firefox
October 24, 2008 - Leave a Response
I thought of writing this post because I was frustrated of syncing the styles between home and work PC. By keeping this post updated, at least I will always know which Stylish style I’ve forgotten to install at one place (home/work).
There should have been a proper way to sync scripts like Stylish and Greasemonkey on multiple PCs. Until till, I will need to keep a log on the scripts I like on a blog like this.
Stylish extension can be installed from here.
Stylish scripts
- AwesomeBar Results Sized Down [userstyles.org]
Thanks to this, now the AwesomeBar suggestions don’t cover up top-half of the screen.
- Bold the Options Menu Item [userstyles.org]
You don’t need to hunt for ‘Options’, the most used thing in Tools menu.
- Change Text Highlighting Selector Color [userstyles.org]
The new brown-green combination is cooler, just check it out.
- Dim the annoyingly bright RSS and bookmark buttons [userstyles.org]
- Display ‘Keyword’ field in the Bookmark dialog [userstyles.org]
This is, probably, my most frequently used feature of these listed. - Firefox 3 Tab Colors [userstyles.org]
- Hide Back/Forward Buttons when not needed [userstyles.org]
- Italicize unread tabs [userstyles.org]
- Remove the Edit Main toolbar menu [userstyles.org]
Who doesn’t know copy/paste shortcuts? - Remove the Help Main toolbar menu [userstyles.org]
Who needs to access Firefox help? - Remove the Bookmarks Main toolbar menu [userstyles.org]
Use Ctrl+Shift+b. - Remove the File Main toolbar menu [userstyles.org]
Who doesn’t know the shortcuts to open new tab/window, print, …? - Remove the History (Go) Main toolbar menu [userstyles.org]
Use Ctrl+h. - Remove the Home button [userstyles.org]
Use Alt+Home. This is one of my most used Firefox shortcuts. - Remove the RSS Feed Icon button from Firefox 3 & 2 [userstyles.org]
It removes this icon when the page you are viewing does not have RSS feed to subscribe to. - Smartly show Stop & Reload buttons [userstyles.org]
- Yellow https bar [userstyles.org]
Many thanks to the developers of these scripts!
