Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Monday, May 7, 2012

Number to Words in Excel

Follow this link http://www.accountinghead.com/index.php/how-to-convert-number-to-text-in-excel-2003-2007/

1) Open excel then Press Alt+F11 to start visual basic editor

2) In visulal basic editor click insert menu then open module

3) copy the script and paste in opened module window, on the left side pane click on This work book
 

Friday, August 26, 2011

How to Print First Row or Header Row on Every Page in Excel?

Go to this site for know the steps in Excel 2007/2010:  http://www.lytebyte.com/2009/08/18/how-to-print-first-row-or-header-row-on-every-page-in-excel/

In Excel 2003:

1) Go to View Menu bar
2) Click Header and Footer
3) Go to Sheet Tab
4) Click Rows to repeat at top option in Print titles
5) Select First row by clicking at position Row1 and Press enter
6) Now prints the page. You will get desire output.