Tag Archives: Excel 2010

Office

How to Make Address Book in Excel 2010

In this tutorial you are going to learn how to make address book in excel which has many useful functions, such as using for mail merge.


read more »

Office

How to Sort Excel 2010 by Alphabetical Order

In this tutorial you are going to learn how to sort excel by alphabetical order.


read more »

Office

How to Edit Excel 2010 Array

In this tutorial you will learn how to edit excel array formulas which is a bit different from editing standard formulas in Excel.


read more »

Office

How to Adjust Excel 2010 Print Area

In this tutorial you are going to learn how to adjust excel print area so you only print a limited part of your Excel sheet.


read more »

Office

How to Export Data from Excel 2010 to Pipe Delimited Text File

In this tutorial you are going to learn how to export data from excel to pipe delimited text file.


read more »

Office

How to Export Excel 2010 to Fixed Width Text File

In this tutorial you are going to learn how to export excel to fixed width text file so it is easily viewable even by people who don’t have access to Excel.


read more »

Office

How to Export Excel 2010 Data to a Text File

Exporting an excel file to a text document can be a great way to increase the compatibility of the file and share it with more people. This tutorial will show you how to export excel data to a text file.


read more »

Office

How to Use Excel 2010 Absolute Reference

The default setting in Excel is to have relative formulas, but sometimes making them have absolute references is useful – this tutorial is going to show you how to use excel absolute reference for formulas.


read more »

Office

How to Save Excel 2010 as Read Only

Saving a file as read only can be a great way to share your files without other people being able to adjust the data. This tutorial will show you how to save excel as read only.


read more »

Office

How to Write Subscript in Excel 2010

Learning how to write subscript in excel 2010 is a valuable skill if you want to create smaller notations in your spreadsheet.


read more »