Fast Download

Divide Excel Worksheet into Pages!!

Almost all of you are familiar with the Print Layout view of Microsoft Word. Excel Page Layout view does the same job here. If you enable Page Layout view in a worksheet, you can easily understand your print area with header and footer. And it also makes your printing task easier. 

Applies to:

• Excel 2007
• Excel 2010
• Excel 2013

Advantages of Page Layout

• You can view how your printed document will look

• Check where your page begins and ends

• View headers and footers of the page

• Print the worksheet page by page

How to Enable Page Layout View

You can enable page layout view as below:

1. Open any worksheet or create a new one
2. Go to the View Tab > Workbook Views > Page Layout 

You can also use the keyboard shortcuts:

Press Alt Key > Then type WP 

If you would like to back to the Normal View then:

Press Alt Key > Then type WL 

You can also enable Page Layout view from Status Bar. I think its the most handy option. Follow the image below:

The selected icon in the middle is Page Layout icon. The left one is for Normal View. And the right one is for Page Break Preview. 

Go to link download

Converting Numbers into Words in Excel

• Excel 2003

• Excel 2007

• Excel 2010

• Excel 2013

• Excel 2016

Function words(fig, Optional point = "Point") As String    

Dim digit(14) As Integer    alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")    figi = Trim(StrReverse(Str(Int(Abs(fig)))))    For i = 1 To Len(figi)    digit(i) = Mid(figi, i, 1)    Next    For i = 2 To Len(figi) Step 3    If digit(i) = 1 Then    digit(i) = digit(i - 1) + 10: digit(i - 1) = 0    Else: If digit(i) > 1 Then digit(i) = digit(i) + 18    End If    Next    For i = 1 To Len(figi)    If (i Mod 3) = 0 And digit(i) > 0 Then words = "hundred " & words    If (i Mod 3) = 1 And digit(i) + digit(i + 1) + digit(i + 2) > 0 Then _    words = Choose(i / 3, "thousand ", "million ", "billion ") & words    words = Trim(alpha(digit(i)) & " " & words)    Next    If fig <> Int(fig) Then    figc = StrReverse(figi)    If figc = 0 Then figc = ""    figd = Trim(WorksheetFunction.Substitute(Str(Abs(fig)), figc & ".", ""))    words = Trim(words & " " & point)    For i = 1 To Len(figd)    If Val(Mid(figd, i, 1)) > 0 Then    words = words & " " & alpha(Mid(figd, i, 1))    Else: words = words & " Zero"    End If    Next    End If    If fig < 0 Then words = "Negative " & words    End Function

1. Open your Word Converter workbook.
2. Type a digit in a cell. i.e. type 2124 in cell C6. 
3. Put your cursor in a different cell i.e. C7.
4. Type =words(C6) in cell C7. And you will get Two thousand one hundred twenty four.

Look at the formula bar: =words(A2)

Or you can also use this method - 

1. Type your digit and put your cursor in a different cell.
2. Go to the Formula > Insert Function > Select a Category > User Defined.
3. Now choose Words from Select a function.
4. Choose your desired cell and hit OK.

Warning Message!

When you close this document and reopen for the first time, Excel may warn you like - This document contains macro. And you should hit on the Enable Content button. If you dont hit the enable button, then word converter function may not work.

Lots of works to do ha? Seems complicated? No problem. Im sharing a sample workbook for you. Just download and do your work. :) 

Download Sample Workbook

Go to link download

Convert Webpage into PDF by Google Chrome!

Google Chrome has a nice printing option other than Windows Default Print Dialogue. Here you will get a preview of the pages which you wanna print. But if you use the system dialogue, there will be now print preview option. 

This feature was not available in previous versions of Chrome. So, before you go, you must upgrade to the latest version of Google Chrome. Google chrome also support cloud printing. I will talk later about it. Now lets start - 

1. Make sure your Chrome is up to date.
2. Now open a webpage that you wanna save as PDF.
3. Press Ctrl+P and immediately you will get a Print option on the left and Print Preview on the right.
4. At the top you will get the number of pages. You can choose printer from Destination option. Hit on the Change button to choose a printer. Select Save as PDF to create a PDF copy of the current webpage. 
5. Then Choose Pages - Select All or enter page number.
6. Choose Paper Size & Layout. You can also customize the Margins if necessary. Select custom margin and drag the margin to fix your margin size.
7. Choose the Options - Select whether the Headers & Footers, Background Colors & Images will be printed or not. 
8. Finally, hit on the Save*/ Print button to save your document as PDF or print using a printer. 

* If you save as PDF, you must choose a destination. 

Go to link download