In this tutorial you learn the most useful Excel shortcuts to be able to work faster in Excel. There are many hidden features in Excel that are easily accessible with shortcut keys. Microsoft Excel is very useful and most commonly used application in the data analysis world. If you’re planning to work with excel or going to start then you need to know the shortcuts which makes the workflow easier.
For Automatic Summation
In the excel table we must have dataset for calculation and we use summation by using formula. But we can do it by shortcut. For this keep the cursor one cell below of the number set and press Alt + = (Equal Sign) which will automatically input sum function. But be aware about the range because it will calculate entire local range. The shortcut works great in column as well as row.
Select data in current / entire region
Click anywhere inside the dataset and press Ctrl + A To select the entire data in the current region. Now to data in entire region press Ctrl + AA. This will select whole document like Microsoft Word.
Select entire row and column
Press Shift + Space from keyboard to entire row and for selecting entire column press Ctrl + Space as shortcut.
Insert new row and column
Shift + Ctrl + Plus is the most useful excel shortcuts that is used for inserting new row and column. Let’s see how to use the shortcut easily. When you press the shortcut a dialog box appears on the screen then select Entire row or Entire column as your need.
But you can do it new way. First select entire row or column by pressing Shift + Space or Ctrl + Space then use Shift + Ctrl + Plus which will immediate insert row or column as your need without any popup or dialog box. Remember row always append above and column append left.
Delete entire row or column
Deleting row and column also easy as insert. Instead of pressing Shift + Ctrl + Plus you have to press Ctrl + Minus. The shortcut also popup a dialog box then you’ve choose Entire row or Entire column as your need. But now you know the tricks for bypassing the dialog box. First select entire row or column then press Ctrl + Minus to delete.
Formatting Excel Cells
One of the most useful Excel shortcuts is Ctrl + 1 which one commonly used for cell formatting. Before using the shortcut you have select the range of dataset then press the shortcut. This will popup Format Cells dialog box as follows:
Now you can the the cells as your desire. You can change format to Number, Currency etc. also you can change the text alignment, font size, border size, fill color etc. from here.
Filter Shortcut
Keep your cursor inside the dataset the press Ctrl + Shift + L to add filter to the entire region. Keep in mind the first row will be header of the filter. So always use header for smooth operation. If you don’t need the filter anymore after work done simply press the shortcut again to omit.
Create Table in Excel
To convert excel data into table like word you’ve to click anywhere inside the data set then use shortcut Ctrl + T. If your dataset has header then checkmark “My table has headers” otherwise keep it unchecked and press OK.
Now you can change table style from Table Design. You also have a lot of options to work with the newly created table. You can Summarize with PivotTable or Remove Duplicates or switch back to original format by clicking on Convert to Range.
New line in cell
Some time we need to add newline or line break or word break in the cell of Excel sheet. Simply press Alt + Enter to break wherever and whenever you want.
Hide column and row
Sometime you may need to hide row or column for work need. So you can do this easily using useful Excel shortcuts and these are Ctrl + 0 (number zero) to hide a column and to hide selected or current row just press Ctrl + 9 (number nine).
Group / Ungroup Columns
You may need to group date wise collection then you can group the selected rows or column by pressing Alt + Shift + Right arrow and to switch back press Alt + Shift + left arrow. Now you can expand or collapse the group as your need.
Date / Time / Timestamp
Most of the time you need to input date but We do it manually. But there is a shortcut for it that is Ctrl + ; (Semicolon). If you need to input times press Shift + Ctrl + ; (Semicolon) and for timestamp press F2 goto Edit Mode and insert date then press space and insert time. But you can create timestamp easily just using NOW() formula.
Move around sheets
You may have multiple sheets in the file. If you want to go next sheet from the current sheet then press Ctrl + Page Down and if want to go previous sheet from the current sheet then press Ctrl + Page Up
Here we’ve covered most commonly used shortcuts. If you need to know any other specific shortcuts then let us know by commenting.
Hope you have learned something new from this tutorial. If you find this tutorial helpful please share this article with friends so that they also can learn something new like you. If you haven’t already subscribed to our newsletter please put your email address and hit “Keep me Updated!” from below subscribe form to get notification mail of upcoming articles like this.
In this step-by- step tutorial, learn how to extract Text from Image using Microsoft Word. You can extract text and characters from scanned PDF documents (including multi page files), photos and digital camera captured images. Any type of images like JPG, PNG and PDF can be converted into text. Extract text from scanned PDF documents, photos and captured images without payment.
You may wondering how you could take a sheet of text and convert it into text using Microsoft Word. You don’t need any other paid applications except for Microsoft Word to be able to do this well. So how do we take this piece of text and convert it into text on my computer. At first if you don’t have scanned copy then take a picture of the image with smartphone or camera. Now save it as JPEG or PNG to your computer. So here I’m on my desktop and I’ve actually finished those steps so we don’t have to jump through those. Here I’m going to open up the image that I took actually collected from Google.
Insert Image in Word Document
So you have the image and want to edit this text well. How do you do that? You can simply do this using Microsoft Word as you see in the title. We would use Microsoft Word to do this and we’re going to create a blank document. Now we’re going to drag and drop the image into the word document. The file is imported to word file but still the text is not editable. How do I edit the text? Microsoft could probably make this a little bit easier where you’ll see and option called convert to text. Now we’re going to do is go to file and then save as PDF on the desktop.
So I’m gonna just save this file to my desktop so we’re gonna just save it as say convert to text now. But what we’re going to do is save as a type instead of just saving it as a document. What we want to do is we want to save this as a PDF. Now you can open it with any Browser or PDF reader. And it shows me the PDF that I just saved with that image now.
Extract Text from Image
One of the beautiful things that you can do with words is when you open a PDF word automatically converts that PDF to text. So that’s how we get that’s basically how we get the text into Word so let’s try that. Now I’ll go to open file and we’re gonna go to just onto the desktop and then I see my convert to text PDF so let’s try opening that file. Now I’m gonna click on that and it says word will now convert your PDF to an editable or a document. That’s exactly what we want. This might take a while the resulting Word document will be optimized and I can edit the text.
So it might not look exactly like the original PDF that’s fine so we’re gonna click on OK and so right now it’s doing the conversion and there you go it says basically all the text from the sheet and see here I could type alongside it.
Compare extract text from image
It’s time to compare extract text from image and we gonna do it. Let’s open up this document and we’re gonna open it next to the original image. So I’m gonna put the image on one side and the document on the other side.
Here you can see it did a pretty good job here you know it says go paperless go paperless user democracy vouchers online how’s the URL and then it has the different sections the one thing that missus didn’t include this questions but otherwise it did a pretty good job at taking this text from just a random mailing. I got in the mail and I was able to take a picture with my phone, save it as an image and then bring it into Word and here I can edit. I can do whatever I want with any of the text.
You can do this with any type of document just take a picture and bring it into Word and then you can go ahead and edit the text it’s pretty simple to do you only need word and then your cell phone or some type of phone or camera any camera will work and you could do this if you were able to successfully bring text into Word and now we were able to edit it.
Warm Up
Hope you have learned something new from this tutorial. If you find this tutorial helpful please share this article with friends so that they also can learn something new like you. If you haven’t already subscribed to our newsletter please put your email address and hit “Keep me Updated!” from below subscribe form to get notification mail of upcoming articles like this.
In this step-by- step tutorial, learn how to add watermark in Microsoft Word to make the document confidential. You can use default one, like disclosure, urgent or confidential or can also customize as your need. You can acclimate the fountain, size, color, and indeed the translucency. We also look at how to use picture in this purpose. In this article you’ll learn how to insert a watermark into a Microsoft Word document. Maybe you have a secret document that you don’t want to share with anyone. You can throw on a top-secret message.
Add or Insert WaterMark
First of all for presenting purpose we collected a document from Google and now we will insert preset watermark then will see how to customize it. All right, let’s check this out here. Here is a secret document open in Microsoft Word for demonstration purpose. Now if you don’t want to share this out, so need to add a top-secret message which can help to keep it a little bit safer.
To insert a watermark go to design tab menu. Within the design over on the right-hand side you’ll see an option for Watermark. See, it’s really easy to insert a watermark. There is a set of confidential watermarks, disclaimers and also urgent. Now select the one that says confidential and that inserts a confidential text into the document. It’s already starting to feel a little bit more official. If you’ve multiple page in the document then the watermark carries over to the other pages too. That’s one thing to keep in mind when you’re working on a document.
Now confidential works Okay but now need to add some more official text that’ll make sure not sharing this document.
Customization
I’ll go right back up to the top and once again I’ll click on Watermark and down at the bottom there’s the option to Custom WaterMark. Let’s click on that. This opens up a dialogue where I can now customize it. You can start with a text-based, so go down to the bottom section.
Right here you can choose a language. Here you see a drop down where you can view all options, but I could also type in text to customize the it. Here you can type any text as your desire. Down below, you can also set the font and size of the font. Currently it’s set to auto and that’ll ensure a best fit. You can also set the color as you like. Pick a color from options look like and right next to color, there’s also an option called semi transparent. This will wash out the watermark just a little bit more. So maybe the watermark is a little bit too dark and it interferes with your text. Well, you could set it to semi transparent. Down at the very bottom you can also choose the layout. You could have the text go Diagonally across the document, or across Horizontally. The text works OK, but if you a little bit more serious then try inserting a picture watermark. Right here, select picture watermark and then select a file on my PC. You can insert your brand logo or any custom typography. If you don’t have any readymade brand logo it’s easy to made from Canva. You can try it from HERE.
Remove from Document
To remove a watermark within this dialog at the very top, I can simply click on no watermark. Back on the main screen, I can also remove the it by going back up to design, watermark, and within this list down towards the bottom, there’s the option to remove the watermark. All right, that’s how easy it is to insert a watermark and to keep the secret document safe.
Hope you have learned something new from this tutorial. If you find this tutorial helpful please share this article with friends so that they also can learn something new like you. If you haven’t already subscribed to our newsletter please put your email address and hit “Keep me Updated!” from below subscribe form to get notification mail of upcoming articles like this.