Office Hackery

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

How to change the starting page number in MS Word

No comments
It was rainy Thursday, classes are suspended all over the metro. I was enjoying my coffee when a user called.

foxtrot
Hi. Good Morning! How may I help you?


Therese
Hi. Can you guide me here. I'm finalizing the table of content of my document and I want to restart the page number of a certain page. How can I do that?


To change the starting page of a particular part of your document, follow these steps:
1. Go to the page where you want to reset the page number.
2. From the Insert Menu, choose Break to display the Break Dialog box.
3. On the Break dialog, click the Next Page radio button then click on OK.

How to change the starting page number in MS Word

4. Right after the section break you added, click on the Insert menu then choose Page Numbers.
6. On the Page Numbers dialog box, click the Format button.
7. Then click on the Start At radio button and indicate the starting page number for the section

restart page number in ms word

8. Click OK to apply changes.

No comments :

Post a Comment

Privacy at workplace: Hide your browser title text

1 comment
Most probably the reason your reading this article now is because many people are looking over on your screen while you surf your favorite websites and that includes your Boss. You can be discrete and prevent co-workers from guessing websites you are currently surfing by hiding the title bar text of websites you open. Unfortunately for IE users, you can only achieve this using a Firefox browsing with a Page Title Eraser plugin.

The Page Title Eraser (PTE) is a simple Mozilla Firefox extension which allows to hide title and icon (favicon.ico) of the selected tab. It provides more privacy at your workplace.

Privacy at workplace: Hide your browser title text

It adds menu item to the page context menu and "Tools" menu items. "Right-click" menu includes a "Hide title" menu item now. Using this item you can hide/show tab and window titles and tab icon. Each tab has its independent instance of this item. Another useful feature of this Add-on is you can replace the title text by any custom text. For example: even if your browsing mafia wars thru facebook you can replace it with "GMail: Inbox". Isn't that clever?

Page Title Eraser Config


Download Page Title Eraser now to try it.

1 comment :

Post a Comment

Convert XLS, DOC, TXT and other document to PDF

No comments
I have discussed several web-based PDF converter before such as PDF to Excel and PDF to Word. Today, I will share another new web based PDF utility called LoopApps that performs a number of tasks. It can convert two or more documents into PDF from your hard drive or from any URL, combined the documents to a single document, then send it to your recipient. LoopApps also has number of advanced features such as publishing and digital signing the converted documents.

Advanced feature is only accessible upon signing up. You can convert multiple formats such as XLS, TXT, RTF, and DOC files into PDF files, or pull directly from URLs you input. If you want to electronically signed your document, LoopApps sign it using ESIGN service for free.

Convert XLS, DOC, TXT and other document to PDF

Try LoopApps via [ Fryan0911]

No comments :

Post a Comment

Feeling Unlucky Today? Your not alone On BadHap

No comments
This morning I found a site where your bad experiences matters. Badhap.com is a online database of bad days that aims to help people feel better about their bad happenings. Through BadHap losers can share their unlucky stories to people with the same experience. To post you stories you must have an account but you can remain anonymous if you want to.

Heres what Badhap.com all about? (Grabbed from the site)

Have you ever had a bad day? Ever made a stupid mistake? Ever felt like you must be the unluckiest person around? And have you ever noticed the only thing that eases the pain is hearing someone else has been there too? Or better yet, has ended up worse?

Well this is where you can read the stories from people who have been there, or far worse. This is where you can share your bad experiences and know somehow, somewhere, you’re making someone feel better about their life.


Stories are group into categories: work, marriage, personal, men, girls and almost anything.

Here are sample entries related to work:


Feeling Unlucky Today? Your not alone On BadHap

Don't let bad day ruin you. Vent it out now ---

No comments :

Post a Comment

Find and delete duplicate files on your hard drive

1 comment
8.45AM Thursday. I was preparing for our Instant Messaging soft launch when a VIP from remote office called me through my cell phone. The conversation started this way...

Mon

Hi foxtrot. Good morning.


foxtrot

Yes sir? How can I help you?


Mon

I'm having a problem with my PC. Its running too slow.


foxtrot

Let me check it. I will now connect to your PC remotely...


Sir, your hard drive free space is too low. That's why it runs slow. I also noticed that you have too many duplicate files and most of them are more than 20MB in size. I can automatically remove the duplicate files for you. Do you want me to proceed?


Mon

Yes please.


How can I quickly find duplicate files? To Dig up all the dupes, I had to use Fast Duplicate File Finder.

Fast Duplicate File Finder can help you quickly find all duplicate files in a folder and on its sub folders. This freeware will compare the content of your files (and not just the filename) so it can find duplicates even if they different file names. It uses fast binary comparison algorithm and has internal preview supporting a lot of image, video, music and text file formats. When the search scan is done, the program shows you all duplicate files in groups and can automatically mark the older files for deletion

Fast Duplicate File Finder Main Screen
Fast Duplicate File Finder Main Screen

Fast Duplicate File Finder Settings
Fast Duplicate File Finder Settings

Dowload Fast Duplicate Finder via Mindgems

1 comment :

Post a Comment

Share your documents online through Embedit.in

No comments
Do you want to share a document with some audience but you dont want them to print or download it? You cannot restrict your documents to view only if you will email it or upload it to media sharing websites. But using the new service from Embedit.in, you can now do it online. Embedit.in was launched Tuesday with a tool that lets users host documents up to 20MB in size. It uses Adobe Flash to power a viewer that lets users flip and scroll through pages in long documents.

Share your documents through Embedit.in

User can customize the appearance and privacy settings. On each embeded document you can disallow printing and downloading. Embedit.in also has its built-in analytics dashboard for each document. This can show how many views a document has, where viewers are from, how many times it was printed or downloaded. It also has a geographical visitors map like Google Analytics.

You can embed pretty much any kind of document.
Documents: Word (DOC/DOCX), Excel (XLS/XLSX), PowerPoint (PPT/PPTX), WPD, ODT, ODP, ODS, PDF
Images: GIF, JPEG, PNG, TIFF, BMP, PSD
Vector Graphics: API, EPS, PS
Text: TXT, RTF, CSV
Code: HTML, SQL, JS
Web: Web pages or other URLs
You can embed files up to 20 MB.

Here a sample document I uploaded to embedit.in -- http://embedit.in/VO8dfkQLj3

No comments :

Post a Comment

Hide windows programs from your boss

No comments
Your currently busy checking and updating your facebook at the office, then suddenly you saw your boss walking towards you? What will you do? close the browser? what if you are playing biotronic and you are in the middle of breaking to the ranks? Don't let your boss ruin the game or any task personally important. Just hide the window.

Yes you can quickly hide a window or group of windows in just a click or keyboard shorcut using a freeware program called Window Hider.

Quickly hide windows programs from your boss

User can give Window Hider a list of programs and its corresponding shortcut keys. When you press the defined shortcut key it automatically hides those windows in your list. Window Hider also, as a recent addition, will hide all the programs in your list if you put your mouse in the upper left hand corner of your window. You can filter the windows by title text as well.

Now don't let your boss ruin your day, download window hider now :)

No comments :

Post a Comment

Copy and Paste Special Characters Made Easy

1 comment
During a Manic Monday at the office, I stumbled upon a cool website where you can click to "copy and paste" special characters that are often use on documents. If you are a Windows user, you are probably using the built-in Character Map facility on Microsoft Windows to do this task. Using CopyPasteCharacter.com, it is now easier to copy and paste special characters.

Copy and Paste Special Characters Made Easy

To copy, just click the character you desire and then paste it on your document processor such as word, excel or notepad.

1 comment :

Post a Comment

How to protect Worksheets in MS Excel

No comments
Thursday afternoon. It was a long day at the office. I had so many rush tasks to finish and tomorrow (Friday) is holiday due to the celebration of Philippine Independence Day. I was about to leave the office when my local line rang. It was Ms. Preno on the calling.

foxtrot

Hello Good afternoon, How can I help you?


Ms. Preno

Fox, I forgot how to protect worksheet in excel. Can you refresh me thoughts? I also want the protection be applied on selected cells only


Excel makes it very easy to protect one or more worksheets in any of your workbooks. By default, when you protect a worksheet, all cells are protected unless specified.

To protect a worksheet, follow these steps:
1. Click Tools menu then select Protection > Protect Sheet
2. On the Protect Sheet dialog, enter a password you want to use.
3. Click OK to apply changes

How to protect Worksheets in MS Excel

As I said earlier, by default all cells are protected. To select cells that should not be protected, follow these steps:
1. Select the cell or cells you want to lock or unlock
2. Click Format menu then select Cells..
3. On the Format Cells dialog, click the protection tab
4. Now tick the Locked checkbox if you want it to be locked or unchecked it if you don't want it to be locked.
5. You can also hide the formula by ticking the hidden checkbox.
6. Click OK to apply changes.

unlock or lock selected cells in Excel

No comments :

Post a Comment

Create software demo using Free Webinaria

No comments
2PM Wednesday afternoon. I was instructed to prepare as short demo to our CRM users but unfortunately I have to attend a more important meeting. So to continue the CRM demo without me, I created a demo video using an opensource software called Webinaria.

Webinaria is a free screen capturing software for the Microsoft Windows operating system. It can record video and audio of the entire screen, a selection or the active window which can be initiated by hotkey or from the program's interface. To start recording, it only takes a click to start screen capturing process. You can make record audio narration (with a connected microphone) or webcam video (with a connected webcam) together in the process.

Screen capture using Free Webinaria

Webinaria also comes with a video editor, where you can edit the recorded video up to the frame level. Now I just have to instruct one of our guy to play the recorded demo at the CRM meeting. Cool ha? who said that you cannot be in two places at the same time? ~ Download the Webinaria

No comments :

Post a Comment

Backup your files using Fling free software

No comments
My friend from United Nations Organization (Philippines) was promoted from Assistant Admin to System Administrator. Ofcourse he called me to bragged about it and at the same time asked for an advice. Since starting today, he will be responsible for systems administration including backup monitoring, he was looking for cheap backup solution for all their workstations (yes, not veritas).

So as a good friend, I gave him more or should I say less? because it is free. I forwarded him a free backup and file transfer tool which was blogged here. The software is called Fling.

Here is brief description from Fling's website:

Fling is software to help you automate uploading or transferring files. It is typically used to maintain a web site on a remote hosted server or to automate backup of folders. The software supports both file transfer protocol (ftp) and network file transfer.


Fling FTP is completely free and designed to be very easy and intuitive to use.

Backup your files using Fling free software

You can directly download fling from this address.

No comments :

Post a Comment

Change the number of recently used file list in Word

No comments
MS Word allows users to increase the number of most recently used file displayed under the File Menu (By default it is 4). You usually do this if you want Word to store your most recently opened files. But there is a limitation, you can only put 0 to 9 as values.

To Change the number of recently used file list in Word, just follow these steps.

1. Click Tools Menu, then select Options.

2. On the options dialog, Go to General Tab.

3. Look for the checkbox with label of "Recently used file list" then make sure to check it.

Change the number of recently used file list in Word

4. Put the number of used file to list (maximum is 9).

5. Click OK to apply changes.

No comments :

Post a Comment

List the Most Recent used files using MS Word Macro

No comments
If we want to quickly open recently used document in MS word, we usually look for it on the Most Recent Used (MRU) files list under File Menu. A more cooler way to retrieve it is using VBA macro. If your not into office programming there are really no use for this trick (that's why I categorized it as a trick).

If you want to try it, just copy and paste the following code on your VBA Editor.


Sub GetMostRecentUsedFiles()
Dim x As Integer

For x = 1 To RecentFiles.Count
Selection.TypeText Text:=RecentFiles(x).Name
Selection.TypeParagraph
Next
End Sub


To access VBA editor, Go to Tools Menu, select Macro then Visual Basic Editor.

No comments :

Post a Comment

Comic Strip #15 (6 best pool stunts)

No comments
High board diving styles

No comments :

Post a Comment

Modify Custom Dictionaries of MS Word

1 comment
One of MS Word strength is the capability to spell-check documents. Aside from built-in spell-check, you can also add custom entries on the dictionary. Usually we add an entry by right+clicking the word with red curl line and selecting "Add dictionary" from the context menu.

If you want to edit the custom dictionary to add multiple entries, edit or delete existing, follow these steps.

Word 2007

1. Click the Office button and then click Word Options.
2. On the Word Options dialog box click Proofing then lick the Custom Dictionaries button.
3. In the list of dictionaries, you can select the one you want to edit or delete or add new one.

Word 2003
1. Go to Tools Menu then click Options.
2. On the options dialog box, Select the "Spelling & Grammar" tab.
3. Click the "Custom Dictionaries" button.
4. In the list of dictionaries, you can select the one you want to edit or delete or add new one.

Older versions
1. Go to Tools Menu then click Options.
2. On the options dialog box, Select the "Spelling & Grammar" tab.
3. Click the "Dictionaries" button.
4. In the list of dictionaries, you can select the one you want to edit or delete or add new one.

Modify Custom Dictionaries of MS Word

1 comment :

Post a Comment

Change the default file location in MS Excel

No comments
This morning, we finished consolidating all our Team's documents in one shared folder. Our boss instructed us to set our MS excel to point the common shared folder so that every time we open a document the default file location will be the team folder.

To change the default file location in MS Excel, do the following steps:

1. Go to Tools Menu then click Options.
2. From the Options dialog box, click the General tab.
3. At the bottom, look for "Default file location" text box.

Change the default file location in MS Excel

4. Replace it with the new default folder.
5. Click OK to save changes.

No comments :

Post a Comment

Comic Strip #14

No comments

No comments :

Post a Comment

Save and restore the positions of your windows icons

No comments
Every computer user has its own preference when it comes to organizing their desktop. This includes arranging application icons that way they want it. Now using a free software, you can save and later restore the locations of your desktop icons. The free software is called DesktopOK.

Using DestopOK, you can save your dearest icon locations for each screen resolution.



You don't have to install DesktopOK. Just download the software and double-click the application to run it.

You can download this cool free software from here.

No comments :

Post a Comment

MS Excel Viewer

No comments
I was having a lunch when my cellphone rang. The caller id displays my mom's number so being a good son I took the call immediately.

foxtrot

Hi mom! How are you?


Mom

I'm OK son. I need help regarding computers. My friend and I are trying to open an attachment with an extension of XLS but we can't open it. What kind of file is it?


foxtrot

Mom, it is an excel file. You need a Microsoft excel to open it.


Mom

I see. But my friend's PC don't have Excel.


foxtrot

No worries. You can download a light weight excel viewer over the internet.



If you need to view an excel but don't have the MS office installed, you can use a free excel viewer (The file size is about 10MB).

No comments :

Post a Comment

How to remove duplicate cells using Excel Macro

No comments
My boss gave me a home assignment yesterday. She forwarded me a workbook that contains user modification request. The workbook contains about 500+ lines. I need to apply new formatting on it and remove all duplicate values. On my previous blog post, I already showed you how to generate a unique list of entries. Today I will share another way to remove duplicate cells using VBA macro.

To create add a macro, follow these steps:
1. On your Excel's Tools Menu, choose Macro then Visual Basic Editor
2. Double-click ThisWorkbook from the Project Explorer on your left side.
3. Copy and paste the following code on right pane.

Sub DelDuplicate()
Dim rngSrc As Range
Dim iRows As Integer
Dim Row As Integer
Dim Row2 As Integer
Dim Col As Integer
Dim J As Integer, K As Integer

Application.ScreenUpdating = False
Set rngSrc = ActiveSheet.Range(ActiveWindow.Selection.Address)

iRows = rngSrc.Rows.Count
Row = rngSrc.Row
Row2 = Row + iRows - 1
Col = rngSrc.Column

'Start wiping out duplicates
For J = Row To (Row2 - 1)
If Cells(J, Col) > "" Then
For K = (J + 1) To Row2
If Cells(J, Col) = Cells(K, Col) Then
Cells(K, Col) = ""
End If
Next K
End If
Next J

'Remove cells that are empty
For J = Row2 To Row Step -1
If Cells(J, Col) = "" Then
Cells(J, Col).Delete xlShiftUp
End If
Next J
Application.ScreenUpdating = True
End Sub

4. Now switch to your workbook. Highlight the cells you want to filter.
5. Go back to the VBA editor then click the play button on the toolbar or from the menu click Run > Run Sub.

No comments :

Post a Comment

Comic Strip #13

No comments

No comments :

Post a Comment

Add a calendar on your desktop wallpaper

No comments
Are you wondering how those professional looking wallpapers with calendar are being done? You can now do it yourself by using this free online wallpaper tool.

Online tool to Add a calendar on your desktop wallpaper


Here a sample wide-screen wallpaper created from the online tool.

desktop wallpaper with calendar included

To tool is simple to use. Just select the wallpaper file you want to be process then choose the format and submit it. You can have your wallpaper with calendar in seconds depending on its size.

No comments :

Post a Comment

How to open multiple workbooks at once in MS Excel

No comments
For today's MS Excel Tip, I will show you how to open multiple workbooks in one step. Although this Excel's feature is not so unique because you can open several workbooks by double-clicking each workbook you want to open, it still worth to mention.

To open multiple workbooks in one step, follow this procedure.

1. From your file menu, click Open.
2. Instead of double-clicking the file, press [CTRL] key then click every file you want to open.

How to open multiple workbooks at once in MS Excel

3. Lastly, click the Open button to open all selected workbooks.

No comments :

Post a Comment

Convert comma or tab delimited Text Into a Table in MS Word

No comments
I arrived much earlier today because my car is under coding. To start my day, I browsed my emails and found an interesting problem from a client.


Hi foxtrot. I received your email yesterday regarding the comma-delimited file of our all transactions for the last month that we requested from you. However, can you send me a copy that is on table format? Its for our VP for operation. Thanks



In MS Word, you can convert comma or tab delimited set of text into table. How? follow this procedure.

1. On your MS Word document, select the delimited text you want to be converted.
2. Now you can either click the "Insert Table" button on the toolbar or from the Table menu, click Insert > Table.
3. The text should now be displayed as table

No comments :

Post a Comment

Comic Strip #12

No comments

No comments :

Post a Comment

How to convert Plain Text Email to HTML in Outlook

No comments
By default the format of email you received is based on the format the sender sent it. So if the sender sent it as plain text then you can open it as plain text. And when you click the reply button, it also by default use the current format.

If you don't like plain text format you can reply to HTML format by:

1. After clicking the reply button, Go to Options > Format.
2. Choose HTML format to reply to HTML

How to convert Plain Text Email to HTML in Outlook

No comments :

Post a Comment

MS Outlook: Quickly locate a user in your address book

No comments
I was trying to send an email to several recipients when I forgot the complete names of some of them. Most outlook users will click the [To..] button to find the name of that person but there is a faster way through a shortcut.

To quickly locate a user in your address book or a company address book, just type a portion of the name or alias then press [CTRL] + [K]. For example, if you wish to send an email to Manny Paquaio, you can just type "Man Paq" and then press [CTRL] + [K] and outlook will automatically complete the name Manny Paquaio, unless your address book contains several names with "Man Paq".

No comments :

Post a Comment

How to Open Existing PST file in Outlook

No comments
I was the first person to arrive our office at 7AM. The phone from technical support group was ringing and as an SOP we need to answer it in 3 rings. The caller was asking for technical support regarding outlook. So i tried to listen to him.

Henry

foxtrot. I have an old Outlook PST file that I want to open on my outlook 2007. Can you help me out?


foxtrot

Sure sir. Please follow my lead.


To open existing PST file in outlook,
follow these steps:
1. Click on your File Menu, then choose Open > Outlook Data File...

How to Open Existing PST file in Outlook

2. Locate for the PST file then click Open

No comments :

Post a Comment

Comic Strip #11

No comments

No comments :

Post a Comment

Microsoft Outlook plug-in: Forgotten Attachment Detector

No comments
I bet you already experience sending an email that was intended to be sent with attachment, but you forgot to do so. I've done that myself a hundred times. So for today's free tool download, I will introduce you to "Forgotten Attachment Detector" outlook plugin.

What it do is analyzes your email for clues that you really meant to attach file. When you send an email FAD checks it for keywords that indicate you’ve forgotten to attach an attachment. If it detects this, it notifies you and gives you a chance to correct any mistakes

Forgotten Attachment Reminder

Download this great outlook plug in from here.

No comments :

Post a Comment

Location of MS Word templates

1 comment
I was walking at the hallway when I bumped to Cory. She open up a conversation.

Cory

Hi! Can I ask one quick question?


foxtrot

Sure. What is it?


Cory

Where can I find the MS Word templates? I would like to copy them.


To find where the MS Word templates are stored, follow my lead.

1. From the Tools menu choose options then Word displays the Options dialog box.
2. Click the File Locations tab then choose User Templates from the list.
3. If you want to locate it click Modify button.

Location of MS Word templates

If you are using Word version 2007:

1. Click the Office button and then click Word Options to display the Word Options dialog box.
2. Click Advanced at the left side of the dialog box.
3. Scroll to the bottom of the available options and click the File Locations button. Word displays the File Locations dialog box.
4. From the list, choose User Templates.
5. If you want to locate it click Modify button.

1 comment :

Post a Comment

Display decimal in minutes and seconds in MS Excel

No comments
Tuesday sickness. Another reason to be sick is the person calling on my local line. But of course, I don't have a choice but to answer it.

foxtrot

Hello this is foxtrot. How may I help you?


Alfred

Hi. I have problem on my worksheet. I need to submit it today. I hope you can give a solution. I divided two numbers to get the minutes but the result was decimal. I like it to be displayed in Minutes and seconds.



If you have the same problem, here is a solution. You can display a decimal in minutes and seconds by following these steps:

1. Divide the decimal value by 1440.
2. Right+click the cell that has the result the click format.
3. On the format dialog, choose custom then "mm:ss".

No comments :

Post a Comment

Comic Strip #10

No comments

No comments :

Post a Comment

How to Embed Fonts by Default in your MS Word documents

No comments
Lunch break at the canteen. A colleague from accounting approach me while eating my sinigang na hipon. His concern was.

Edwin
Hey bro. I created a word document which I used NiƱa as my default font. But when I sent it to my boss, her MS word doesn't view my document "as is". It changes the font to times new roman. How can I avoid this?


foxtrot
You can embed your font on the word document.



TrueType fonts can be embedded in a Word document so that it can be properly viewed on systems that don't have the font installed. To embed font by default in your MS Word document, follow these steps.

1. Click Tools menu then Options.
2. On the option dialog box, click the Save tab.
3. Check the "Embed TrueType fonts" then click OK to apply changes.

How to Embed Fonts by Default in your MS Word documents

No comments :

Post a Comment

How to Insert a Sound File in Your Worksheet

No comments
8:43AM, Monday morning. My favorite day among weekdays. My local line rang, and the caller is an outside line.

foxtrot
Hello good morning. This this foxtrot, how may I help you?



Naomi
Hello sir, This is Naomi from PASI Microsoft. I was sending an email regarding your request last week but my email is keep on bouncing back. It has excel file and a MP3 sound file.


foxtrot
Hi naomi, our email is blocking attached MP3 files. I suggest that you insert the sound file in you worksheet then resend your email with only the worksheet attached.





MS Excel allows you to attach sound file in your worksheet. To attached one on your worksheet, follow the instructions below:

1. Select the cell which you want the sound to be inserted.
2. From the menu, click Insert > Object... then Object dialog box will appear
3. Click on the Create from File tab then click browse to locate for the sound file

How to Insert a Sound File in Your Worksheet

4. Click on OK. The sound file is inserted in your document.

No comments :

Post a Comment

How to Transpose Two Words in MS Word

No comments
Last week, HR forwared me a list of employees which has the following format

Firstname + (space) + Lastname


The document is to exported to our Customer Relation Management System (CRM) but my problem is it should on the following format.

LastName + (space) + Firstname

So to make my life easier, I have to transpose each name to the new format. I did it using a Macro.


To transpose two words follow these steps:

1. Open you Word document.
2. Go to Tools > Macro > Visual Basic Editor
3. Add the following codes on the VBA editor

Sub Transpose()
Selection.MoveLeft Unit:=wdWord, Count:=1, Extend:=wdExtend
Selection.Cut
Selection.MoveRight Unit:=wdWord, Count:=1
Selection.Paste
Selection.MoveLeft Unit:=wdWord, Count:=1
End Sub


4. Now go back at your document, then put your cursor between the word you want to transpose.
5. Press [ALT]+[F8] and when the macro dialog box appears, just press [enter].

How to Transpose Two Words in MS Word

No comments :

Post a Comment