Office Hackery

Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Comic Strip #9

1 comment

1 comment :

Post a Comment

Convert PDF to Excel

No comments
Thanks God its Friday. After I attended the "OHSES Internal Audit Team Meeting" this morning, I sat on my chair for a while and read some emails. I opened an email from a friend that I think is worthy to blog about.

Here is my friend's email:

Hi foxtrot! Long time no see. Anyway, do you have a software that can convert PDF to Excel?


Luckily for him, last week I already blog about the conversion of PDF to Word which points me to the other available service of the same company. That service is Online PDF to Excel Converter.

Online Convert PDF to Excel

No comments :

Post a Comment

A shortcut to skip through your worksheets in MS Excel

No comments
Nowadays, Most of power users are used to multitasking when working. To skip between each open programs we usually use the keyboard shortcut ALT+TAB. However, this shortcut doesn't work when you're moving between worksheets in the same workbook in MS Excel. But no worries; there are a couple of neat little shortcuts that handle the job quite nicely.

To move one worksheet to the right
Press [CTRL]+[PAGE DOWN].


To move one worksheet to the left
Press [CTRL]+[PAGE UP].

No comments :

Post a Comment

Free Online Typing Tutorial

No comments
I admit that I don't use standard typing techniques. For over 8 years in IT It just happened that I know where the keys by heart so I let my finger find the key to press. But if your a secretary or a documentation officer you might need to learn the standard typing practice.

This morning, while reading articles on my Google reader, I stumbled with this great online typing tutorial. The tutorial is free and divided to different courses. Each courses consists of several lessons. The first courses show the computer keyboard and fingers that should be used to type the requested key. This is helpful for users who need some visual guidance in their first lessons.

Free Online Typing Tutorial

Try it for yourself by visiting TypingWeb website.

No comments :

Post a Comment

Comic Strip #8

No comments
people = productivity

No comments :

Post a Comment

How to get rid of Paragraph Marks in MS Word

1 comment
Email number 2. This one came from a Very Important Person at our head office. And his email goes like this.


foxtrot. How do I get rid of this character "¶"? I don't how you call it. Please reply asap.


"¶" - this symbol is called Paragraph Marks. And you can tell MS Word not to display it by doing the following simple steps:

1. Go to Tools > Options.
2. On the Options dialog box, click the View tab.
3. Then under Formatting marks, uncheck the paragraph marks.

Remove Paragraph Marks in MS Word

4. Click OK to apply changes.

1 comment :

Post a Comment

Shortcut Keys in MS Word

No comments
If you want to be a quick MS Word power user, I recommend you to familiarize the following shortcut keys:

CTRL + A Selects all in the current document.
CTRL + B Bold text.
CTRL + C Copies the item or text to the Clipboard + can be pasted using CTRL + V.
CTRL + D Displays the Font dialogue box.
CTRL + E Centre Alignment.
CTRL + F Displays the Find dialog box, to search the current document.
CTRL + G Displays the Go to dialog box, to go to a specific location in the current document.
CTRL + H Displays the Replace dialogue box.
CTRL + I Italic text.
CTRL + J Full Justification.
CTRL + K Create Hyperlink
CTRL + L Left Alignment
CTRL + M Tab
CTRL + N Creates a new document.
CTRL + O Displays the Open File dialogue box.
CTRL + P Displays the Print dialog box.
CTRL + R Right Alignment.
CTRL + S Displays the Save dialog box.
CTRL + U Underline text
CTRL + V Pastes the copied item or text from the Clipboard into the current position in the document.
CTRL + X Cuts the item or text selected to the Clipboard.
CTRL + Y Redo the last undone action.
CTRL + Z Undoes the last action.
CTRL + ENTER Insert Page Break.
CTRL + F2 Show Print preview.
CTRL + F4 Closes the active document window.
CTRL + F6 Opens the next document window.
CTRL + 1 Single spaces text
CTRL + 2 Double spaces text
CTRL + 3 Triple spaces text

No comments :

Post a Comment

Animated Text in MS Word

No comments
Thursday Morning. Grabbed my coffee cup and head to the pantry to make my coffee. Sit on my chair and as usual do my thing. Found my first non-sense email of the day:

Hi there! Is there a way I can animate a text on MS Word document? Please don't ask me the reason why I need it.

Thanks in advance


I wonder what the reason is. Anyway to animate text in MS Word, follow these steps:

1. Select text you want to animate.
2. Right-click the text and choose "Font" from the popup menu.
3. On the multi-tabbed dialog box, click the "Text Effects" tab.
4. Now, select an animation that you would like to see. You can see examples of each animation in the preview window.

Animated Text in MS Word


5. When you are done, press "OK" to close the dialog box.

No comments :

Post a Comment

Comic Strip #7

No comments

No comments :

Post a Comment

Delete blank rows in Excel Workbook using VBA Macro

1 comment
Another VBA macro request for the day. A fan from Plurk private message me about her problem.

Jenny
Hi there! I need an office hack to delete blank rows on my existing workbook. It has over 1000 rows. I just can't go through each line. It could take me days to do that. Do you have any suggestion?


foxtrot

Yes jenny. I have a suggestion...


To delete blank rows in excel workbook using VBA Macro.

1. Open your excel workbook.
2. Open the VBA Editor by going to Tools > Macros > Visual Basic Editor.
3. Now click the ThisWorkbook icon on the left pane and paste the following code on the blank space at the right window.


Sub DeleteBlankRows1()
Dim i As Long
With Application
.Calculation = xlCalculationManual
.ScreenUpdating = False

For i = Selection.Rows.Count To 1 Step -1
If WorksheetFunction.CountA(Selection.Rows(i)) = 0 Then
Selection.Rows(i).EntireRow.Delete
End If
Next i

.Calculation = xlCalculationAutomatic
.ScreenUpdating = True
End With
End Sub


4. Now switch to your workbook window (don't close the VBA editor). Select the range you want to remove blanks.

Delete blank rows in Excel Workbook using VBA Macro

5. Then switch to VBA editor and click the play button on the toolbar or go to Run > Run Sub/User Form

1 comment :

Post a Comment

Send emails from within Excel

No comments
9:50AM Today, an important email from a VIP arrived on my mailbox. The email goes like this:


Hi foxtrot. Can you please take a look on the attached excel workbook. I want my secretary to be able to send this workbook from within excel.


Fortunately for me, Excel VBA can send emails from within Excel and even send the Workbook as an attachment. How?

1. Open your excel workbook.
2. Click Tools > Macro > Visual Basic Editor.
3. From the left pane, click ThisWorkbook and paste the following code on the blank white space on the right pane.


Sub SendActiveWorkbook()

ActiveWorkbook.SendMail _
Recipients:="myboss@gmail.com", _
Subject:="You Workbook " & Format(Date, "dd/mmm/yy")

End Sub


Send emails from within Excel

To customize it, replace the following:
Recipients - to your recipient email
Subject - the subject you want to appear on your email

No comments :

Post a Comment

Jump quickly between MS Word documents

No comments
Wednesday, the busiest day of the week for me. To relax a bit I walked around our room and sat beside edwin to observe what he is doing on his computer.

foxtrot

That's alot of document. You are multi-tasking.. impressive


Edwin

Yeah you know me. Another busy day at my desk.


(I noticed him using ALT+TAB to switch between documents)

foxtrot

Do you know that there is a way to switch between MS word documents only? (excluding other windows application)


Edwin

Really? How?


If you work with a lot of open documents you usually use ALT+TAB to jump to the next window but this key works for all application. If you need a quick way to cycle only on MS Word document you can use [Ctrl][F6] to jump from one to the next and [Ctrl][Shift][F6] will jump you backward.

No comments :

Post a Comment

Comic Strip #6

No comments

No comments :

Post a Comment

MS Word: Convert PDF to Word

No comments
Dzzzz. Dzzzzzzzzz. My cellphone is vibrating. Unknown number. I wonder who's calling..

foxtrot

Hello? Who is this?


George

Bro, This Georgy! Long time no hear!


foxtrot

Yeah men. How are you?


George

Let's talk later ok? I need help right now. Do you know a free PDF to Word document converter?


foxtrot

There is a free online facility to convert PDF to Word. Here is the URL: www.pdftoword.com


PDF to Word is a free online tool that quickly and easily create editable DOC/RTF files, making it a easy to re-use PDF content in applications like Microsoft Word, OpenOffice, and WordPerfect.

Convert PDF to Word

Online conversion of PDF to word

No comments :

Post a Comment

MS Word: Keep different versions of a document in the same file

1 comment
Just created my first brute account when I received an email tagged as Important. The email says:


Hi. please check the attached word document. apply the changes you mentioned to me earlier but make a copy of this original file

Thanks
~ your boss


So do I have to make another file for the new version? Ofcourse NO. MS Word has this feature called "versioning". One file will contain all the versions and will increase the file size.

To apply versioning on your Word document, follow these steps:

1. Choose Versions from the File menu.
2. Click the Save Now button to save the version of the document. Word saves the author and datetime of the version. You can also add some comments to each version.

keep different versions of a document in the same file in MS Word

To open other version of the word document.

1. Choose Versions from the File menu.
2. Select the version you want to open then the Open button. It will be open in a separate window.
3. If you want to save the current version on another file, click Save As.. from File menu.

1 comment :

Post a Comment

How do I change the default document font in Word?

No comments
6.45AM Tuesday Morning, Just arrived at the office and tuned-in to Magic 89.9 to listen "Good times with Mo". Suddenly my phone is ringing... What the?? Its too early for work.

foxtrot

Yes Hello?


Ronald

Thanks God you already there. I need help for my boss.


foxtrot

What is it?


Ronald

Do you happen to know how to change the default font for MS word document?


foxtrot

Easy. To change the default font of your Word document follow these steps:

1. Go to Format > Font menu.
2. Select the font and change attributes you want for your default font.
3. Click the Default button.
4. Word will notify you that this change will affect all documents. Click Yes to confirm.

change the default document font in Word

No comments :

Post a Comment

Comic Strip #5

1 comment

1 comment :

Post a Comment

How can I track changes made to a word document?

No comments
It was already 10:28 AM, Orlando Magic was ahead by 7 against the Cavs. Nitz approach me to ask something.

Nitz
Hi, I'm not familiar with MS Word. Is there a way I can track changes on my word document? I can do it on Star Office.


foxtrot

Ofcourse there is. Take a look at this (point to my monitor).



Word track changes feature allow an author to retain deleted text to be accepted or rejected once the document is finalized. With the feature activated, Word "red lines" text deleted from the original document so that is visible, but distinct from the surrounding text.

To activate Track Changes in MS Word, follow these steps:

1. Save your first draft.
2. Click the Tools > Track Changes menu, the Track changes toolbar should appear.
Now every time you make changes on your document, you'll see that Word displays the changed text.

track changes made to a word document

To accept or reject changes:
Place the mouse pointer at the line of the document that is showing tracked changes.
Choose Track Changes from the Tools menu, then select Accept or Reject Changes.

No comments :

Post a Comment

Automatically run a Macro When Opening a Excel Workbook

No comments
9:45 AM Monday morning, My first caller for the day. Local 522 is displayed on my IP phone's caller ID. I excitedly pickup the phone and started the conversation.

foxtrot

Hello good morning! IT Department. How may I help you?


SuperGirl

Hi good morning. I forwarded you an excel file with some macro function on it. Can you please take a look on it? I want my excel to run the macro function every time I open the workbook. Can it be done? How?


foxtrot

Yes it can. I will reply to your email the answer.


Super Girl

Thanks! your my hero.


To run a Macro when opening an excel Workbook, do these steps.
1. Open your Excel's Visual Basic Editor on Tools > Macro > Visual Basic Editor.
2. Now add an Auto_Open Sub on your existing macro code. Inside the Auto_Open Sub call the function you want the excel to execute every time you open the workbook as shown below.

Sub autoopensample()
MsgBox ("Testing my Auto_Open function")
'Anthing here
End Sub
Sub Auto_Open()
autoopensample
End Sub

Automatically run a Macro When Opening a Excel Workbook
* Each time Excel opens, Auto_Open() will run only once when the workbook is open.

3. Now save and close the workbook.
4. Open your workbook again to test if it is working.

No comments :

Post a Comment

How to Print a Portion of a Worksheet in Excel

No comments
Monday morning, my favorite day of the week. Not because I'm work alcoholic but because it is the only day of the week I can enjoy sitting on my favorite office chair and sip my favorite morning coffee. For my first entry for the day, I will share a tip on How to Print just a portion of your MS Excel's Worksheet.

To start printing a portion of your worksheet, follow these steps.
1. Select the cells you want to print. (yeah drag that mouse)
2. Click the File > Print menu or just press Ctrl+P to display the Print Dialog box.
3. In the Print What section, choose the "Selection" option.
4. Click on the OK button.

Print a Portion of a Worksheet in Excel


There you have it! Enjoy your coffee too.

No comments :

Post a Comment

Comic Strip #4

No comments

No comments :

Post a Comment

How to add a Background to your MS Word document

1 comment
12:00 PM (lunch time). Rodell forwarded me the furnished DRP (Disaster Recovery Plan) word document for our Biometrics system. Now I need to print and file it. But first I have to put a background image on it as per standard documentation requirement.

You can add background to your MS Word document by following this steps:

1. Click the Format menu, then choose Background then Printed Watermark...
2. On the Printerd Watermark dialog box, Tick the Picture Watermark.
3. Click the Select Picture... and browse for the image you want put on background.
(Aside from Picture, you can also create a TEXT watermark on MS Word)

add a Background to your MS Word document

4. Then click Apply and Ok.

The background should appear now.

Background on MS Word document

1 comment :

Post a Comment

How to combine cell contents in Excel

No comments
11:42 AM - Just came back from e-Payment meeting, when Mr. Jonathan (the congressman) approach my desk to ask something.

The Congressman

Bro. Can you please take a look on my excel spreadsheet?


foxtrot

OK sir. No problem.


The Congressman

How can I combine cell contents here in excel?


To combine cell contents from different columns in excel, use this formula:

=A1 & " " & B1 & " " & C1

Where A1, B1, C1 are the cells you want to concatenate. The ampersand character (&) tells Excel to "add" text together to create a new text value.

No comments :

Post a Comment

How to enable autosave in MS Excel

No comments
I was late for work today, It was Friday sickness. A note on my desk that says "Return call to Ms. Niña", started my day. Sat on my chair and dialed her local number.

foxtrot

Hello Niña? what's up?


Niña

Who is this???


foxtrot

It's me. You need me right?


Niña

Oh I'm sorry. My phone's caller id isn't working for a week now. Anyway I just want to ask you for... [a date?] on How to enable AutoSave in Excel 2000?


foxtrot

I see. so they haven't upgraded your ms office yet.


To enable MS Excel, follow this.
1. Click the Tools menu, then choose Add-Ins.
2. Check the AutoSave add-in on the Add-Ins dialog box.
3. Click OK.

Excel AutoSave Add-in

To change the default AutoRecovery option in Excel.
1. Click Tools menu, select Options, and then select the Save tab (this is a new tab in Excel 2002 and Excel 2003).
2. Change the Save AutoRecovery info every: ... minutes, set the Auto Recover save location, and then click OK.

AutoRecovery option in Excel

No comments :

Post a Comment

Comic Strip #3

No comments

No comments :

Post a Comment

MS Excel: Generate a unique list of entries in a column

No comments
Just before lunch time, my boss sent me an excel document that contains list of computer models. Here requirement is to get only the unique entries from the huge list. How did I get it?

Here is how you select unique entries from a list in a column.

1. Select the column you want to filter.
2. Go to Data menu, click filter and then Advanced Filter.
3. From the Advanced Filter dialog, tick the "Unique records only" checkbox. (If you want to copy the filtered list on another location, choose Copy to another location. then put the column label where you want it to appear)

Generate a unique list of entries in a column in Excel

4. Click OK.

The list should now display only unique data.

No comments :

Post a Comment

Display a Hidden First Column in MS Excel

No comments
While having my mid morning coffee, Mr. Crush-of-the-town approach me and asked an interesting question.

Mr. Crush-of-the-town
Buddy, It is easy to hide and unhide a column on a spreadsheet right?


foxtrot
Ofcourse yes. it simple as right click + hide/unhide


Mr. Crush-of-the-town
That's apply to all column but not on the left-most or the first column (A1)


foxtrot
Hmm. I haven't think about that. Let me see.



Here's a good workaround for Mr. Crush-of-the-town problem. To display a hidden first column (left-most) in MS Excel follow these steps.

1. Click Edit > Go To... or press F5.
2. On the Go To dialog box, put "A1" as the reference then click OK. (Although you can't barely see it. It actually highlight the first column.)
3. Now click Format > Column > Unhide

Viola the missing first column appears!

No comments :

Post a Comment

Compare Document Versions in MS Word

No comments
9AM in the office. I was so busy attending Audit matters when my phone rang. Called Id tells me that the call is from Payroll department.

foxtrot
Hello? How can I help you?


Carol
Bro. Are you busy? can you talk right now?


foxtrot
Sure carol. What is it?


Carol
I have two copy of word documents, I wanna see the changes my team did from the old document. What can I do?


foxtrot
That's easy. Just follow my lead


If you have Word 2003 and Up.

1. Open the newer version of the document.
2. Click Tools menu then choose Compare and Merge Documents.
3. From the Open dialog box, locate the older word file.
4. Then click Ok.

If you have Word 97 or Word 2000.

1. Open the newer version of the document.
2. Click Tools menu then choose Track changes > Compare Documents.
3. From the open dialog, locate the older word file.
4. Then click Ok.

MS Word will automatically highlight the changes.

No comments :

Post a Comment

Comic Strip #2

No comments

No comments :

Post a Comment

Excel: Extract Firstname and Lastname from FullName

No comments
While looking at the scoreboard of the recently concluded game of the Laker versus Denver (Where Lakers won it by 2 points). I wondered how can I separate the player's fullname into firstname and lastname using Excel, if I only have the fullname column.

So after some experiments, and of course googling. I derived a solution given that A column contains the full names.

1. To get the firstname, I used the formula =LEFT(A1,FIND(" ",A1)-1)
2. To get the lastname, I used the RIGHT function to derive to =RIGHT(A1,LEN(A1)-FIND(" ",A1))


The output should look like the one below.

Excel: Extract Firstname and Lastname from FullName

To understand it better, please download the excel sample for this tip

No comments :

Post a Comment

How to count the number of blank cells in Excel

No comments
It's time for my post-lunch coffee, when my IP phone rang (outside line is displayed on caller ID).

foxtrot
Hello. IT. How may I help you?


my brother

Kuya, do you know how to count the number of blank cells in Excel?


foxtrot

Okay wait. Let me find it for you.


I opened my excel software then hit the F1 key. After seconds of searching, I found the answer.


To count the blank cells, use this formula "=COUNTBLANK(range)"
For example:
=COUNTBLANK(A1,A30)

COUNTBLANK returns the number of blank cells, excluding those that have a zero displayed if you chose to display such values.

No comments :

Post a Comment

Excel: Shortcut to display current date or time on a cell

No comments
While I was having my lunch on my table, I was conversing with Paul (the programmer). I ask him, "How long you can enter date or time in a spreadsheet cell?". He answered me with - "I can do it in less than 4 seconds". Impressive? NO. Because I can do it in a second. He's cannot believe it so he ask me to prove it.

To display current date or time on a cell quickly, you just need to press two (2) keys:


- To display the date, select a cell then press "CTRL + ;"
- To display the time, select a cell then press "CTRL + :"


Try it for yourself. See? you just need a second to do it.

No comments :

Post a Comment

Printing All Open Documents in MS Word

1 comment
Arrived at the office at 7AM. Open up my corporate email, sipped a coffee then started reading... The first email was from Michael Kent and here what he wrote me:


Sir,
Good Morning! Do you know a way to print all open documents in MS Word? It to tiring to manually switch between documents and then choosing to print each one.
Thanks in advance.
Mike


As usual the office hacker must go to work. Unfortunately, MS Word don't have existing function to do this so I suggested that he use Macro. Since he is not familiar with it, I took the liberty to elaborate.

1. Select one document from all open documents
2. Click Tools Menu then select Macro and click Macros... (the one with green play button)
3. On the Macro name textbox, type your desired name such as PrintAllOpenDocument then click "Create" button. See screenshot below:

Create MS Word Macro

4. The Microsoft Visual Basic Editor will open. Copy and Paste the following code between "Sub PrintAllDocument()" and "End Sub".


For Each Doc In Documents
Doc.PrintOut
Next Doc


It should look like this:

MS Word Visual Basic Editor Macro

5. Now Save it using the menu File>Save Normal or click the save button on the toolbar. The Close the editor.

6. Back to your document. Click Tools>Macro>Macros.
7. On the Macros dialog box. Select the macro we created earlier then click "Run" button as shown below:

Printing All Open Documents in MS Word using Macro

Whew. We're done! Your open documents should be printing now.

1 comment :

Post a Comment

Comic Strip #1

No comments

No comments :

Post a Comment

Excel: Alternate Row shading using conditional formatting

No comments
Isn't cool if your spreadsheet has alternate row shading?. You can attain this using excel's conditional formatting option and its dynamic. It is easy.


- Select the cell range that you want to apply the formatting
- Then choose Format menu then click Conditional Formatting
- In the conditional formatting dialog box, select Formula Is from the drop-down list, and type this formula:
=MOD(ROW(),2)=0

Alternate Row Shading Using Conditional Formatting
- Click the Format... button and then select the Patterns tab and specify a color for the shaded rows.

conditional formatting in excel

- Click OK button to return to your worksheet.

No comments :

Post a Comment

Calculate The Number Of Days In A Month in Excel

No comments
I just came from the gym and its already past 7PM, Dingdong.. my messenger popup a window.

Fed
Hey are you still there?


I answered
No. Im not here anymore.


Fed
C'mon men, need help. Do you know how to calculate the number of days in a month in excel sheet?


Me
Give me a minute.


I open up my browser and ask Mr. Google. Then theres the formula.

Me.
To calculate the number of days in a month, use the following formula.

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)
Where A1 contains a date.

I already tested it on MS Excel 2003. It should be working.



Fed
Thanks bro.

No comments :

Post a Comment

MS Word Trick: The quick brown fox jumps over the lazy dog

No comments
For todays trick, Open your MS Word then do the following:


- Type =rand (200, 99)
- And then press ENTER.
- And see how fast your computer can type.




Here is a screenshot from my computer.

MS Word Trick: The quick brown fox jumps over the lazy dog

Now forward it to your friends and let them be impressed.

No comments :

Post a Comment

How to turn off the automatic URLs as you type in MS Word

No comments
Mr. Joel of engineering called inquiring about the annoying automatic hyperlink detection on MS Word. He want it to go away. Here was our conversation:

Mr. Joel

Hey cutie, I need help. How can I turn off automatic hyperlink in my MS Word? Is it possible?


Me

[Is this the gay guy?]. Ahhm, sir joel.. yes its possible. Just follow my lead.

- On your MS Word, Click Tools then select Auto Correct Options.
- From the AutoCorrect form, click the tab that says "AutoFormat As You Type"
- Then under "Replace as you type" group, uncheck the tick with label of "Internet and network paths with hyperlinks"

How do I turn off the automatic URLs as you type in MS Word

- To finish, click OK button.

There you have it sir, Did it work?


Mr. Joel

Yes it did! Thanks bro.

No comments :

Post a Comment

ONLY count values on displayed rows in Excel Spreadsheet

No comments
Here my first post - My boss called me today and she was for asking help regarding her spreadsheet that she will be presenting to her Boss (in short The Big Boss). Heres how the conversation went on.

Phone rang....
Me
Hello good morning. IT department. How may I help you?


My Boss
Hey I need help. Please come to my office.


Walking....

Me
Whats the problem?


My Boss
I can't get this spreadsheet Working. I want to get the SUM of all displayed rows only. But when I do "=SUM(A1, A30)", It sum all rows including the hidden rows


Me

Here is what you can do. Instead of using SUM, use the this formula "=SUBTOTAL(109,A1:A30)". The option 109 only SUM the displayed cells in the range


My Boss

Great! thanks for the help!

No comments :

Post a Comment

The office hacker is IN

1 comment
So who is this office hacker? He is just an ordinary guy that everyone calls if they need help on fixing their computers, tricks on excel spreadsheets and word documents, powerpoint presentations and etc.. In short he is the software techie guy.

Sounds nerd?
No he isn't. He is cool and sometimes cooler than most of you. Like most of typical person, he has friends, a lot of them. He like girls, night-outs, traveling, watching movies, massage and coffee breaks

What's this blog for? He just want to extend he's hand to Blogosphere. You might need him one day. He will be sitting here at the other side, always ready to help.

Feel free browsing around my office -- The office hacker


For any questions or topic you want the office hacker to answer, please free to email at foxtrot@officehackery.com

1 comment :

Post a Comment