BEGINNER EXCEL TIPS HOW TO

Restricting wrong inputs via data validation function When satisfied, hit finish to complete the process. Step 3: Choose the desired data format of each column with its preview.In the example below, we have selected РІР‚ВDelimitedРІР‚в„ў so we can split our column containing theР’В full name to aР’В column having theР’В first name and a column with the last name. or choose РІР‚ВFixed widthРІР‚в„ў to split the column, from an exact location, by specifying a location of place from where you want split to occur. Step 1: Choose РІР‚ВDelimitedРІР‚в„ў to split up the column data, on the basis of delimiters such as commas, tabs, whitespace etc.Then directly head to the Data tab and click on РІР‚СљText to Columns.РІР‚СњР’В A 3-step wizard will pop up, requiring some additional information. To do that, just select the desired column data which you want to split. Through ExcelРІР‚в„ўs text to column feature, this tedious task can be done in just seconds. Thanks to excel, you could automate this work. One boring way could be cutting a part of text and pasting it to next cell, but that could be really most time consuming and boring way to do that. For instance, if you have to get first name and last name in different columns. Suppose you need to split the information stored in a single cell into different columns.

To use the feature just go to File РІР‚вЂњ> Excel Options РІР‚вЂњ> Proofing РІР‚вЂњ> AutoCorrect Options and define the replace text and the correct text in the red rectangular area and finally click on Add button. For instance, say that you want to save yourself from typing out РІР‚СљElon MuskРІР‚Сњ by using the shorthand РІР‚СљEM.РІР‚Сњ Therefore, every time you input EM, it will autocorrect to РІР‚ВElon MuskРІР‚в„ў. When one has to enter complex or a long data value repetitively, using AutoCorrect function can be a handy option, which replaces your short defined values with the correct text. Take note that this function would not activate if you havenРІР‚в„ўt copied the table content.Р”В®xpedite inputting complicated terms via Autocorrect Go to Home (Clipboard Section) РІР‚вЂњ>Paste РІР‚вЂњ> click on Transpose in the drop-down menu. This is how it can be done easily: just select and copy the area you want to transpose, place the pointer to some other blank cell. You can save yourself from all this just by using this transpose feature. If you need to transpose data from row to column or vice versa, re-entering all the data values again into theР’В spreadsheet would be a dull and a monotonous idea. Transpose data from row to column or vice-versa By doing so, you have quickly inserted multiple rows or column in barely two steps.

BEGINNER EXCEL TIPS HOW TO

Just do a right click over the highlighted rows or columns and select РІР‚ВInsertРІР‚в„ў in the drop down menu (the image below shows how to insert two new rows). To smartly do that, just drag and select N rows or columns (where N is two or more), if you want to add N rows or columns above or left.

Many of us know the way to add a single row or a column at a time, but using this technique becomes a tedious process if you need to insert multiple rows and columns. Inserting multiple rows or columns in a single go

Here are 10 tips and tricks that will unleash your efficiency, making you work smarter and not just harder. Whether you are a casual user or an expert one, there are always new things to learn. After Microsoft came up with 2010 version, lots of new and exciting features got added, which was a great bonus. Its varied list of exciting features is beautifully packed inside MicrosoftРІР‚в„ўs most popular number crunching application. The ways in which one can use Excel is countless. By Harshita Srivastava on Apin Advanced Excel Functions and Formulas, Basic Excel Functions and Formulas

Beginner excel tips