Photoshop! One of the best photo editing software's which probably need no introduction. Does it? Anyone who has ever taken the interest in editing images, putting effects on photographs, or changing backgrounds must be familiar with the software Photoshop!
But wait! Do you know how to use adobe photoshop? Do you know How to photoshop pictures? Or how to remove or add backgrounds to photoshop? If no, then probably the time has come when you will learn about the working of photoshop including some basic and very indigent uses of it.
So what are we waiting for?? Let's begin the tutorial and learn how to photoshop a picture?
How to Photoshop Pictures
As we all know photoshop provides hell lots of features including editing images, creating logos, photoshop for dummies, adding and removing backgrounds and what not. Infect photoshop is used as one of the professional tools for photo editing.
Now you might be wondering how it can be used to create logos, collage and more. If so, you will find your answer below as I have shared some of the intense uses of photoshop.
How to Make a Collage in Photoshop
The procedure to creating collage is given below. Follow the steps carefully and enjoy the collage of your favourite photographs!!
Step 1: The first and the crucial step is to select the images you want to create collage of. Yes! The more the quality of the picture would be, the more would be the chances of your collage to look beautiful.
Once you are done with selecting pictures, copy all and paste them to one place I mean folder. (The step is not essential but it will make your task easier for the further steps)
Step 2: After deciding the images, the second step is to decide the size of the collage. Here you will need to decide which size of collage you want. Like if you want collage for your home wall then you will need to choose that in inches and some decent size. And if you want a mini collage, just to update on facebook or other social media you will need to choose the size in pixel.
Step 3: Once done, open the photoshop and create the new file by clicking File> New and select the size of the collage. See the screenshot mentioned below.
As you can see in the above image, you have to choose the size. Or you can manually create the file by selecting the width and height.
Step 4: Ok, now open all the images you have decided to put in the collage and adjust places of each. Make sure you do it all on the new layer.
Press ctrl+T for rotating and adjusting the images. Apart from that, you can also use the feather and other effects to make the collage look better.
Once you are done putting images and effects over them, save the file in the jpg format and use that as per your suitability. Isn't making the collage an easy task??
Likewise, you can also make logos on it. Confused? Ahh, no need just keep reading the article and learn to make logos and uses of brushes in photoshop.
How to Make a Logo in Photoshop
Like I described in the above procedure, you will need to create a new file to create a logo. To create a genuine logo decide what kinda design you want.
Until you are sure and specific about the design, you may face trouble to create a decent looking logo. Everyone has their own creativity and sense of designing varying as per their demand. All I can do is to let you know some tools which can help you to create a logo.
Below I will share some tools and brushes for Photoshop that can be useful to you while creating the logo or any design.
Use these brushes and tools and create an awesome looking logo for your firm, institute or business.
Rectangular Marquee Tool (M): This tool is used to make selections on your image in a rectangular shape.
Move Tool (V): Move tool can be quite useful when you have to place image from one place to other. This tool is basically used to move the images.
Brush Tool (B): When you have created a basic design you can use the brush tool to look it more attractive.
Eraser Tool (E): When we are trying something new, eraser seems the most powerful tool. Considering, no need of describing the use of eraser tool, moving to the next step.
Blur Tool (R): However blur tool is used for blurring the images or to hide something from the images or design, but in the logo creation blur tool can be used to make log look even more attractive. Create a design and give a little blur effect to the particular place. You yourself will see the changes.
Text Tool: Without the text, Logo is incomplete. No matter how creativity you have put in the design, until you add some text above or below the design, logo is never going to look attractive. To write name or text all you will need to do is pick text tool and select the font.
Zoom Tool (Z): Pretty obvious what this tool does. It allows you to zoom into your design or the image. While creating the logo, it can also be helpful. And the last(Though, it's not the last but for this list this tool is a last one.) tool is:
Hand Tool (T): hand tool is used to move the object all over the window. If you’re zoomed in and your image area is larger than the window, you can use the hand tTool to navigate around your design. The method to use this tool is quite easy. Just select the tool and drag the image wherever you want to place it.
That's it! This how you can create any logo or edit the images. After reading the complete guide do you still have any query how to photoshop pictures? No right?
Image editing on photoshop, creating logos or creating beautiful collages depends on basically on your creativity and then practice.
Now enjoy photoshopping and share the guide with your friends!!
How to Insert a Line in Word?
How to Insert a Line in Word is one of the most frequent questions asked by Word users. Inserting a file between a word file is a common phenomenon. Adding borders and lines in Word is easier and just takes a few seconds. To segregate any line of text you can simply add horizontal lines to the file.
Not only it lends a neat look to the document but even makes it easier for the user to read and identify various segments in the text. How to draw a line in word is not as difficult as it seems to.
There are actually three or four different methods using which you can insert lines in Word. It all depends on your preference and the method which most appropriately matches your convenience.
Let’s take a detailed look at the methods on how to add lines in a word:
Inserting Lines with Shapes tool
It is a tool in Word that contains almost all geometrical shapes, be it rectangles, back arrows, lines, stars & banners, etc. Basically, any shape that is imaginable can be created via a Shapes tool. Take a look at how to add a line in the word:
- Open the MS office word file in which you want to insert the line.
- Navigate to the Insert tab. Click on the option Shapes and select the line shape.
- A plus sign will appear on your word document. Drag the mouse along this sign to get the required length of the line on the Word document.
- Click the line to open the “Drawing Tools” tab. As soon as it opens, see at the top to see the “Shape Styles” section of the ribbon. From here you can easily give colors to the line, change its thickness and shadow.
Now, in case you want to draw another line you can simply copy and paste the same line. Just press Ctrl + C to copy and Ctrl + V to paste.
How to Insert a Line in Word via Paragraph Tool
Word includes a built-in horizontal line feature to easily add lines. It quickly inserts a horizontal line in the document. Take a look at how to insert horizontal line in word:
- Keep the cursor where you want to insert it. Now, open the Home tab and in the Paragraph group, you will see a small square box and along with it a drop-down button. Click it.
- Select the option Horizontal Line and a line will be inserted in the Word document.
- Once a horizontal line is created, double- click on the line to select it. Format Horizontal Line dialog box will appear, where further adjustments related to height and width can be made and even color to the line can be added.
- In fact not only a Horizontal line, but you can also even add inside and outside horizontal and vertical borders via the same option.
Note- To remove or delete the horizontal line, just click it once and it will be selected. Now, simply press either the Delete or Backspace key.
Inserting Lines via Auto-Format
The best and the most convenient method to insert lines in Word file is by using the AutoFormat function. These are basically small tricks using which you can easily insert lines in your Word document. However, this trick works only on MS Word and MS Outlook.
When you type at least three dashes, underscores, or equal signs in a paragraph and press “Enter”, automatically a single, double horizontal line or a dotted line is formed, i.e. just by typing these characters and pressing Enter, the desired line will be formed.
Take a look at various such characters used to insert line in word:
- First of all, place the cursor where you want to add a line. Now, here enter any of the characters accordingly, and Press Enter. The line inserted will cover the full width of the page.
- Type three hyphens together (—) to form a single Horizontal line.
- Type three equal signs (===) to form a double horizontal line.
- Type three asterisks (***) to form a dotted line. (…..)
- Type three underlines (___) together, to form a broader and darker horizontal line.
- Type three tildes together (~~~) to form a tilted design line.
- Type three-pound or number signs (###) together, to form a bunch of broad and sleek horizontal lines.
Note- In case you add this line to the column, the line will cover the full width of the column.
Adding Lines between Columns
It is obvious that while writing any document, you display text in columns, instead of standard paragraphs. In case you want to add or draw vertical lines between columns, you can easily do it Word. Some people may prefer doing it via a Shapes tool, but there is a much easier way to do this.
Take a look at how to make a line in word columns:
- Place your mouse cursor on the text that you want to be displayed in columns.
- Choose Page Layout ribbon tab and select Columns. At the bottom of the list, choose More Columns.
- In the Columns dialog box, you can see an option called Line between. Tick mark the checkbox next to it.
- You can even adjust the column width and spacing between these columns via this box. You can specify the number of columns you want to use from the number of columns list.
- In the Apply To box, click the drop-down arrow and select This Point Forward. By doing so, the column will be inserted only where you have placed the cursor, and not in the entire document. Click OK.
Your text will be now displayed in columns with a line between each one. Adding a vertical line between columns in Word is easier and can be done by the above-stated method, easily.
Considering spacing via lines is usual while designing or formatting a document. It adds appeal to your document and makes it easier for your audience to read. Moreover, adding lines is really useful if you preparing a questionnaire, i.e. to be filled by the audience.
So, go ahead with the methods stated in How to Insert a Line in Word and pick any one method that appeals to you to add lines to the Word document easily.
How To Watch Netflix Offline?
Amazon launched offline videos somewhere around last September, so how could Netflix be lagging behind? Hence today just some hours ago they answered our age-old question, How To Download Movies On Netflix by officially launching Netflix “offline” feature.
Well, it's not like an “offline” app or something, but it does let you watch series and movies offline, without requiring an active internet connection!
And the best part is, we got some of our most favorite series on the offline list. Including Stranger things, Breaking bad and lots more.
So today after years of desperate waiting and rumors, our prayers finally were answered by the Internet Gods (if they exist) and hence we now know how to record and download Netflix Movies/Episodes offline. So bottom line, now you can watch Netflix offline.
- What is Netflix offline?
- What's needed to watch Netflix offline?
- How to watch Netflix offline?
- Advanced features.
- How to access the downloaded files?
- How to delete downloaded videos?
What is Netflix Offline?
Here's the official statement from the Netflix team about what exactly the Netflix offline thing does for you “many favorite streaming series and movies are already available for download, with more on the way.”.
So two things I can gather from this statement is:-
- Not “all” the movies and series are available to download offline right away.
- Some movies and series are available and more are being added, meaning soon almost the whole of the database or a majority of it should be available for offline download.
Series and Movies Included in the Netflix Offline Feature Right Now:-
- Stranger Things
- Breaking Bad
- Orange Is the New Black.
- The Crown
- You've Got Mad Men
- Paddington and Minions
- Kung Fu Panda 3
- And over a dozen others.
So from this list itself, I can say that all the movies and series on the Netflix offline available for download feature would be worth our time.
What's Needed to Watch Netflix Offline?
Well, it, of course, doesn't support “all” the OS and devices, but the good news is I'm sure 99% of you on this page already meet the requirements unless of course, you own a 2002 smartphone. (Did they even exist back then?)
At the moment, the following operating systems are required:-
- iOS 8 or 8+
- Android 4.4.2 or later.
And of course, you'll need to update your Netflix apps right now if you want to watch Netflix offline. How to download Netflix?
How to Update your iOS app for Netflix?
- Open “App Store”.
- Tap on the “updates” menu.
- Tap on “Netflix” in the menu and tap on “update”.
How To Watch Netflix Offline?
So okay finally down to the section you've all been eagerly waiting for. Here's How to Record Netflix Streaming Videos officially and legally!
Just Sign-in into your app on your iOS or Android device.
Tap the options button, and you'd see an “Available for download” option right above your TV shows.
This screen holds all the series and movies which are available for offline downloading. All you've got to do is, choose them and then click on the download button.
You should already see the new popup there telling you that now you can download that specific movie/ series offline.
Done! Once you do that, the downloading process will begin and you'll be united with your favorite shows momentarily (depending on your Internet connection!)
Netflix already stirred the world up with it's “watch offline” announcement no doubt, but they didn't forget to add some additional perks.
If you tap on the [bbuttoon] and scroll down to the “app settings” option, You get to a “downloads” heading.
This is where you can specify what quality you want to download the video in. Currently, two download qualities are available:-
- Standard:- The lower quality.
- High:- The highest possible quality you can download the file in.
This comes in handy in two conditions specifically:-
- If you have a lower disk-space on your cell, choosing a lower resolution would considerably bring down the size of the file, and hence you can enjoy your favorite shows without expanding your memory.
- If you're on a slower connection, bringing the resolution down also brings the size down, and the size in return speeds up the downloading process. Or at least, gets downloaded faster. It's, of course, easier to download 200mbs rather than 1GB, right?
How to Watch a Downloaded File?
Just tap on the options button in your Netflix account, and you'd see “My downloads” button right there along with other options.
This is the section you need to go to in order to access your downloaded videos and play them.
How to Delete a Downloaded File?
Of course, keeping a file there after you've finished watching it isn't wise, right? And as I'm writing this “How To Watch Netflix Offline” article anyway, I thought why not cover all the bases.
So well how would you delete a downloaded file?
Tap on the “Edit” button on the top-right corner of your “my downloads” section.
And then you'd see a red “X” button. Just tap on it and your video is gone!
Wrapping it Up:-
So yeah that was all I had on “How to Watch Netflix offline” folks. I made sure I covered almost all the possible aspects with “Netflix offline feature”.
But in case I missed something and you're stuck, do let me know. Also, I wouldn't mind if you decide to promote us by sharing this piece on your Social media profiles. (I'm sure your friends would always remember who bought them “Netflix offline” for the first time, right?)
How to Reset Windows Password Without an Installation CD
Password – one word with a huge meaning in our life nowadays, because daily we use lots of sites over the internet. To remember all login passwords is not an easy task but browsers are giving the facility to remember them. What, when you forgot your Windows Password?
Reinstall the Windows Copy? That's not a good idea because there are many ways to reset Windows Password. And right now you don't have the installation CD, in this case also there is no need to worry.
Today, I am gonna show you a tutorial on “How to Reset Windows Password without an installation CD”. So, below is the step by step guide on How to Reset Windows Password without an installation CD, just follow it and reset Windows Password easily.
Step by Step Guide on:
How to Reset Windows Password without an installation CD
Firstly, you have to download the Offline NT Password & Registry Editor and make a boot disk using ISO image which you have downloaded.
Boot your PC from the boot disk and you will see below image on your screen. On-screen, it asks if you want to select the first partition (Windows installed partition) then “1” is already selected, so just hit Enter.
The next screen will appear to choose the path to your registry. The default is fine don't need to change it, so just hit Enter.
Now, the screen will appear displaying Password reset and many other options, don't do anything because “1” is already selected so now also just hit Enter.
Here you will be prompted, whether you want to edit users or the registry. You want to edit user passwords, so hit Enter again.
Now, comes the main part and please don't hit enter again (Just Kidding). The screen will show usernames which are available on your PC, so you have to enter that username for which you want to reset Windows password and now you can hit enter.
The next screen will show some advanced options no need to worry because you have to blank the password by selecting the “1” option and that's probably been already selected so just hit enter and get reset Windows Password.
And now, you’ll have to save what you just did. So type an exclamation point to quit (or the “!” symbol), then type the letter “y” to save all your work. Now you can reboot your computer and of course, you will able to login into Windows without any problem.
The above is the complete guide on How to Reset Windows Password without an installation CD. If you face any problem in resetting your Windows Password then put your problem/query in below comments section via the comment form.
So, that we can help you to get rid of that problem as early as possible.
How to setup hMailServer
hMailServer – a Free Email Server for Microsoft Windows, used by Internet service providers, companies, governments, schools and enthusiasts in all parts of the world. hMailServer Webmail works on SMTP, POP3, and IMAP for performing outgoing and incoming mail services.
You can integrate hMailServer with Microsoft SQL Server, or you can make use of an external Microsoft SQL Server, PostgreSQL or MySQL database for the same. Features of hMailServer are it consists of multiple domains, auto-reply and forwarding options, Active Directory support, distribution lists, built-in backup, etc.
If you want to use hMailServer, then firstly download from here and after that, you have to Set Up Own Email Server. To setup hMailServer is a typical task, so today in this article I will give step by step guide on Setup My Own Email Server.
Step by Step guide on:
How to setup hMailServer
#) Connecting to hMailServer
Download hMailServer from here and install it to start setup hMailServer.
Open “hMailAdmin” (C:Program FileshMailServerbinhMailAdmin). A dialog box will be opened that allows you to connect to different hMailServer services.
Double-Click on the “localhost” to connect hMailServer. A small dialog box will be opened asking the password. Enter your password which you specified during the installation of hMailServer and click on “OK”.
If the password is correct then you have successfully started hMailServer Administrator.
#) Domains & Accounts
Now you have to specify your domain name for which you have to setup hMailServer.
From the last opened window, click on “Add Domain” or you can also start “hMailAdmin again”.
Enter your specific domain. As example, I have inserted “technobol.com” and click on save.
Now, you have to specify your email address on which you will receive and send an email. For that, Expand the Domains node in the tree to the left.
Click on your given domain name and click on “Add Account”.
Now, enter “webmaster” or “info” or you can put any name as per your choice in the Address box, set the password and click Save.
Now, in the tree to the left, you will find your Account and Address both.
#) Specifying the public hostname and SMTP relayer
For the working of hMailServer, you have to specify the public hostname.
From opened Window or start hMailAdmin and in the tree to the left, go to Settings > Protocols > click on SMTP
From the right-hand side click on Delivery of the e-mail tab. Into that, under the hostname enter the public hostname of the computer where hMailServer is running and click on Save.
Now, you have to specify SMTP relayer, so enter the hostname of your ISP's email server, along with your credentials on that server in case it demands authentication and click on save.
You have successfully setup hMailServer and now you can use it.
So, a guide on How to setup hMailServer is completed. I hope you have understood the guide and cam setup hMailServer by own. If you are facing any problem while doing setup hMailServer then connects us via comments so that we can resolve your problem.
How to Show Formulas in Excel Function?
Mastering Excel skills have their advantages. You can easily organize your numerical data easily. Also, you can easily manipulate the data.
Formulas are used to simplify our calculations. We all make use of Excel formulas. So, there might be a case that you wanted to know how to show formulas in excel.
If that’s the case, then this article is probably the best place you’ve landed in your recent times.
You will get to know how to show excel formulas in easy and straightforward steps.
So, let’s get started:
How to Show Formulas in Excel?
One of the easiest methods to show all the formulas used in an Excel sheet is to use a simple Shortcut key.
The shortcut key is Ctrl + ` (Grave accent Key, which precedes one on the keyboard).
By making use of this shortcut key, you will easily get to see all the formulas used in an excel sheet.
One alternative method to display formulas in Excel is to make use of the Show Formulas option.
To do this, you will have to follow the following steps:
Open the Excel sheet of which you want to show excel spreadsheet formulas. To do this, you will have to locate the Excel file and double click on it. This will open the document in Excel.
Once you are done with this, then you are good to go to the next steps.
Now, you need to navigate to the “Formulas” tab on the top navigation bar. Once you have found it, then you need to click on it.
Now, from the tab, you have to locate the “Show Formulas” button. The moment you have found it, you are required to click on it, and this will show formulas in excel.
One point to take a note of that is even if the formula is not being displayed to you initially but whenever you select a column, you will get to see the method associated with it at the formula bar.
So, if you want to display formulas in Excel then you can consider selecting that particular column and the rest will be done by Excel itself.
How to hide formulas in Excel?
Since you were curious to know how to show formulas in excel, we thought that you might be interested in knowing how to hide formulas in excel? So, for that purpose, we bring you here in this section. This will equip you with the knowledge of the counterpart of how to display formulas in excel?
So, let’s get started:
First, open the desired document in which you want to perform the operation you want.
After this, you are required to select those columns of which you want to hide the formulas.
Now, you need heading toward the home tab. From the home tab, go for the Cells section and from there, you need to click on “Format”. This will open a drop-down menu for you from which you need to select “Format Cells”.
Once you are done with this, then you are all set to head towards the next step.
The Previous activity of yours will result in a dialog box. From that Format Cells dialog box, you need to check the checkbox beside “Hidden.” After doing that, you now only need to hit the OK button.
To hide all the formulas, you will have to protect the spreadsheet. This requires minimal effort. All that you need doing is to follow a few more steps as specified.
Once again, you will have to follow the route of the first home tab and then the Format option. But this time, instead of selecting format cells, you have to select “Protect Sheet”.
On the dialog box which appears after executing Step #4, make sure to check the checkbox against “Select Locked Cells” and “Select Unlocked Cells.”
Also, you will have to enter a password, just in case if you wish to unprotect the sheet sometime in the future.
Additionally, if you want to grant access to any other user corresponding to the options specified, then you can certainly do that.
Once you are done with all the stuff, then it’s the time to hit the OK button.
After this, you will be prompted to enter the password again. This is to confirm your action. Just do whatever is required and hit the OK button.
Now, you will see the difference in your excel sheet. If you had executed the steps well, then you cannot see the formulas from now onwards.
However, you can unprotect and display the formulas as and when required by making use of the password.
[Additional Information]: How to type formulas in Excel?
Just in case, you might be interested in knowing how to type formulas in excel? If it is a yes from your side, then this section has something worthy for you. So, here we go:
The steps start with selecting the cell on which you want to enter the formula.
Now, you need to enter an equals to sign (=) either at the formula bar or in the cell itself.
After this, you will have to enter an open parenthesis. According to your formula function, you might need to enter several other parentheses. So, if necessary do whatever is needful.
Now, all that you need to accomplish in this move is to create a cell reference. Just do the mentioned and proceed for the next steps.
Just type in the formula as structured by you and once you are done with it then all that you need to finalize the process is to hit enter. One key thing to take note is that do not ever forget to type the closing parenthesis after entering the formula.
This way you can quickly type an excel function formula and execute it.
So, this was all about how to show formulas in excel?
We hope that this article surely has added good value to your knowledge base.
Do share if you liked it and thank you for giving it a read.
Tech1 year ago
How to Receive Money through PayPal?
Tutorials1 year ago
How To Find New Movies On Netflix
Tech1 year ago
How to Make a Yahoo Account Without a Phone Number?
Tutorials1 year ago
How To Enable/Disable Chrome Pop Up Blocker
Mac1 year ago
How to Install GIMP for Mac
Tech1 year ago
How to Tame a Horse in Minecraft?
Mac1 year ago
How to Use Apple Thunderbolt Display with PC?
Computers1 year ago
How to Reset Macbook Air?