45 subscribers

Windows Quirks, Email, Internet Gotchas
  |  Software Dev  |  Science Stuff  |  Travel  |  Golf  |  Entertainment  |  Mindfulness  |  Finance and Investing  |  Austin  |  India  |  Diet, Health  |  Petitions, Causes  |  Miscellaneous  |  

Grouping column by its values – and getting an accurate count (or sum)

Select the Column
Click the Data tab (or press Alt-A on keyboard)
Click Subtotal icon (or press B on keyboard)

To NOT show the wrapped text as ############ in excel | Posted on by Anuj Varma

To NOT show the wrapped text as ############ in excel
The cell formatting is set to text as it should be. Change it to SPECIAL.. That fixes it.

Winning eBay Auctions | Posted on by Anuj Varma

Do not place a bid – wait till the last 10 seconds of the auction.
Think of your MAX bid – a lot higher than the current bid. This is because – in the last few seconds – everyone will try … Continue reading

Adding CHECK mark symbols in Powerpoint | Posted on by Anuj Varma

“Insert” from the top menu of PowerPoint

“Symbol” from the set of options.

Find “Wingdings” from the “Font” drop-down menu.

The check mark symbol is towards the end of the list of wingdings font symbols.
That’s it  – pick the check mark … Continue reading

Changing Outlook’s Theme–making it less bright | Posted on by Anuj Varma

Outlook’s default color scheme is far too bright and hurts the eyes. Fortunately, some other themes are built into the product. To get to these options,  navigate from the File menu
File-> Options-> General
And change the color scheme as shown below:
  … Continue reading

Insert documents in Outlook Body | Posted on by Anuj Varma

For some reason, I prefer the inserts to be in the body as opposed to attachments. They are easier to get to (by the recipient) and they can be placed inside tables etc.- making the message more readable.
By default, Outlook … Continue reading

In Excel (2007 and above), place each list of values in its own column. Now,

Select cells in first list, then hold CTRL key and then select the second
Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values. At this … Continue reading

Multiple iphones (iOS devices) – One PC | Posted on by Anuj Varma

How do you sync multiple devices to one iTunes? 
In general, one iTunes instance = one device – try and change devices and you have a nightmare on your hands. However, I came across a method where I could at … Continue reading

Finding out your full domain and username on windows | Posted on by Anuj Varma

From a DOS prompt, type echo %USERNAME% /domain . This should return your username as registered in the current domain.
Full Domain Name
I can never  remember the full domain name – an easy way to look it up is to type … Continue reading

Inserting code snippets into MS Word documents | Posted on by Anuj Varma

Step 1 – Insert Object from MS Word’s INSERT menu. Select OBJECT from the drop-down (as opposed to ‘Text from file’).

Step 2 – You should see an ‘Object’ pop-up – that contains a list of ‘object types’ that you can … Continue reading