How to make all content visible in a cell – Wrap Text Microsoft Excel

When we type some long text in a excel column it would overlap the other columns.To avoid this and make the full content visible there is a  Microsoft office excel tip.

UnWarpped Text
Select the cell(s) to wrap.
ToWarp
click on Home Tab Wrap Text.
We can also see the Microsoft help describing the Wrap Text feature in excel.
WarppedText
That’s it.Now the cell is fully visible in the Excel 2007 file.

How to Convert a Rows to Columns – Columns to Rows in Excel

There are times we need to convert excel rows to columns.Excel inbuilt has a option to do this in easy steps.

Rows to Columns

Step 1 : Select the all rows to be converted as columns and copy them.

Copy rows in excel

Step 2 : Click in any empty cell and right click and select  Paste Special option from it.

Paste-Special

Step 3 : A popup could come, from it check Transpose.

Transpose

That’s it.See the result.

Rows to Column

The same steps applies for converting columns to rows.

How to Check if someone else is using/hacked my Gmail account

Gmail gives a secure feature to monitor and protect your email account.It provides you with latest 10 IP address that you have logged into the account.By this you can check is some else have logged in your Gmail account.And also it provides the current open location of your Gmail account.

To check these details scroll down your email page you would notice the “Last account activity” label and the Details link.

Click on details link to check the IP addresses from where the gmail account was accessed.There is also a “Sign out all other sessions” button which would logout all the other open locations.

It is better to immediately change your password and security question,to ensure no would further use your account.

By this feature Gmail helps us to protect your account from hackers.

How to prevent browser from caching a page in rails

I used devise for authentication in my rails project. After I signed out; I clicked the back button in the browser; Oh!!! the browser was showing the previous page from which I clicked ‘sign out’.  I tested this and found that the browser is caching the page.

I used firebug to analyze the project page(s). I found that the

no-cahe is added

To add ‘no-cache’, I added the following lines @ the application_controller.rb file

before_filter :set_no_cache

and the function

def set_no_cache
response.headers["Cache-Control"] = "no-cache, no-store, max-age=0, must-revalidate"
response.headers["Pragma"] = "no-cache"
response.headers["Expires"] = "Fri, 01 Jan 1990 00:00:00 GMT"
end

Restarted the server and found that after I signout and hit ‘back button’ of the browser; the page is redirected to the sign_in page. [ I have configured devise to redirect to sign_in when the session is not valid].

Hope this helps rails users like me.

and I analyzed the rails project page(s) using firebug andThe firebug analyzed results

no-cache implemeted

How to share files between Linux systems

Even for a newbie, the Giver application will be very helpful in sharing files between Linux systems. Giver has been hosted in Google code. Its easy to install and very easy to use. I will explain you how to install and use Giver. I am using the application in Ubuntu 10.04.

Installation

  1. Open the ‘Terminal
  2. Enter the following command. sudo apt-get install giver
  3. This will install the application under Applications -> Internet menu

Use Giver

  • Applications -> Internet -> Giver or enter ‘giver‘ in the terminal
  • Giver application showing the list of Recipients for you

This opens up the Giver and you will see Giver iconGiver Icon in the notification area in the notification area

  • The Giver window will show the list of computers in which Giver is running currently.
  • To send a file to a computer. click on that computer from the list, will popup a menu asking either to send a file or folder.
  • Choose necessary option to show the Open dialog box, [ I am choosing ‘Send a file’ ]Choose the file and click open.
  • The user in the selected computer will be prompted to either accept the file or decline.
  • After ‘Accept’ button is clicked, the file transfer gets started. once transfer is done both the users were notified.

Sender will be intimated with Successful transfer message

  • You can configure ‘Giver’ where to save the files received; by opening up its preferences. Default location is user ‘Desktop’
  • To open the ‘Preferences’, right click on the Giver icon in the notification area and select ‘Preferences’ Open Giver Preferences
  • The Preferences dialog box will open. You can change your giver name to be displayed for all your recipients, your profile picture and the location where all your received files/ folders are to be stored. After configuring click ‘Close’

How to Verify an Email address is valid Or Check if an Email address is available?

At times you would want to verify the sender is valid or not of the mail received.And also you may want to check an email address is available or already taken.VerifyEmailAddress helps us to do them.

Just go http://www.verifyemailaddress.org and type an email address you want to check.

It Verifies the email id and gives the result as valid or invalid email address.

Invalid Check Result

Valid Check Result

How to Attach And Send An Executable (.exe file) in Gmail – Trick

Gmail would not allow to attach .exe format file.If you try to attach an executable file(.exe) then Gmail would prompt a message saying “file is an executable file. For security reasons, Gmail does not allow you to send this type of file”.

gmail exe file

But still if you need to send a executable file in Gmail there are some workarounds

Rename the file

Rename the file without .exe extension.For eg if the file is “test.exe” change it to “test.txt” and attach in gmail for sending.
Communicate in the receiver side that they have to change it to .exe extension.

Compress the file

Compress the file using any tool and the attach it in gmail.For Eg if you compress using the winrar tool it will be compressed and extension would be “test.rar” which Gmail would allow to be attached and sent.

These workarounds would violate Google policies.Thus if you wish to go with Google,upload the file in some file sharing website and give the link in the mail.

How to Open .docx/.xlsx/.pptx Extension File Without Microsoft Office Installed

The later versions of Microsoft Office has the word document extension as .docx instead of the older extension .doc.Suppose if you want to open a word document with .docx extension but you don’t have the latest/compatible version to open them,there are different ways to view them.

View using older Microsoft office – Microsoft Office Compatibility Pack

Microsoft has a compatible pack to view newer version documents in older version office.The Microsoft Office Compatibility Pack can be downloaded from here

View using Google Docs

The document can be uploaded to Google docs and viewed.Thus no softwares have to be installed.

View using Open Office

Open Office is a open-source office suite.By installing Open Office the documents can be viewed
through it.

View using on-line tools or converters

There are several on-line tools and converters available which can be downloaded and used to convert the documents.
On line Tools : zamzar ,ThinkFree
Converter Softwares : docx-converter , docx2doc

Can We Format(Bold/Italic) Text in the GTalk Chat Window – Trick

Yes it is true that we can format the text when we type in Gtalk chat window.Even though we dont have buttons to make a text bold or Italic,there is a easy way to do that.
To make the text bold format we have to add asterisks(*) in front and end of the word(s).
Eg         : *I am in bold*
Result : I am in bold

To make the text italic format we have to add underscore(_) in front and end of the word(s).
Eg         : _I am in italic_
Result : I am in italic

Combination of both bold and italic
Eg         :  *_I am in bold and italic_*
Result :  I am in bold and italic