Showing posts with label in. Show all posts
Showing posts with label in. Show all posts
Sunday, October 16, 2016
How to Print Headings on Every Page in Excel
How to Print Headings on Every Page in Excel
Sometimes you may need to print same column headers on every page in Microsoft Excel. And to do so, you dont need to manually copy the headers on every page. You can simply set a command from page setup option to print column headers on every page automatically!
In my previous post, I discussed about how to lock or freeze column headers. By freezing rows or columns, you can just show headers at the time of scrolling. But they will be printed on the first page only. In this tutorial, you will learn - how to print same column headers on every page automatically . . .
Applies to:
- MS Excel 2000/ XP
- MS Excel 2007/ 2010/ 2013
Note: This tutorial has been prepared using Excel 2013. So, few options may differ slightly.
Lets start -
- Open a previously saved worksheet or create a new one in MS Excel.
- Go to the Page Setup option from Page Layout Tab (Office XP/ 2000 users should find it under Edit Menu).
- Go to the Sheet tab from Page Setup.
- Look at the Print titles option: Rows to repeat and Columns to repeat.
- To repeat the headers at the top, click on the first one. Or click on the second one to repeat the columns.
- After clicking the box, select the area of your sheet which needs to be repeated. Follow the image below.
- Hit OK to close the Page Setup. Done! Now check by printing or look at the print preview.
Here I showed the process for rows only. You can also choose columns to repeat by the same way. And Ive also uploaded a same sheet for you. Download the sheet from the link below:
Download Sample Sheet - Rows to Repeat
Open the above sheet. You will find a worksheet named Rows to Repeat. Ive set top 3 rows to be repeated on every page. You can directly check it by printing this two-page worksheet. Or simply check it in Print Preview.
Hopefully, todays topic will be helpful for your study or office work . . . :)
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Monday, October 10, 2016
Hide Spelling Grammar Errors in MS Word
Hide Spelling Grammar Errors in MS Word
When we type something wrong (typo) in MS Word, either in terms of grammar or spelling, the Spelling & Grammar Checker automatically detects the errors. And then we see a red underline for spelling error and blue underline for grammar error. And thats pretty useful and essential for preparing a correct document.
But sometimes, this automatic error detection marks may cause your headache. Maybe youre preparing something which is correct but not supported by traditional spelling and grammar rules. In that time, those error marks (red and blue underlines) look odd. Lets hide them!
Applies to:
- Office 2007
- Office 2010
- Office 2013
- Office 2016
Hide Spelling & Grammar Errors . . .
- Open up an MS Word document from your PC.
- Hit on the File button from upper left corner & select Options.
- Now choose Proofing option from the left pane.
- Scroll down to the bottom and find the Exceptions for section.
- If you wanna hide the errors for all new documents in the future then choose, All New documents. Or simply choose Document 1 or your current document.
- And finally, select the checkboxes - Hide Spelling Errors & Hide Grammar Errors > OK.
Note for Word 2007 Users:
File button is only available for the users of Office 2010, 2013 and 2016. Office 2007 users will see a different button instead of File button. Its called Office button as shown below -
And instead of options, you will see Word Options.
Rolling Back this Settings . . .
If you wanna back to the previous settings, I mean, if you wanna see the spelling & grammar errors again, then follow the steps below:
Rolling Back this Settings . . .
If you wanna back to the previous settings, I mean, if you wanna see the spelling & grammar errors again, then follow the steps below:
- Go to File > Options.
- Choose Proofing.
- Deselect the checkboxes > Hide Spelling Errors > Hide Grammar Errors.
- Exceptions for > Choose All New Documents or current document as applies.
- OK
Special Thanks to - Shamsul Arefin
Who phoned me to know why dont spelling mistakes is underlining in his word document. Actually in his word settings, spelling and grammar error options were turned off. And in this tutorial I just wrote about the opposite settings! :)
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Sunday, October 9, 2016
Best 8 Apps Gallery Locker App For Android In 2015
Best 8 Apps Gallery Locker App For Android In 2015
Best Android Apps And Gallery Lockers.
1. AppLock
AppLock is one of the most popular Android App available on Google Play Store for free. It provide you the facility to secure your phone Application and data with password. You can only access the Applications if you know the correct password. It also provide the facility of pattern lock to different App with different background colors . It have Approximately 1 million users and support 24 different languages.
2. SmartLock
SmartLock is another Android Locker which is available on Google Play Store for free. It can lock phone inbuilt App as well as installed Apps. Its media tab show all the media files like audio, video, photos etc allow you to lock them. It can also lock USB storage and phone auto screen rotate. It also provide support for Android Lollipop version. Approximately 5,000,000 users install this App. It allow both pattern and key lock.
3. Perfect App Protector
Perfect App Protector is another popular Android App to protect your data and App which is available on Google Play Store for free. We can not delete an App before unlocking it. It also provide a unique feature that make it distinct from another Apps that is Stealth mode. In this mode an App become complete invisible from launcher. It allow you to lock any App with Pattern, Pin or gesture. It can also display fake messages when locked App is launched. Approximately 5,000,000 users install this App.
4. Smart App Protector
Smart App Protector is another Popular Android Apps which allow you to lock Gallery and installed phone Apps. It provide simple and easy to use interface. It is available on Google Play Store for free. You can lock the Apps with pattern, Pin and gesture. This App monitor unlocking the of Apps and on failed capture the screen shot of intruder. Approximately 7,000,000 users install this App. It also allow lock App using multiple passwords.
5. Vision App Locker
Vision App Locker is popular and smart Android Application that is available on Google Playstore for free. This App locker provide a smart feature that make it distinct from other locker. We can use our face us a password to unlock any App. You are also required to provide a password in case of face recognition failure. It support both pattern and pin lock . We can lock Gallery and other inbuilt phone Apps, installed Apps. Approximately 1000,000 users install this App.
6. Safe Gallery
Safe Gallery is another Popular Android App which allow you to protect your Gallery App and Gallery media files. It is available on Google Play Store for free. With help of this App we can manage this Gallery and it allow to protect our data with Pin, Pattern etc. It allow simple and attractive interface. It support 4 languages including English. You do not need to worry about your data with the help of this App.
7. Gallery Lock
Gallery Lock is another Android locker which is available on Google Play Store for free. It also Support stealth mode that is you can hide a launch icon. We can share picture with Gallery Lock to any other App. It also support cloud backup to Google drive, dropbox etc. It allow the three attempt to open the Gallery after three failure it capture the image of Attacker. Approximately 10,000,000 users download this App.
8. Secure Gallery
Secure Gallery is an awesome Gallery locking App which is available on Google Play Store for free. It can hide picture and videos in the Gallery. It provide attractive and user friendly interface. It also support the stealth mode. It provide easy Gallery management. We can change the background of Gallery. It also provide image viewer and slide show for images. It support both pattern and Pin lock. Approximately 5,000,000 users download this App.
Go to link download
ow to solve unsupported chip by volcano in sy way!!
ow to solve unsupported chip by volcano in sy way!!
Again Same Answer
not supported yet in regular free update
see and poll
just wait
You Guys want mtk6261 and mtk6571 For Free ?
Go to link download
Thursday, October 6, 2016
Creating Custom Brush in Illustrator
Creating Custom Brush in Illustrator
Adobe Illustrator can be compared to a programming tool in that sense, it provides a lots of ways to customize your graphics works. It provides so many designing options which you hardly get in other graphics tools. In this lesson, you will learn how to create amazing brushes within few minutes!
Today Im gonna talk about how to create custom brushes - Scatter Brush, Art Brush & Pattern Brush. After creating these brushes, you can use them as borders for different shapes such as triangle or oval etc.
Note: This tutorial applies to all versions of Adobe Photoshop. However Ive prepared this tutorial using Illustrator CS6.
Okay lets start -
Run Adobe Illustrator from your PC. Now look at the tools panel and find the Paintbrush Tool (See the image on the left). I will create two little objects with this tool which later will be used to create awesome brushes.
Go to the File Menu > New > Create a new document of any size.
Hit on the Paintbrush Tool and draw an object (I sketched something like a leaf) as shown in the image below.
- Now select it through selection tool
- Press Alt key and drag it to create a copy of it.
- Now select the second leaf again and rotate it, place it over the first leaf so that they look like attached.
- Again select the first leaf > Double click on Fill Color from the bottom of tools panel > Choose Red.
- Similarly, select the second leaf and choose green color for it.
- It should look like as below
Now the first but the difficult part has been completed. Now youre ready to have fun in the next step.
Creating Brushes
You will be able to create brushes from the above leaves. First, make sure the brush window is open on your document. Or go to the Window menu and choose Brushes.
- Select both leaves through selection tool
- Go to the Brushes window and click on New Brush Icon (Look at the image below)
- Choose Scatter Brush > Rename it if necessary > Change the values of different fields if necessary > Hit OK
- Again choose New Brush (Leaves must be selected) > Choose Art Brush > You can change the size and direction > Hit OK
- Click on New Brush again > Choose Pattern Brush > Hit OK
- Now youve three custom brushes. Lets apply them :)
Applying the Brushes to Shapes
Before creating shapes, make sure your fill color is white. So that you can clearly understand the effects of different brushes.
Now choose Ellipse Tool (Oval) from the shape. Press Shift key and draw a circle. Now go to the brush window and Apply your newly create Art Brush. The circle will look like as below!
Create another circle. And this time you should test the pattern brush.
How is it? :)
In this way, you can also apply this trick to different shapes such as triangle, star, rectangle etc.
Here Ive just illustrated a simple example of customizing the brush. In this system, you can create numerous brush designs. And can you imagine how much designing options are available in whole illustrator? Simply Ive no idea. There could be millions!!!
It takes my whole evening to prepare this tutorial. Please inform me whether you like it or not. :)
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Using Curve Tool in MS Word
Using Curve Tool in MS Word
Most of you may think that MS Word has no free drawing tool like Photoshop or Illustrator. But youre wrong! Word has also a free drawing tool named curve which you can use just like Photoshop Pencil Tool. With curve tool, you can draw shapes freely.
Applies to:
- Word 2007
- Word 2010
- Word 2013
Where do I find Curve Tool?
In fact, Word doesnt consider curve as a tool. Though its a drawing tool, Word names it as a shape. You will find the curve in the Shapes.
Insert Tab > Illustration Section > Shapes > Curve 
.
. How to Use it?
Its very handy to use the curve tool. To use the tool, run MS Word. Then choose curve from the shapes.
- After choosing the curve tool, click anywhere of your document to start drawing.
- Move your mouse to the left, right or top from the starting point.
- Click left mouse button where you wanna turn around.
- If you would like to stop drawing and keep the shape open, simply click twice.
- If you wanna keep the shape close, simply click on the starting point.
How to Edit the Shape?
You can also edit the shape made by curve tool. After drawing the shape, if you think that you need to change the shape a little, you can edit the points of that shape.
While drawing the shape, you clicked mouse several times. Those clicks are shape points. If you would like to edit the shape points, right click on that shape and choose Edit Points 
option.
Now you will see the points. Click on the points and adjust them by dragging.
Designing the Shape
After creating the shape, you can design it like other shapes. You can choose different fill color, outline or give it special effect from the Format tab.
Curve is also Available for -
option. Now you will see the points. Click on the points and adjust them by dragging.
Designing the Shape
After creating the shape, you can design it like other shapes. You can choose different fill color, outline or give it special effect from the Format tab.
Curve is also Available for -
- Excel: Insert > Illustration > Shapes > Curve
- PowerPoint: Insert > Shapes > Curve
- Outlook: Insert > Shapes > Curve
Hope you have understand todays topic properly. If you have any query, please leave a comment . . .
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Increase traffic in your blogger blog or in your website very fast
Increase traffic in your blogger blog or in your website very fast
Today I will show you how to Increase traffic in your blogger blog or in your website very fast.The main aim for making the blog on blogger is to getting traffic on the blog and there are many ways to get the traffic on your site. Its very easy you have to keep updating your blog and do some work onsocial media and linking and you will get your traffic after the time passed.
Here i am showing you some major techniques which allows you get maximum traffic to your blogger blog. You just have to do some little work on it.
There are many sources that you can increase the visitors to your site but here i am showing you the ways that not only enhance your traffic but also cause to increase your site visibility on search engines. here they are,
- Facebook page and group posting
- Yahoo answers and groups
- Tumblr, twitter and other social media post
- Guest post on your related niche sites
- Google adword traffic
- High traffic blog comments
- forum posting on high PR
- Google plus traffic
- Press releases, news and classified submit
Facebook Page and Group Post:
As everybody know the importance of like on Facebook and its traffic, You must make an official page of your site on facebook, Add it on your site to like your website page, Go and search facebook groups join the groups which has more then 20,000 members and post your website on it. This way you will get many visitors to your site for free.
Yahoo Answers and Groups:
Yahoo answers and groups are also best place to get traffic to your website you can enhance your site links and visitors by using this method, You must post your site where its relevant to it. Like if your site is all about fashion then you have to link it to fashion topic question or groups in yahoo, It will also increase site performance.
Twitter Tumblr and other social network:
You should also make some profiles on twitter, tumblr and other social networks like Xanga, Linkedin. Delicious, Pintrest and many more. On that point you will also get little but traffic but its increase your site ranking in Google search engine and you will got many powerful visitors to your site. If the social points not bring the visitors then it really cause to make you better in search eyes.
Guest Post on Related Websites:
Thats the most powerful way to get instant traffic to your website if you find some related to your niche sites simple contact them and ask that you have some good articles and want to publish on there website, If you article is good and enough you got approved, Now simple in article foot add little description about your site and article writer, Thats it when someone reads it they surely get involved in your site while clicking on the link that you leave on the footer of article.
Google Adword Traffic:
There is also another way to get the target traffic to your website, you just have to add a campaign toGoogle adword which is pay method to do, you have to pay per click on your site to get traffic, this is fully target traffic, you need to put the keywords and some description to add the profile, minimum you can get 0.02$ per click to your aid.
Blog comments:
At this time even blog comments comes into the spam category in google eyes, but still you can get better traffic from it, Some high pr blogs and high level alexa traffic rank sites you can get better traffic for you. Sites like moz.com/blog, techchrunch, mashable, and other major sites still bring some better visitors to your website. Just try to get it. Must leave relevant comment to get faster approval.
Forum Posting:
Forums are also better way to get targated traffic to your site, if you are good internet searcher you can try to find top alexa rank forums where the traffic should be huge, can also incrase your site traffic. I would like to show some sites like skyscrapercity.com, forums.seochat.com, forums.digitalpoint.comare most common and well know websites. you can try to get post your site link in thread reply.
Press Release News Classifieds:
You should try to get post on press release sites like prlog.com, pr.com, and sbwire.com these are the most powerful sites or you have to search in google for top press release websites and then post you information on it.
You can also bring some serious visitors from classifieds websites, you should post some classifieds on ebuyclassifieds.com craiglist.org and gumtree.com and some other high traffic websites. With this way you can also get the better traffic to your website.
Go to link download
Wednesday, October 5, 2016
Alexa Ranking Under 100 0000 in Just 1 Month
Alexa Ranking Under 100 0000 in Just 1 Month
How Can I improve Alexa Ranking
My Method to lower Alexa ranking
Content-
The first thing that matters is Write Useful and Qualitative Content on your blog. Always try to post relevant topic that I feel people would enjoy reading about [Related to your niche] which the visitors like to read. Use proper Images, Heading tags & Sub headings, Bullets Numbers lists etc. To make it more reliable for readers.
SEO-
Search engine optimization is the backbone of any blog. You must do proper on page optimization of your blog i.e. Add long tail keywords, add meta description to your blog posts, Add keywords in ALT tags, image caption to your blog post images etc. Share post in all social media like Facebook, Twitter, Google plus etc. Submit article directories. This will help you in driving more and more organic traffic i.e Traffic directly from search engines.
Traffic-
Alexa ranking of websites totally depends on the basis of the traffic and resources of traffic. So, Try to drive a lot of traffic you can to your blog by any means. And you will see a good amount of increase in your Alexa ranking.
Backlinks-
Alexa Consider backlink as a + point to increase ranking. Try to build backlinks as much as by Commenting on Do follow blogs in the same niche, Guest Blogging on Blogs which have high PR and Alexa rank, DA etc. And I’m sure that your Alexa rank will increase.
These are my methods to lower Alexa rank below 1 million in just 1 month! If you find the article informative share it with your friends and if you have any Query please feel free to comment below!!!!
Go to link download
Sunday, October 2, 2016
how to reinstall windows xp in acer aspire one netbook without cd
how to reinstall windows xp in acer aspire one netbook without cd
actually this procedure is just setting to factory your acer aspire one netbook. but at least you will not need any cd.
1. power off your netbook.
2. press power ON, then alt+F10.
3. then you will be presented with the screen asking you to restore to factory settings.
4. click restore factory settings.
5. and the restoring will proceed as shown below.
6. after finish the netbook will continue with a series of reboots (installing drivers).
7. this is the finised product.
note1: this netbook is in arabic, somewhere in the netbooks reboot, it will ask you for the language, here you can choose your preferred language,
and since the owner wants it in english, we change it to english.
note2: this does not need any cd, we use the recovery partition, which is activated when you press Alt+F10.
note3: the good thing here is that you will not need any drivers for the hardware, it will automatically install all the drivers that where previously installed in the netbook, including the wifi, bluetooth, and sound.
note4: another good thing is the windows xp installed is legit and not pirated.
Go to link download
Racing in Car Get Real Driving Experience!!
Racing in Car Get Real Driving Experience!!
Ive shared several posts on bike racing. And today Im gonna share a car racing game for Android users! This game will give you real driving experience - believe me! With accelerator and brake pedal, this game is really interesting.
About the Game . . .
- Name: Racing in Car
- Version: 1.1
- Rating: 4.5
- Game Type: Racing
- File Size: 32 MB
- File Type: APK
- Offered by: Fast Free Games
System Requirements
- Compatible with almost all running versions of Android
- At least 500 MB RAM (1 GB recommended)
Features
- Easy to control and drive
- 3D realistic cockpit view
- Automatic steering when you tilt the device
- Simulation type
- Accelerator & Brake pedal
Download > Install > Play . . .
- Get the APK file from this link.
- Find the file from your storage and tap on it.
- Allow installation from unknown sources if it asks for.
- Wait a few seconds during the installation procedure.
- After installing the game, get it on the App list. Tap on the game icon to play it.
Tips
- Maintain your lane
- Get closer to earn point
- Use brake in case of critical situation
- Avoid getting closed if you wanna survive for a long time
Hope you will enjoy driving and racing . . .
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Saturday, October 1, 2016
Tutorial How to write IMEI in All SPD Phones having P 05b Connector
Tutorial How to write IMEI in All SPD Phones having P 05b Connector
How to write IMEI with VolcanoBox
in All SPD Phones having P-05b Connector
Before Repairing IMEI, User must follow these -
User must have Win Xp (Service Pack 3) for best results
Install Correct Drivers for your handset.
If you dont have correct driver, then download from below links -
SPD Android Usb Driver for win7/win8 (64bits)
SPD Android Usb Driver for winXP/win7 (32bits)
SC6530/6531/6610 New Usb Driver for win7/win8 (64bits)
SC6530/6531/6610 New Usb Driver for winXP/win7 (32bits)
Now Make These Settings -
* Go to Detect tab & Select [D+/D-]SPD/Anyka in Detect Type.
* Manually put pinouts (Pin2= D- Pin3= D+ Pin5= GND) as given below -
* After putting pins like this, Connect Handset on Volcano Main Cable.
* Attach Power cables also & Press "Set Pinout" button.
* After Pinouts Setting Complete, Remove Cable from Box Socket (Dont Remove Cables from Handset)
See in pic below -
Now do as stated here -
in All SPD Phones having P-05b Connector
Before Repairing IMEI, User must follow these -
User must have Win Xp (Service Pack 3) for best results
Install Correct Drivers for your handset.
If you dont have correct driver, then download from below links -
SPD Android Usb Driver for win7/win8 (64bits)
SPD Android Usb Driver for winXP/win7 (32bits)
SC6530/6531/6610 New Usb Driver for win7/win8 (64bits)
SC6530/6531/6610 New Usb Driver for winXP/win7 (32bits)
Now Make These Settings -
* Go to Detect tab & Select [D+/D-]SPD/Anyka in Detect Type.
* Manually put pinouts (Pin2= D- Pin3= D+ Pin5= GND) as given below -
* After putting pins like this, Connect Handset on Volcano Main Cable.
* Attach Power cables also & Press "Set Pinout" button.
* After Pinouts Setting Complete, Remove Cable from Box Socket (Dont Remove Cables from Handset)
See in pic below -
Now do as stated here -
Code:
Step 1 - Open Volcano tool and go to spd tab and (Enable IMEI Option)
Step 2 - Tick "Write IMEI" and Untick "Auto-detect pinouts"
Step 3 - Set R/W IMEI to "COM" and press RUN Button(New Tool will Open)
Step 4 - Select "USB" in ComP and Fill IMEI in boxes.
Step 5 - Press "Write IMEI" button
Step 6 - Now Connect the cable back to the BOX.
Step 7 - wait for 2-3 minutes..you see message "Write IMEI done".
Go to link download
Tuesday, September 27, 2016
Built in PDF Printer in Windows 10 !!
Built in PDF Printer in Windows 10 !!
Windows 10 has come with some new features. One of them is Built-in PDF printer - Microsoft Print to PDF. From now, Windows 10 users dont need to use any third party PDF creator for converting their documents to PDF files!
Applies to - Windows 10 Final Version only!
Those of you are still using earlier versions of Windows, I will recommend doPDF for you. Its a free as well as great tool for creating PDF documents from different applications. And you can also use doPDF in case when you think Windows Print to PDF doesnt work well for you.
Using Windows Print to PDF
This application lets you print documents virtually. Using this application is almost similar to using doPDF. It has no visible interface available. You can only use this feature in the print option of any application. Such as - Word, Excel, PowerPoint, Web Browsers, Photos even on Notepad.
This feature will be available for any application which has a print option. Lets find out how -
- Open any printable document (i.e. MS Word Document).
- Press Ctrl+P to view the print option.
- Look at the list of available printers.
- Choose - Microsoft Print to PDF.
- Choose Paper Size, Number of Copies, Orientation from Settings.
- Hit on the Print button.
- Type File Name > Choose your destination > Hit the Save button. Thats it!
Hope this new tool will be of great use. If you need any kind of help, please knock me . . .
Stay with Marks PC Solution to get more interesting IT topics!
Go to link download
Subscribe to:
Posts (Atom)