Yearly Archives: 2010

Many a times it is required to change the orientation of text in a cell to fit in the specified width and height of cell. Format Cells option offers a number of customizations regarding text in the cell. This post covers how to fit text in cell by changing its orientation. Read More

In Excel 2010, constants are referred to as data set which doesn’t contain any formula/function or whose value does not change with variation in other data set.  It provides you with a handy option to view all the constants contained in your spreadsheet. To quickly view the constants in spreadsheet, navigate to Home tab and under Editing group, from Find & Select options, click Constants. Read More

The Watch Window feature in Excel 2010 lets you keep tab on any selected window. This comes useful in situations when you need to verify particular data/formula/function against some other data set or verify changes in formula/function with varying data. Lets take a look at how to use this feature. Read More

While entering data into Excel 2010 spreadsheet, you may not want to use mouse to select one specific cell for editing. Since Excel 2010 supports a long list of hotkey combinations to bring ease, to edit the data cell instantly, navigate to the cell and press F2 on keyboard to edit the data. Read More

Sometimes it is required to rotate the text in cell in order to prevent cell’s width/height changes. Excel 2010 provides a list of ways in which you can rotate the text, lets take a look at where to access these rotation options. Read More

By default Excel 2010 opens 3 sheets in workbook, so you can switch between sheets for carrying out different operations. If you need to insert more sheets in a workbook, Excel offers a simple way to insert as many sheets as you want. Read More

If your spreadsheet has alphabetical data that needs to be sorted in ascending or descending order, Excel 2010 provides a quick way to let you sort the alphabetical data. This post will let you know how to quickly do it. Read More

In Excel 2010, you have an easy way to use and manipulate equations. Like other Office 2010 suite application, it provides a list of equations right in the ribbon to quickly insert one among many types of equations. Read More

Almost all the spreadsheet programs support multiple data types to let users choose one for their datasets. Although, you can choose to apply a formula to convert selected cells' values into required data type, Excel 2010 offers a simple and quick way to convert data cells into a required number format (data type). Not only does it support a wide range of data types including Currency, Accounting, Short & Long Date, Fraction, Percentage etc., it also lets you choose the symbol you wish to use with selected data type. For instance, if you choose to pick a currency from your selected data sets, you can change the default ($) with your's currency symbol. Likewise, you can change fraction, date and other data types according to your requirements. Excel 2010 offers most frequently used data types that are accessible from the Home tab. However, you can always open complete list of data types and choose the required one. In addition, it also allows you to create your custom data type by just selecting the type of data and format from a pre-defined list of data types and formats. Read More