How to import text file in Excel

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. Step 1: Launch Excel Workbook and click the Data menu. Then navigate to Get External Data […]

How to change default ruler units in Excel

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 […]

How to Add calculator in Excel 2013 & 2010

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 […]