Microsoft Excel 2007

Sorting Rules in Excel 2007

Excel sorts data according to a defined order, as follows: Numeric values: Numeric values, including date and time, are sorted from lowest (negati...

The Minus Sign Appears to the Right of the Number in Excel 2007

To move the minus sign from right to left: Use the following formula: =VALUE(IF(RIGHT(A1,1)="-",RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1)) Or 1. ...

Importing a Text File in Excel 2007

To import a text file: 1. Select File -> Open -> find the text file and click Open. 2. In Text Import Wizard dialog box: Step 1: Select De...

Array Formulas in Excel 2007

Understanding Arrays For those who do not have a background in programming or mathematics, the expression Array may not be familiar. So what exac...

Copying Styles from One Workbook to Another in Excel 2007

Excel saves custom Styles in the workbook where they were created and saved. To use the Styles in a different workbook, either copy the custom Styl...

Creating and Saving Custom Formatting Styles in Excel 2007

To create a wide range of complex Styles: Add Styles and save each one separately with a unique name: 1. Select a cell, Select Home -> Cell Sty...

Changing the Default Style in Excel 2007

The default Style name is Style 1. To change the default Style: 1. Select Home -> Cell Styles in Styles Group) -> New Cell Style. 2. In ...

Select a Style in Excel 2007

To select a Style: Select Home -> Cell Styles (in Styles Group). The Cell Styles palette is presented. ...

Change Excel's default font in Excel 2007

MS Excel 2007 by default uses the Body Font font in font size 11. When you type data in a worksheet,  text box, header or footer, it will appear as t...

Creating Page Breaks without VBA

Many excel users insert blank rows within their files so that the sheets print out properly with the required number of rows on each page.  However, ...

Page 20 of 27« First...10...1819202122...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube