Tag Archives: Microsoft Office 2007 Tips Tricks

Quickly enable or disable Office Addins

Its easy for anybody who uses Microsoft Office extensively to have lot of addins for each of the products right from excel to ms project but to manage them is difficult. Any time you want to enable or disable addins you need to open the Office application  and then change it. This is pretty difficult task. Topal Enable / disable ...

Read More »

Free Download Microsoft Office 2007 SP2

In tha latest press release Jane Liles of MS announced SP2 release for Microsoft office 2007 which is available as separate download for everybody. One of the important aspect of this update is the support for OpenDocument format in Word, Excel and PowerPoint 2007 i.e. to read and write  any document in the ODF format can be achieved without use ...

Read More »

Scroll to Quickly move between Ribbon menu : Office 2007

Ribbon menu is one of the exclusive feature of Microsoft Office 2007. Though there are lot many items you can see compared to previous menu but still you need to switch between different tabs. Today while working in office I accidently scrolled my mouse and it actually switched tabbed menus so fast. Yup you just need to move your mouse ...

Read More »

Theme Builder : Create personalized themes for Microsoft Office Files

Theme builder is a beta tool from Microsoft Office which allows you to create custom themes so it can be applied to all the documents in your office to maintain uniformity in your document colors, styles etc. This tool is particularly for Office 2007 Products i.e. Word, Excel, Powerpoint, Outlook. Remember Theme is different from template. Theme is meant just ...

Read More »

Notepad 2008 : An advanced notepad with Microsoft office Looks

If you are tried of using traditional Notepad which has nothing buy all text and simple menus, its time you need to try Notepad 2008 which comes with an advanced menu which is of same format as MS office 2007 have – Ribbon based. Features what you get here are: Ribbon based menu Tabs for opening multiple tabs Advanced Formatting ...

Read More »

Moving Quickly between parts of Excel sheets with Named Ranges

his is an excellent way in case you have big excel sheets and you need to move from one part of sheet to another to check or pickup data. I came out with this when I was working with excel sheets ( MS Office 2007 )  in sharepoint 2007  where named ranges are actually helpful if you want to hide ...

Read More »

How to auto generate months in Microsoft Office Excel 2007

I was preparing my accounts for this financial year and had to do calculations month by month. Now it was really tiring to type each month one by one. I wanted to generate all the months automatically and I found how to do it. Damn Easy Here are the steps. Select a cell in excel , right click and select ...

Read More »

9 Tips to increase your productivity with Excel 2007 [ Office ]

Welcome to Office Tips and in this post we will learn about some of the features, tips and tricks of Microsoft Office 2007 Excel Sheets which we usually miss or don’t bother to use without even knowing how beneficial they can be. Here are some useful points which definitely ads on to your excel skills. Right from Choosing cell styles ...

Read More »

Create Custom Shortcuts for Office PowerPoint

Shortcut Manager for PowerPoint is an addon for Microsoft Office Powerpoint which lets you create Shortcut menu items and already recorded Macros.  Shortcut for Macros is very useful as PowerPoint does not allow you to launch it directly, It includes the password protected macros also. One of the annoyance of PowerPoint Slide show is the escape key. Any slideshow when ...

Read More »

Word 2007 : 15 Configuration tips before you start using it

Word 2007 Options

This article is a a beginners guide for Office Words which will tell you some essential configurations and options you should setup before you make your first Microsoft Word document using Office 2007. Already started ? No worries You can still do it. These points can help you avoiding some of the common problems which we face at the end ...

Read More »

How to select text with similar formatting in Word 2010, 2007

Word menu to select text with similar formating

Suppose If you want to select only paragraphs which are under 5 different headers ( h2 tags ) but not the headers itself how you go about it. Microsoft Office Word  has an useful feature which allows you to select similar formatted text in just one click. See the image below. I have 3 headers and under every header I ...

Read More »

How to add a Drop Cap in Office Word 2010, 2007

Drop Cap means creating a large capital letter at the beginning of a paragraph. This is very often used in many of the e-books in start of a new chapter. What is the use of it ? Well as far as I can understand its one of the formatting technique which is used to draw attention when reading e-books or ...

Read More »