Currently browsing Entries tagged with excel tips

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 steps

Select the cells and copy it.
Now select anywhere you want to transpose and hit ALT + E > S  and then select Transpose.

Related : [...]

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




  • Recent Comments:

    • michael: how do you do this on vista? i saw a commnet referring to this but i couldnt find where you wrote the answer
    • Jahad: hi is there a way of removing this as i installed it but a certain game wouldn’t run without directx...
    • AaronTigno: i got the (The application for project ‘C:\Program Files\Microsoft DirectX SDK (April...
    • pitas: very good
    • kimmy: U can also try this web site:http://www.freesmsfrompctomobile.co m
    • Fernando: I started using this over the weekend with my son’s laptop. Unfortunately the problem I found with...
    • Garth: I’ve seen a better solution that does this and much more. Check out http://roohit.com It is so versatile...
    • VLadimir: fefewf
    • Ricardo Ferreira: I would rather kill myself than buy windows, good lord, lock me up already, viva le Pirate Bay!
    • Busnut: Great buzz about Drop Box. Please send me an invite.

Technology Blogs - Blog Top Sites