How to Remove Duplicate Rows in Excel

Apply below given the formula to remove duplicate rows in Excel:

=IF(MAX(COUNTIF(A1:A3306,A1:A3306))>1,"Duplicates","No Duplicates")

A1 is the Column, change to any column based upon your Excel Spread Sheet.

A3306 is the range of rows, change it your range of rows, it could be 100 or 200 or more depends upon the number of rows.

Rest, keep it default, and apply the formula next to the all rows and the duplicate rows will appear.

Cheers!!!

How to Change the Blogspot (Blogger) Post Title

How to Change the Blogspot (Blogger) Post Title

Generally by default Blogspot (Blogger) Post titles will be prefixed with Blogs Name first then Post Title. If you want to do post title Search Engines Friendly, follow the steps given below:
First Click on Design on the Top Right Corner or try to find Design link based upon your Blog Template, then click on Edit Html link to launch your Blog's html Code.
Look for the below given code in the Html Code.

<title><data:blog.pageTitle/></title>

Now, Replace the above Code with the below given code, and save Template. That's it now you will see that all your Posts Titles changed with your Desired Post Title.

<b:if cond='data:blog.pageType == "index"'><title><data:blog.title/></title><b:else/><title><data:blog.pageName/></title></b:if>

Enjoy!!

The BIG Keyboard Shortcut List

What is the allure of keyboard shortcuts? Do they really save time? Why bother since my mouse is permanently attached to my hand?


I like to use keyboard shortcuts, especially if someone is watching me, because they make me look like a pro. With just a few key strokes I can leave a mouser spinning his wheel! Whatever your motivation, here's a big list of keyboard shortcuts:


GENERAL SHORTCUTS


ALT- F4 - Quit a program / Shut down
ALT-TAB - Hold down the ALT key and hit tab to cycle through open windows.
CTL-ESCAPE - Display the Start menu
SHIFT - TAB - tab backwards through a form
CTRL - X - Cut
CTRL - C - Copy
CTRL - V - Paste
F1 - Help menu
CTRL - Z - Undo
SHIFT & Restart - To restart just windows and not your whole computer, hold down the shift key when you click the OK button on the shutdown screen. Saves lots of time. (not for XP)
CRTL-TAB - Navigate tabs on a tabbed screen


FILE & DESKTOP SHORTCUTS


Hold SHIFT while inserting a CD - Prevents the CD from "autorunning"
If an item is selected:
CTRL while dragging a file - Copies the file
CTRL - SHIFT while dragging a file - Creates a shortcut to the file
SHIFT - DELETE - Deletes an item without sending it to the recycle bin.
ALT-ENTER - Display a file's properties.
F2 - To rename the file
In Windows Explorer:
LEFT ARROW - Collapse the current selection if it is expanded
NUM LOCK-MINUS SIGN (-) - Collapse the selected folder
RIGHT ARROW - Expand the current selection if it is collapsed -Or- Select the first subfolder
NUM LOCK- * Expand all folders below the current selection
NUM LOCK- PLUS SIGN (+) - Expand the selected folder
F6 - Switch between left and right panes
In My Computer:
BACKSPACE - View the folder one level up
ALT- RIGHT ARROW - Move forward to a previous view
ALT- LEFT ARROW -Move backward to a previous view


INTERNET BROWSER SHORTCUTS


For Internet Explorer 6 and Netscape 7 (may work in older versions)

Open History Window	Ctrl+H
Reload	Ctrl+R
Back (Previous Page)	Alt+Left Arrow or Alt+Backspace
Forward (Next Page)	Alt+Right Arrow
Stop	Esc
Home	Alt+Home
Go to Bottom of Page	End
Go to Top of Page	Home
New Window	Ctrl+N
Close WIndow	Ctrl+W
Go Up one Line	Up Arrow
Go Down One Line	Down Arrow
Full Screen (toggle)	F11
Find on Page	Ctrl+F
Add Current Page to Favorites	Ctrl+D
Print Current Page or Active Frame	Ctrl+P
Organize Favorites (IE)/ Manage Bookmarks (NS)	Ctrl+B
Maximize a Window	Alt+Space+x
Minimize a window	Alt+Space+N
Scroll page up	Alt+Up Arrow
Scroll page down	Alt+Down Arrow

Internet Explorer ONLY

Open Favorites Bar	Ctrl+I
Select text in address bar	Alt+D

Force Reload (not from cache)               Ctrl+F5

A faster way to type in addresses with IE is to just type in the name of the site:
worldstart
and hit CTRL + Enter. The "http://www. " and ".com" will be added for you!


WINDOWS KEY SHORTCUTS


The Windows key can be used in conjunction with other keys to act as a keyboard shortcut for faster access to menu commands. Now, while the Alt key tends to open program menus (ex: Alt+F opens the File menu and Alt+E opens the Edit menu) and the Ctrl key performs actual operations (ex: Ctrl+C will copy and Ctrl+V will paste), the Windows key will open various Windows tools...
Win key + R will open the Start menu's Run box
Win key + F will open the Start menu's Find window
Win key + E will quickly launch Explorer
Win key + Pause/Break will open the System Properties window
Win key + M will Minimize all windows
Win key + Shift + M will undo Minimize all windows
Win key + D will switch between minimizing all open programs and showing them all
Win key + Tab will cycle through items on the taskbar
Win key by itself will open the Start menu
You can also open programs or folders on your desktop by pressing the Windows key + the first letter of the program/folder/shortcut + Enter . Sounds kinda tedious, but if you're in a bind with your mouse, it can come in quite handy.


ARROW TRICKS


Here's a cool little arrow trick to try with word processing programs. Next time you're using your arrow keys to go from one area of a sentence to another (left and right arrows), hold down your CTRL key. Instead of moving one space at a time, you'll go one word at a time.
If you're using the up and down arrows to go from line to line, holding down the CTRL key will make your cursor jump from paragraph to paragraph (well, from carriage return to carriage return anyway).
One last thing, if you hold down the SHIFT key while you do this (i.e. hold down SHIFT + CTRL at the same time), you select text as you arrow along.
I've tested this in MS Word and Wordpad, but it *should* work no matter what word processing program you use.


HOME / END KEY FUN


Do you ever find yourself scrolling through a huge folder ? Well, if you need to get to the beginning or the end quickly, just press Ctrl+Home . If you want to get to the end, click Ctrl+End.

Hey, that's not all!
This little trick works on more than just folders. If you use the Home key in a word processor, it goes to the beginning of the line you're currently working on. If you hit the END key, it should head to the end of the current line. If you pair Home & End up with the Ctrl key in a word processor, you will be whisked away to the beginning or end of the document. Again, this should work, but it depends on your word processor.

Speedup your work by using keyboard more and mouse less.

 

Useful Shortcut:

Start + M: Minimizes all open windows
Start + Shift + M: Maximizes All Windows
Start + E: Runs Windows Explorer
Start + R: Open the RUN Dialog Box
Start + F: Open the Search Results Dialog box
Start + CTRL + F: Opens the Search Results-Computer dialog Box (if the computer is connected to a network)
Start + Pause (Break): Opens the System Properties Dialog Box


Windows System Key Combinations:

F1: Help
CTRL + ESC: Open Start menu
ALT + TAB: Switch between open programs
ALT + F4: Quit program
SHIFT + DELETE: Delete item permanently


Windows Program Key Combinations:

CTRL + C: Copy
CTRL + X: Cut
CTRL + V: Paste
CTRL + Z: Undo
CTRL + B: Bold
CTRL + U: Underline
CTRL + I: Italic


Mouse Click/Keyboard Modifier Combinations for Shell Objects:

SHIFT + right click: Displays a shortcut menu containing alternative commands
SHIFT + double click: Runs the alternate default command (the second item on the menu)
ALT + double click: Displays properties
SHIFT + DELETE: Deletes an item immediately without placing it in the Recycle Bin


General Keyboard-Only Commands:

F1: Starts Windows Help
F10: Activates menu bar options
SHIFT + F10: Opens a shortcut menu for the selected item (this is the same as right-clicking an object
CTRL + ESC: Opens the Start menu (use the ARROW keys to select an item)
CTRL + ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
ALT + DOWN ARROW: Opens a drop-down list box
ALT + TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
ALT + SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
ALT +- (ALT + hyphen): Displays the Multiple Document Interface (MDI)child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)
CTRL + TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
ALT + underlined letter in menu: Opens the menu
ALT + F4: Closes the current window
CTRL + F4: Closes the current Multiple Document Interface (MDI) window
ALT + F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed
ALT + F6: switches between the Find dialog box and the main Notepad window)


Shell Objects and General Folder/Windows Explorer Shortcuts For a selected object:

F2: Rename object
F3: Find all files
CTRL + X: Cut
CTRL + C: Copy
CTRL + V: Paste
SHIFT + DELETE: Delete selection immediately, without moving the item to the Recycle Bin
ALT + ENTER: Open the properties for the selected object
To Copy a File: Press and hold down the CTRL key while you drag the file to another folder.
To Create a Shortcut: Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.


General Folder/Shortcut Control:

F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
F5: Refreshes the current window.
F6: Moves among panes in Windows Explorer
CTRL + G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
CTRL + Z: Undo the last command
CTRL + A: Select all the items in the current window
BACKSPACE: Switch to the parent folder
SHIFT + click + Close button: For folders, close the current folder plus all parent folders

Windows Explorer Tree Control:

Numeric Keypad *: Expands everything under the current selection
Numeric Keypad +: Expands the current selection
Numeric Keypad -: Collapses the current selection.
RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child
LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent


Properties Control:

CTRL + TAB/CTRL + SHIFT + TAB: Move through the property tabs


Accessibility Shortcuts:

Press SHIFT five times: Toggles StickyKeys on and off
Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off
Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off
Left ALT + left SHIFT+NUM LOCK: Toggles MouseKeys on and off
Left ALT + left SHIFT+PRINT SCREEN: Toggles high contrast on and off


Microsoft Natural Keyboard Keys:

Windows Logo: Start menu
Windows Logo + R: Run dialog box
Windows Logo + M: Minimize all
SHIFT + Windows Logo+M: Undo minimize all
Windows Logo + F1: Help
Windows Logo + E: Windows Explorer
Windows Logo + F: Find files or folders
Windows Logo + D: Minimizes all open windows and displays the desktop
CTRL + Windows Logo + F: Find computer
CTRL + Windows Logo + TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
Windows Logo + TAB: Cycle through taskbar buttons
Windows Logo + Break: System Properties dialog box
Application key: Displays a shortcut menu for the selected item


Microsoft Natural Keyboard with IntelliType Software Installed:

Windows Logo + L: Log off Windows
Windows Logo + P: Starts Print Manager
Windows Logo + C: Opens Control Panel
Windows Logo + V: Starts Clipboard
Windows Logo + K: Opens Keyboard Properties dialog box
Windows Logo + I: Opens Mouse Properties dialog box
Windows Logo + A: Starts Accessibility Options (if installed)
Windows Logo + SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys
Windows Logo + S: Toggles CAPS LOCK on and off


Dialog Box Keyboard Commands:

TAB: Move to the next control in the dialog box
SHIFT + TAB: Move to the previous control in the dialog box
SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
ENTER: Equivalent to clicking the selected button (the button with the outline)
ESC: Equivalent to clicking the Cancel button
ALT + underlined letter in dialog box item: Move to the corresponding item

Fast Approval Directories List

Here are the list of Fast / Instant Approval Directories List.

1	www.add-site-directory.com
2	www.allseostuff.com
3	www.blogvisiting.com
4	www.bookmarkingdirectory.com
5	www.ccwos.com
6	www.comebinearticles.com/
7	www.digitalpointdirectory.com
8	www.directoryamericans.com
9	www.directoryaustralian.com
10	www.directorybahrain.com
11	www.directorybirmingham.com
12	www.directoryenglish.com
13	www.directoryeuropean.com
14	www.directorygerman.com
15	www.directoryglasgow.com
16	www.directoryindustry.com
17	www.directoryitalian.com
18	www.directorykorean.com
19	www.directorymanchester.com
20	www.directorysouth.com
21	www.directoryspanish.com
22	www.directoryswiss.com
23	www.directorysydney.com
24	www.directoryunited.com
25	www.directoryunitedstates.com
26	www.easyactivedirectory.com
27	www.farstand.com
28	www.hadollar.com
29	www.hyperkore.com
30	www.internationalarticle.com
31	www.kacsca.com
32	www.linkcruncher.com
33	www.mastercomputer.co.uk
34	www.mikedir.com
35	www.ncnot.com
36	www.nfmnj.com
37	www.ramuce.com
38	www.regulararticle.com
39	www.submitarticle.info/
40	www.suggestlisting.com
41	www.take-fun.com
42	www.thatslink.com
43	www.unitedarabdirectory.com
44	www.welcomeindex.net
45	www.www.airec.net
46	www.www.arcaderocks.com
47	www.www.dir2dir.net
48	www.www.linkdir4u.com
49	www.yourstalk.com

Kindly Update me if you have any directory which is not listed above and also let me know if you come across any Parked or Broken link websites.

Types of Business Marketing & Promotion Ideas

Online Marketing & Promotion

• Search Engine Optimization (Onpage & Offpage)
• Search Engine Marketing (PPC Campaigns & Paid Promotions)
• Local Business Optimization (Google Places)
• Local Business Listing (Sulekha,JustDial, Yahoo Local) 
• Press Release Submission
• Directory Submission
• Reciprocal link Developing
• Twitter Posting
• FaceBook Posting
• Social Bookmarking
• Affiliate Marketing
• Article Publishing
• Blog Postings
• Forum Postings
• Classifieds Posting
• Email Marketing (Newsletter etc)
• Mobile Marketing (Sending SMS)
• Free SMS Option Via Website (Attach a simple tag at the bottom of every free message sent out)
• Free Downloads with WaterMarks on Graphic, Video and Software.
• Video Publishing (Youtube and other video promoting sites)
• RSS Feed Generating and Submission

Viral Media Marketing

• Brand Marketing Promotion Via 
• Hoardings Advertising
• Wallpaper Advertising
• Newspaper Advertising
• Lollipop Ads on Medians
• TV advertising
• Theatre Slideshow Advertising
• Brochures & Flyers
• Folders, PostCards & Posters

Kindly give your Suggestions or Comments on this posting...

SEO Tools List - Very Useful

Below Given Tools are very handy while doing Website Analysis or Website Optimization. Follow the links below for your website promotion.

Advanced Google searches
http://www.algotech.dk/googlesearches.asp

Alexa Rank Checker   
http://www.alexa.com/

Alexa Web Rank Checker   
http://www.searchbliss.com/rank.asp

Analyze robots.txt   
http://tools.seobook.com/robots-txt/analyzer/

Back Link Checker 
http://www.online-utility.org/webmaster/backlink_domain_analyzer.jsp

Backlink Anchor Text Analyzer   
http://www.webconfs.com/anchor-text-analysis.php

Bing Webmaster Tools   
http://www.bing.com/toolbox/webmasters/

Broken Link Checker
http://home.snafu.de/tilman/xenulink.html

Check if content is unique and original    
http://www.copyscape.com/

Competitors keywords research   
http://www.semrush.com/

Coolest Keyword Research Tool   
http://tools.seobook.com/keyword-tools/seobook/

DNS Check, Monitoring, IP Tracker   
http://www.dnsstuff.com/

Domain Age Checker   
http://www.webconfs.com/domain-age.php

Domain Name Details   
http://www.domaintools.com/

Domain Name Search Engine
http://www.domainsbot.com/

Domain Registration   
http://domainregistrationindia.com/

Domain Stats Tool   
http://www.webconfs.com/domain-stats.php

Duplicate Content Checker
http://www.virante.com/seo-tools/duplicate-content.php

Estimate Time and SEO Cost To Get Into GOOGLE TOP10   
http://www.uforward.net/seo_calculator.html

Free Web Counter   
http://www.digitalpoint.com/tools/counter/

Future PageRank Prediction   
http://www.seomastering.com/pagerank-prediction.php

Google Webmaster Tools   
www.google.com/webmasters/tools/

Google URL Shortener   
http://goo.gl/

Keyword Density Checker   
http://www.white-hat-web-design.co.uk/density.php

Link Building & Competitive Analysis Tools   
http://www.seomoz.org/tools

Link Popularity Checker   
http://www.addpro.com/popularity.htm

Meta Tags Generator Tool
 http://www.scrubtheweb.com/abs/builder.html

Mozill Firefox Add-ons   
https://addons.mozilla.org/en-US/firefox/

Multiple Page Rank Checker   
http://multipagerank.com/

Number of Pages Indexed   
http://www.selfseo.com/search_engines_index_report.php

PageRank Export History   
http://www.seocompany.ca/pagerank/page-rank-update-list.html

Registered Domain Details   
http://whois.domaintools.com/

Registered Domain Details   
http://www.networksolutions.com/whois/index.jsp

Robotos.txt File Generating Tool   
http://www.seochat.com/seo-tools/robots-generator/

Robotos.txt File Validator Tool   
http://tool.motoricerca.info/robots-checker.phtml

Robots.txt File Generator
http://tools.seobook.com/robots-txt/generator/

Search Engine Friendly Redirect Checker
http://www.webconfs.com/redirect-check.php

Search Status Firefox   
http://www.quirk.biz/searchstatus/

SEO Calculator   
http://www.searchenginegenie.com/tools/SEO-Cost-Calculator.php

SEO Forums   
http://www.seo-news.com/cgi-bin/gforum/gforum.cgi?guest=2107741

SEO Phrase Cost Calculator   
http://www.white-hat-web-design.co.uk/seo-cost.php

SEO Report   
http://www.urltrends.com

SEO Text Browser   
http://www.domaintools.com/seo-browser/

Site Advisor [ Mcafee ]   
http://www.siteadvisor.com/sites/

Site Comparision Tool   
http://www.justsearching.co.uk/tools/site-comparison/

URL Redirect Tool   
http://www.tiny.cc/

W3C Validator    
http://validator.w3.org/

Website Analysis Tools    
http://www.linkvendor.com/

Website Download Time Checker    
http://tools.pingdom.com/

Website Traffic Analysis Tool    
http://www.google.com/analytics/

Xml Sitemap Generating Tool  
http://www.auditmypc.com/free-sitemap-generator.asp

Xml Sitemap/Txt Sitemap Generating Tool  
http://www.xml-sitemaps.com/

Yahoo Webmaster Tools  
https://siteexplorer.search.yahoo.com/
  
W3C Validator
http://validator.w3.org/

Website Analysis Tools   
http://www.linkvendor.com/

Website Download Time Checker   
http://tools.pingdom.com/

Website Traffic Analysis Tool   
http://www.google.com/analytics/

Xml Sitemap Generating Tool   
http://www.auditmypc.com/free-sitemap-generator.asp

Xml Sitemap/Txt Sitemap Generating Tool   
http://www.xml-sitemaps.com/

Yahoo Webmaster Tools   
https://siteexplorer.search.yahoo.com/

Image Hosting Websites List

Image Hosting Websites	Website urls
Photo Bucket	http://photobucket.com/
Bharatstudent	http://www.bharatstudent.com/photoupload.php
Megaupload	http://www.megaupload.com/
Rapidshare	http://www.rapidshare.com/
Tinipic	http://tinypic.com/
Imageno	http://www.imageno.com/
Flickr	http://www.flickr.com/
Image Housing	http://www.imagehousing.com/
My Pixshare	http://www.mypixshare.com/
Imagger	http://www.imagger.com/
Pict	http://www.pict.com/
Hiboox	http://www.hiboox.com/
Foto	http://foto.xhost.lv/
Image Share	http://www.imageshare.asia/
Pixa	http://www.pixa.us/
Free Image Hosting	http://www.freeimagehosting.net/
Tiny Pic	http://tinypic.com/
Ziddu.com	http://ziddu.com/
Image Shack	http://imageshack.us/
Shutter Fly	http://www.Shutterfly.com/
Picasa	http://www.picasa.google.com
Baying	http://bayimg.com/
Dot Photo	http://www.dotphoto.com/
Fotki	http://www.fotki.com/
Fotolog	http://www.fotolog.com/
Jalbum	http://jalbum.net/
My Photo Album	http://www.myphotoalbum.com/
Panoramio	http://www.panoramio.com/
Photo Works	http://www1.photoworks.com/
Web Shots	http://www.webshots.com/
Snap Fish	http://www.snapfish.com/
Indya Rocks	http://www.indyarocks.com/
Deffe	http://www.deffe.com/