• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Excel 2013

How to import text file in Excel

November 17, 2015 by Admin Leave a Comment

This tutorial is provided step by step instruction to import a text file in to Worksheet in Excel 2016 and 2013. For this demo, let us take the following sample data with the columns separated from tabs and spaces.

image

Step 1: Launch Excel Workbook and click the Data menu. Then navigate to Get External Data section.

image

Step 2: Click the From Text option under Get External Data section.

image

Step 3: In the Import Text File window, select Text file and click Import button. This should display the following Text Import Wizard.

image

Step 4: The columns in the text file have been separated using the tabs. Hence we have selected Delimited option for “Choose the file type that best describes your data”.

Step 5: After selecting an appropriate value for Start import at row and File Origin, click the Next button.

Step 6: In Step 2 of Text Import Wizard, choose appropriate delimiter under Delimiters section. You can preview the selection using Data preview section.

image

I have selected “Treat consecutive delimiters as one” as the text file used for import has more than one consecutive delimiters. Now you can see the Data preview section display the of data as 2 columns.

image

Step 7: Click the Next button to access the data format screen in Text import Wizard.

image

Here you can set the data format for the columns to either General, Text or Date. Similarly if you do not want to import any column then highlight it under Data preview select and select Do not import.

image

Step 8: Click Finish button on Text Import Wizard for completion.

image

Step 9: Now you will be show the above dialog box to choose “Where do you want to put the data”. You can either specify range on existing worksheet or New worksheet.

Step 10: After selecting the appropriate option under Import Data screen, click OK button to insert data from the text file.

image

Filed Under: Excel, Excel 2013, Excel 2016, MS Office Tagged With: Delimited file, Excel 2013, Get External Data, Import text file, Office 2013

How to change default ruler units in Excel

October 19, 2015 by Admin 1 Comment

The default ruler units in Excel 2016, 2013 and Excel 2010 is set to Centimetres and users can change this default units using the Settings available as part of the Excel options.

View Ruler in Excel 2013

The Page Layout view will be display the ruler in Excel. And in case if the ruler is not displayed then make sure to mark the checkbox with label as Ruler.

image

Change ruler units in Excel

Step 1: Click the File menu and select Options from menu list.

Step 2: In the Excel options window, click Advanced tab and navigate to Display section.

image

Step 3: In the Display section, click the Ruler units drop down and select your preferred unit.

image

Step 4: Click Ok button to apply and save the changes.

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Change, default units, Excel 2013, Ruler units, View Ruler

How to Add calculator in Excel 2013 & 2010

July 21, 2015 by Admin 1 Comment

Excel users can customize the Quick Access Toolbar and add Calculator as part of the toolbar. This would allow users to access Calculator without leaving Excel application. Let us now see the steps for adding Calculator as part of QAT

Adding Calculator to Quick Access Toolbar in Excel 2013 & Excel 2010

Step 1: Launch Excel and click Customize Quick Access Toolbar dropdown.

Customize Quick Access Toolbar in Excel 2013

Step 2: Select More Commands from the drop down list.

Commands Not in the Ribbon

Step 3:  In the Excel Options window, select Commands Not in the Ribbon for the “Choose commands from” dropdown.

Caculator to QAT

Step 4: Scroll down the commands list and select Calculate Full or Calculator.

Add Calculator to QAT

Then Click Add button to add the command as part of the Customize Quick Access Toolbar list. Click OK button on Excel Options screen to close the Window.

Now you should see Calculator as part of QAT as shown in the below screenshot. And you can quickly access Calculator without leaving Excel 2013.

Calculator in Excel 2013

 

 

 

Filed Under: Excel, Excel 2013, Office 2013 Tagged With: Add Caculator, Customize Ribbon, Excel 2013, Quick Access Toolbar

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023