Office Tips & Tricks

Some of the best tips and tricks for Microsoft Office 365, Office 2019, Office 2016, Office 2013, and office 2010. Learn about Office Products

Smart Paste from Notepad to Excel

By default when you paste something in excel it gets copied in just one cell which might not be just your requirement. Generally if you paste something in excel it will...

How to quickly create base power point slides using Notepad

Lets say you need to create lot of slides for a presentation and you have all the main headings and sub points in your mind. Now if you try the regular...

How to quickly create tables in One Note

One note is an excellent application which allows you to write notes during meeting or any conversation save it as you write. There is no save button for it.  However If...
Paste Special in Office Excel

How to copy only comments from a cell in Excel 2010 / 2007

This is a very handy trick if you just want to copy comment from already filled in and formatted cell to another cell in excel without additional formatting.The fist step is...

Manage named ranges better with Name Manager in Excel 2007

Named Ranges are set of selected cells in Microsoft office excel 2007 which can be identified by a unique name. These serve a good purpose when you want to refer across...

How to quickly add, multiply, subtract and divide 2 Excel columns

Here is another quick tip from excels special paste function. If you want to add , multiply, devide or subtract 2 columns in an excel sheet quickly using the special function...

Transpose Excel cells ( Row to Column and reverse ) quickly

This is a nice  office trick if you want to transpose or change set of cells in excel files from row to column or column to row quickly.  Here are the...

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...

You need to purge to actually delete mails in Microsoft Outlook 2007

Its been few days I had started using IMAP and Outlook 2007 for my Gmail accounts and I was actually surprised to see that the mails that I used to delete...

Cannot find sent mails in Outlook 2007 ?

I was surprised to see that Outlook was not saving my sent mails in the sent folder. That was really annoying as I use IMAP of Gmail with Outlook which synchronizes...

How to Hide / Remove Gmail Label Folders using IMAP and Outlook 2007 /...

Using IMAP and Oultook cold be the best way to read mails as its a synchronized or call it as both ways. You change in outlook and it gets reflected on...

Moving / Transfer mail from one Gmail Account to other using IMAP and Outlook...

This is a nice trick and pretty useful in case you want to move / transfer all your mails from one Gmail ( virtually any mail account which supports IMAP )...

Recent Posts