Category: Microsoft Office

Microsoft Office Word, Excel and Power Point Basics, Tutorials, Tips and tricks

VBA macro to remove duplicates from each individual column [Excel]

vba-macro-remove-duplicates-each-column

VBA macro to remove duplicates from each individual column in excel sheet. This simple macro,  just single line syntax, treats each column as a separate entity and removes all duplicates from each column and keeps only unique values. Also see VBA macro to delete empty columns VBA macro code to remove duplicates from each column

If you want […]

VBA macro to remove special characters from a string in excel

excel-macro-output-remove-special-characters

Simple VBA macro code to remove special characters from a string in excel. You can remove either all special characters or choose which special characters to remove from the string. This macro retrieves each character from the string and checks whether it belongs to A-Z,a-z,0-9 or a space.If it belongs then it stores them into another […]

How to show developer tab in MS word 2007 ribbon?

Show-Developer-tab-option-MS-word-2007

To show/add developer tab in MS word 2007 ribbon, follow below steps. 1. Click on office button, you will get options like shown in below figure. 2. Click “Word options”  at bottom 3. Click Popular button at top-left 4. On right-side, check “Show Developer tab in the ribbon” option 5. Click OK button Now, you can see Developer […]

How to change the page orientation of a single page in MS word 2007?

change-single-page-orientation-MS-office-2007

Changing page orientation of all pages, either from Landscape to Portrait or from Portrait to Landscape, in MS word is easy. You can do it directly with Page layout -> Orientation option. But, if you want to change the page orientation of a single page in a document or if you want to keep landscape orientation […]