Showing posts with label Troubleshooting. Show all posts
Showing posts with label Troubleshooting. Show all posts

Making Site Compatible with AdSense Policies


Making Site Compatible with AdSense


While applying for the AdSense, there are different ways you might get disapproved by Google. One of them is Incompatible Site. You will get a message like this - Site does not comply with Google policies. It's really frustrating when your site's content is okay but Google denies your AdSense request. 


Today I would like to discuss how to solve the issue - Site does not comply with Google policies. In fact, after having the custom domain, I'm also facing the same problem. But I can solve it within few days. 


There are three major areas on which you have to focus in order to make your site compatible with Google AdSense policies:
  • Design and Content Guidelines
  • Technical Guidelines
  • Quality Guidelines

Though you will get a detailed discussion in Google Webmaster Guideline Page, I'd like to summarize the topic for you. Because only few people have the patience to read a 1200 words + article! And some of the issues are highly technical. I will try to make them as clear as possible. 


Design and Content Guidelines
  • Your site should have a clear hierarchy and text links. Every page should be accessible from at least one static text link. I suggest you to use Blog Archive and Categories.
  • Provide a sitemap for the users so that they can explore your site as they want. 
  • Think about the words which users might search for and include those words in your contents post titles. Don't forget to relate your contents to those key words. 
  • Images are not recognized by search engines. Use as much text as possible in your contents. And label your images properly, consider using the Alternative description too. 
  • Try to find out HTML errors (if any) and fix them.


Technical Guidelines
  • Keep your site faster. Analyze the loading time of your site through various tools available over the web. Slower sites get less pageviews. So, never let it down. 
  • Test your site in major browsers (ie. Chrome, Firefox, Internet Explorer, Opera, Safari etc.) and make sure that it appears correctly. 
  • Properly use robots.txt so that search engines can crawl your site smoothly. 
  • Get your domain registered in high quality servers. 


Quality Guidelines
  • Build your contents primarily for the users, not for the search engines.
  • Never try to deceive/mislead your users. 
  • Never follow the illegal techniques that automatically improve your search ranking position by cheating the search engines. (Black Hat SEO)
  • Differentiate your site from competitors. Keep it unique, informative and valuable for the users. 


Avoid the Following Techniques 
  • Generating Contents Automatically
  • Participating in Link Exchange
  • Cloaking - Showing different contents to human and search engines
  • Redirecting the Users to an Unwanted Site
  • Hiding Text/Links
  • Participating in Affiliate Programs without Sufficient Contents
  • Using Irrelevant Keywords to Improve Search Ranking
  • Spreading Virus, Malware, Spam, Phishing etc.


Violating any of the above rules may take your site down in the search engine rank position. And your site may not comply with Google AdSense Policies. 


Stay with Marks PC Solution to get more interesting IT topics!



Type Multiple Lines in a Cell in Excel


How to Type Multiple Lines in a Single Cell in Excel


Excel users often face a common problem. Normally you can't type two or three words in a cell in Microsoft Excel. You have to merge cells to type something. But if you have no option to merge cell horizontally then you may fall in trouble. Believe it or not, last week I had the same problem while working in a worksheet! 


Today I am sharing the solution with you. Look at the image below - 


Multiple Lines in a Row


By default, you can't type like the image above in MS Excel. Have you noticed - I haven't merge the rows or colums. And there are 3 lines in Column A and 4 lines in Column B. Try to type multiple lines in a row or cell. Simply you can't. You have to use the Wrap Text option to type multiple lines in a cell. 



For Excel 2003

Sorry to say, I don't have Microsoft Office 2003. So I can't show you the path. Probably you have to follow this way- 

Format Menu > Font > Format Cells > Alignment > Text Control > Wrap Tex (Check the box) > OK. 

I'm not sure about this command. But the main point is - find the format cells window and then check the wrap text from alignment tab. 

You can also press Shift + Ctrl + F to open Fomat Cells dialogue box. 



For Excel 2007 and 2010

In Excel 2007 or 10, the process is almost same. But as you have to use the ribbon interface, you have to follow this way - 


Wrap Text Under Alignment in Home Tab


Go to the Home Tab > Click on the Marked area of Alignment > Now you will get Format Cells window (Shift + Ctrl + F) > Choose Alignment tab > Check the Wrap text option > Hit OK. 



Shortcut Method!

Maybe it's very time consuming for you. I'm gonna share a secret shortcut! 

Type your text in cell, when the area ends, press Alt+Enter. You will get a new line in cell! See the image below: 


Multipe Lines in a Row


First I've typed Marks PC, then I pressed Alt+Enter and typed Solution. But remember, first you have adjust the column size. Adjust the column size and then type your text. Once you press Alt+Enter, new lines will be creating automaticlly when the cell area ends. 


There is another shortcut for you! Just look at the image below:


Wrap Text Icon in Home Tab

Have you noticed the market button? It's in the Alignment section, just below the Review Tab. This button is a shortcut to wrap text. Type your text and hit on this button to create multiple lines in a row/ cell. 


You can adjust the column size after typing the text. Your lines will be adjusted automatically. 


Stay with Marks PC Solution to get more interesting IT topics!


How to Print PowerPoint Slides?



Printer Friendly Version of PowerPoint Slides



PowerPoint slides are usually very colorful. A presentation may include colorful backgrounds, charts, images etc. The slide maker always tries to make the slides attractive so that the audience concentrate to the presentation. Those slides though look amazing on a projector screen, may not be printer friendly at all! If you print a color slide normally, you can't read this well. 


Not many people need to print from Microsoft PowerPoint. Some of you may know the power point printing tips. But most guys copy the slides one by one and paste them to Microsoft Word! :) 


Today I'm gonna discuss about how to print PowerPoint slides as handouts. 



PowerPoint 2003

Open your presentation using Microsoft PowerPoint 2003. Now press Ctrl+P to open the Print Window. Look at the image below:


Print Options of PowerPoint 2003


Go to the Print What option and choose Handouts. In the color option, choose either Blank and White or Grayscale. Now go to the Handouts option > Slides per page > Choose 3, 4, 6 or 9 as your wish. 

Almost done! Choose your printer and hit on the OK button to print. 



PowerPoint 2010/ 2007

Office 2010 is the smartest version of Microsoft Office. I really like the print options of Office 2010. PowerPoint 2007 and 2010 is somewhat different but most of the options are almost same. 

To print handouts in Office 2010, open your presentation. Then press Ctrl + P to open the print window. Now look at the image below:


PowerPoint 2010 Print Options


From the Slides option, choose the number of slides. And from the Color option, choose Grayscale. Choose your printer and hit on the Print button to print. 


Note: If you would like to save your paper and ink, you can choose Outline instead of slides. Simply go to the Slides and choose outline. Check the preview. It it's okay then hit on the Print button. 



Important Keyboard Shortcuts
  • Press F5 to start the slide show
  • Press Shift+F5 to start the show from the current slide
  • Press Spacebar/ Enter to change the slides
  • Press Esc to end the show


Hope you've enjoyed the post. leave comment to share with us . . . 


Stay with Marks PC Solution to get more interesting IT topics!




Delete All Emails from Yahoo Inbox!!


How to Delete All Emails from Yahoo


By the grace of Facebook, your inbox is getting fat everyday. If your Yahoo Inbox are filled with thousand of unnecessary messages, then it could be difficult for you to find the important mails. Gmail users can easily delete all emails from inbox because it has option to select all messages at the same time. 



Like Gmail, Yahoo has also the Select All option. But the Select All option of Yahoo can't select the whole inbox. It is capable of selecting the loaded messages only. It could be 50, 100, 200 or how much messages you've loaded at a time. If you wanna delete a large volume of messages from Yahoo inbox, then you have to be little bit tricky! 

Today, I'm gonna discuss how to quickly delete all messages from Yahoo Mail inbox. 



Before you start - 

Make sure you're using the latest version of your browser and latest interface of Yahoo Mail. Firefox or Internet Explorer is optimized for Yahoo Mail. Chrome users could get a message to change the browser. And definitely you need a better net connection while running this task.



Deleting All Messages of Yahoo Inbox

  • Sign in to Yahoo and open your Yahoo Mail Inbox. Never press Esc. Let the mailbox load completely. 
  • By default, 50 messages will be loaded at a time. 
  • If you scroll down, another 50 messages will be loaded. Thus continue scrolling to the bottom. 
  • If you get bored then delete the already loaded messages. Hit on the Select All button and press the Delete key.

Select & Delete All Messages from Yahoo Mail

  • After pressing the Delete button, you will get the following notificaiton.

Delete All Messages Notification

  • Hit OK to delete all the selected messages. 

If you just continue scrolling down for 2/3 minutes, I believe you will be able to delete more than 5000 emails at the same time. 


Thus if your inbox has more than 10000 emails, I don't think you need more than 7/8 minutes to delete them. :) 



Now look at my inbox below - 


Blank Inbox of Yahoo Mail


My inbox is blank. And there are more than 2000 mails in my Trash box. And it took a very short time to delete all messages from the Yahoo inbox by using the above method! 




Stay with Marks PC Solution to get more interesting IT topics!



How to Sign out of Gmail Remotely?


How to Sign out of Gmail account from a remote location

Your email account is as important as your cell phone. Even sometimes it's more important than a cell phone. Because it may contain lots of personal as well as official information. Once hacked, it could be really tough to get back. So, you should keep your email ID safe and secured. Today I'm gonna discuss about how to sign out of Gmail from a remote location. 



Background Story


When I was in college, during my graduation, I used to sign in to my Gmail account from Computer Lab. And I used to select the Remember me option for quick login. One day, when I was working in my Gmail inbox, the electric supply interrupted. And I didn't have enough time to wait. So, I had to leave my account signed in to that browser. 


I was not sure whether the next user would get my account signed in or not. I was lucky that I didn't save my password. Otherwise anyone could see the saved password and access my account. 


However, there was nothing to worry about! Because Gmail has a great way to sign out of all other sessions except the current one. And you can also change your password any time. 






You may need to sign in to your Gmail account from different locations. Suppose your friend's PC, cybercafe, library, cell phones or any other public places. By mistake, if you forget to sign out, your account might be unsafe. Or if you lost your cell phone with Gmail account signed in, then what? Simply sign out of all other sessions from your Gmail inbox. 


Account Activity

If you need to sign out of all other sessions, then you have to go to the Account Activity options from your inbox. Account activity is available at the bottom of your inbox. If you're using basic HTML view then you will get the account activity as below:


Last Account Activity in Gmail

Look at the red mark. Last account activity. And look at the yellow shade - Detials. Hit on the details button to view your activities. And if you're using the standard view of Gmail then it looks like as below -

Last Account Activity in Gmail

And this will be located at the bttom right corner of your inbox. After hitting the Details option, you will be redirected to a new page named Activity on this Account. Look at the image below:


Gmail Account Activity


Since my account is not open anywhere, it shows - This account doesn't seem to be open in any other location. If there is any unusual login detected, it would show different message. 

Now look at the button - Sign out of all other sessions. If you hit on this button, your account will be automatically signed out from any devices/ sessions except the current one. If you're signed in into your mobile, it will also be signed out. 

Also look at the Recent activity table. It shows from where your account has been accessed, with location, IP address, date/time and duration.  


Hopefull this will be really helpful for you to keep your Gmail account safe. Facebook has also  similar option. You will get it from settings. 


Stay with Marks PC Solution to get more interesting IT topics!


Troubleshoot Program Compatibility in Windows 8


Troubleshoot Incompatible Programs in Windows 8


Just from the beginning, Windows 8 got a lot of problems to be solved! You know I've discussed about .Net Framework 3.5 , My Computer Icon, Windows 8 Tiles, Activation Procedure etc. And I've also discussed about new features of Windows 8, it's advantages and disadvantages. But somehow, I've skipped the program compatibility issue. Though it's too late to write about, but in this post I would like to discuss about program compatibility troubleshooting. 


Actually, Program Compatibility is not a new term at all. Perhaps it starts when Windows Vista came in the market. In that time, programs made for Windows XP or 98 wouldn't work fine with the new version of Windows. And the same problem is still being faced by the users of Windows 7 or 8. 


Well I don't like to use the term Windows 7 here. I will just use Windows 8 in this tutorial. And hopefully this will be also helpful for Windows 7 users to troubleshoot program compatibility. 


Background Story:

Few years ago, when I've installed Windows 8 for the first time on my PC, simply I got puzzled. In every point, there was a problem. One of them was program compatibility. A program that worked fine with XP or 7, didn't run on Windows 8! But I hardly wanted to back to the older version of Windows. 

Let me show you an example - 

I was in trouble while opening Adobe Photoshop CS5 (Portable). I got a message - Incompatible Program. 

And I solved the problem using troubleshooting option. 



Troubleshoot Compatibility:

When you can't run or open an incompatible program in Windows 8, follow the steps below:


Compatibility Troubleshooting option at the right click

  1. Click right mouse button over that program (Should be .exe file). 
  2. Choose Troubleshoot Compatibility.
  3. Select Troubleshoot Program.
  4. Now mark the problem(s). 
  5. I usually choose - The program worked in earlier versions . . .
  6. Now select an OS on which the program works fine and press Next.
  7. Test the Program and press Next.
  8. If it runs properly, Save the settings and close the window.

Compatibility Mode:

Another way to make programs compatible is using the Compatibility Mode. Look at the image below:


Program Compatibility Mode in Windows 8

This option allows you to run a program in compatible with a particular OS. Follow the steps below: 
  1. Right click on the program and choose Properties.
  2. Move to the Compatibility tab.
  3. Go to the Compatibility Mode.
  4. Mark the option - Run this program in compatibility mode . . . 
  5. Now select an OS in which you ran the program earlier.
  6. You can also change the screen and color mode if you need. 
  7. Choose Run as Administrator if necessary.
  8. Hit Ok. 

Program Compatibility Troubleshooter

The previous two methods are manual. But you can also use the automatic detection system. This troubleshooter will find the incompatible program in your PC. 



List of Programs in Compatibility Troubleshooter

  1. Press Start and Type Program Compatibility.
  2. Choose Settings and hit on Run programs made for previous versions of Windows.
  3. Troubleshooter will open. Press Next.
  4. Now you will have a list of the programs. Choose one that gives you trouble. 
  5. Press Next > Troubleshoot Program > Choose an option > Press Next > Select your OS > Test the Program > Next > Save the Settings > Close the Window.
Note: Steps could be slightly different depending on the program types.


Remember, you can run the troubleshooter as Administrator. You can also apply automatic repairs. Just after running the troubleshooter, hit on the Advanced button to get these options. 

Stay with Marks PC Solution to get more interesting IT topics!


Convert PPTX to PPT Online!


Convert PPTX to PPT Online


Hey Guys! Stil using the old version of Microsoft Office? Office XP or 2003? Then you could be trapped several times! Because Office 2007 or later versions save your file with extension x. Such as docx, pptx, xlsx. Last year I published a post about how to convert DOCX to DOC Online. And this time, I am gonna show how to convert PowerPoint files - PPTX to PPT Online! 


Actually I've found a nice tool for you. With this tool you can convert your files within this page! Look at the online converter below. You just need to upload your PPTX file to convert. 



Convert PPTX to PPT Online!







Hopefully you can easily understand the procedure. Or follow the instruction below:

  1. Hit on the Choose File button.
  2. Now locate your PPTX file from hard disk and select it.
  3. Hit on the Convert PPTX to PPT button. 
  4. You will be redirected to a new page. (It may take few seconds)
  5. Open or Save your file from there. (Look at the image below)

Open/ Save Converted PPTX file




Remember: This site doesn't store your converted file. And it will be removed permanently after 1 hour. 


What else you need? 

Do you need to convert more files? Multiple file formats? Instant Document conversion has everything you need to convert! 

  • DOCX/ PPTX/ XLSX/ TXT
  • ZIP/ RAR/ PDF
  • JPG/ PNG
  • HTM/ HTML/ PDF
There are more than 150 conversion formats! Can you imagine? 





Note: I've tried for 20 minutes. But couldn't find the main page of the site. The URL changes with every conversion type. When I open PPTX converter, it shows  pptx2ppt.com. And when I choose DOCX converter it shows docx2doc.com. And when I go to PPTX to DOCX, it starts with pptx2ppt.com. That's why I can't directly share the site URL. There is no home/ main page!!


Stay with Marks PC Solution to get more interesting IT topics!


Create New Volumes without Partition !!


Shrink Drives to Create New Volumes

Disk Management is a nice tool to manage your hard disk drives. With this tool, you can easily format, shrink and extend your existing volems. You can do some other tasks too. But today I'm gonna discuss about creating new volumes by splitting existing volumes. 


Background Story

Two weeks ago, one of my acquaintances got a new laptop. It comes with Windows 8, Intel Core i5 processor and 1 TB Hard disk. Not very extraordinary nowadays. But I was really surprised when heard there is only 1 partition in his laptop!! Can you believe it? One partition for a 1 TB hard disk! My goodness - this is a thousand GB partition! 

I know how to split a drive to create new partition. But didn't even try this earlier. After getting the case of 1000 GB partition, I tried to shrink a drive in my own PC. After successfully trying this on my PC, I advised him how to divide the one partition into several drives. By this time maybe he has fixed this. :) 


Supported Versions:

Disk Management tool is same both in Windows 7 and 8. Windows XP may have the same advantage but I'm not sure. If XP users has any problem, you can inform be through comments. 


Create New Volumes Without Partition - No Restart! No Interruption!!

Make sure you're the Admin of your PC. And right now you're logged in as Administrator. Now start -
  1. Right click on My Computer icon from desktop. (How to show My Computer icon on desktop)
  2. Hit on the Manage option. 
  3. Computer Management window will appear. 
  4. Choose Disk Management under the Storage option from the left pane. 
  5. Here you will get the list of your volumes with capacity and free spaces. 
  6. Right click on the drive you wanna shrink.
  7. Select Shrink Volume and you will get the below window.
Shink Size Before and After

Here you will get the total size before shrink. Now enter the space to shrink. Simply count the 1000 MB for 1 GB. In the image I've used 5000 MB for 5 GB. Then check how much you will have in the drive after shrink. Before proceed, make sure everything is okay. 

Now Press Shrink > You will get the following image > Right click on the Free Space > New Simple Volume > Pres Next > Enter Simple Volume Simple > Next > Assign Drive Letter (Suppose L) > Format the volume (Choose format type, label) > Next > Finish.

Within few seconds, you will get a brand new drive! 

Creating New Volumes by Disk Managment

How to Get it Back? 

Suppose you made a mistake. Or you were just trying to do it. But don't want to divide the volume actually. How do you get the new volume back to your old volume? Very simple!
  1. Right click on the new volume.
  2. Choose Delete Volume.
  3. You will get the above image again. 
  4. Now right click on your old volume and choose Extend volume. 
  5. Press Next > Next > Finish. 

This procedure doesn't require any restart. Even you don't need to close any program running on your PC. It's fast, simple and reliable. 


Precautions:

While running this operation you should be very careful. Though this tool is safe to use, but you may lose your data for any wrong command. Suppose, you may delete a volume which contains your valuable files. Or you may format an existing partition which contains important data. So, before making a click, be sure you're really doing the right job. 


If you have any query, don't forget to leave a comment . . .


Related Topics:


Stay with Marks PC Solution to get more interesting IT topics!


Tell Google when your Site's URL Changes


Tell Google When your Site Moves


More or less, all internet users are informed about the URL (Uniform Resouce Locator). A URL is simply the address of a site in internet. With the help of URL, you can directly access to a particular site. While general people just need to know the URL only to access a site, webmasters have to perform lots of tasks with it. 

Webmasters need to create thousands of links through URLs. Time to time they need to check the site's status through URLs. But these are not my concern in this post. Today I'd like to discuss about how to inform Google when you change your site's address. 


When a site gets a new address/ URL, definitely it loses social sharings. All backlinks of the site will also be lost. And search engines will not entertain that site as before. Because you're simply a stranger to them! Search engines even don't know about your site until you submit it for indexing.


But Google Webmaster Tools allows you to tell Google when your site moves to a new domain or URL. You can do this through Change of Address option. But there are some preconditions you must fill up:
  • You should have sufficient knowledge to handle Google Webmaster Tools.
  • Both your old and new sites should be added and verified in Google Webmaster.
  • Make sure your original site is not a subdomain. (ie. munnamark.blogspot.com)
  • Your new site shouldn't be a subdomain. (ie. markspc.blgospot.com


Advantages of using this Tool

  • You can easily recover your search ranking position.
  • It's safe. Because only verified site owners can use it.
  • Google will index your site quickly.



Google Webmaster Tools - Change of Address

Instruction:
  1. Sign in to your Google Webmaster account.
  2. On the Homepage, click on the site that you wanna work with.
  3. Click on the drop down arrow by the side of Gear icon (Look at the above image).
  4. Select Change of Address
  5. After completing steps 1 - 3, click Select a verified site (Your new site). 
That's it. Changes will stay in effect for 180 days. 


Troubleshooting:

If your new site doesn't appear in the Select a site, make sure - 

  • Both of your sites are added and verified in Webmaster Tools.
  • Both the sites have root level domains, not a subdomain. (ie. www.example.com)
  • You haven't already requested for change of address. 

For more details, please read Webmaster Tools Help - Tell Google when your site moves . . .


Stay with Marks PC Solution to get more interesting IT topics!


Windows Easy Transfer: Backup & Restore Your PC!


Back up and restore your files through Windows Easy Transfer


Windows Easy Transfer allows you to transfer files from old PC to new PC. Suppose you're upgrading from Windows 7 to 8, you can easily back up your files and restore them to the new system. Or if you have any plan to change your system unit, you can easily back up your files through Easy Transfer. Later you can restore your files to new PC without affecting your prior settings! 


Applies to:
  • Windows 7
  • Windows 8

Windows Easy Transfer:

Current generation is too fast. Changes occur within seconds. Computer world is much faster. Hardware technology is being changed to meet the demand of software manufacturer. Consequently, consumers need to upgrade their system frequently. 

While upgrading your system, you must face difficulties to back up your files. Considering this issue, Windows has an easy way to back up your files - Windows Easy Transfer.


Transfer User Accounts, Documents and More by Easy Transfer


Here you can see what is possible with this tool. You can transfer -
  • Settings
  • Files
  • Documents & more . . .
You can also customize what to back up and what not. 


There are mainly two thing you can do. First, you can back up your necessary files and settings. And second, you can restore them in a new PC. You can also back up your files for the purpose of future use. Later it can be used if your system crashes unfortunately. 


How to Back Up? 

If you're currently using the old PC and want to transfer the file to a new PC, then follow the steps below:
  1. Press Start & Type - Windows Easy Transfer, Open it.
  2. Welcome Screen will appear > Press Next.
  3. Choose Transfer Media - Easy Transfer Cable / Network / External Hard Drive or Flash Drive (Most people use Hard Drive or USB Disk) 
  4. Select This is my old PC.
  5. Wait for the Scanning process to be finished > Press Next. (You can use the customize option to manually choose the files)
  6. Type password to protect the files or leave it blank if not necessary > Press Save.
  7. Choose the destination and save it. (It could be an external hard drive, USB flash drive or any of your internal hard drives) 
  8. Press Next & Close. 
Remember, the above steps are applicable for External Hard Disk/ USB Flash Drive only. If you wanna back up using network or cable, then you need to connect both PC either by network or by easy transfer cable.
Note: If you transfer the files using network or transfer cable, the process will be completed immediately. But it is recommended that you use flash drive or hard drive if you like to keep them for the future use too. 

How to Restore?

The restoration process is somewhat similar. 
  1. Open Windows Easy Transfer as before > Press Next.
  2. Choose External Hard Drive as media.
  3. Select This is my new PC > Hit on the Yes button (If you already have a back up of your previous Windows as mentioned in the How to Back Up)
  4. Locate and open the previously saved file. 
  5. Hit on the customize button if necessary. 
  6. Finally hit on the transfer button to restore your files, settings and documents. That's it!

Stay with Marks PC Solution to get more interesting IT topics!