How to check RAM size in Ubuntu using commands

Check RAM Size in Ubuntu

Sometime, we may need to know the System’s RAM size to check whether it meets a software’s requirements or to find available free RAM during application

To view the total available RAM type the following command

free

Output – (displays the total available RAM in KB)

total          used        free      shared  buff/cache   available
Mem:        1014488      183236      194352        5708      636900      787780
Swap:             0           0           0

Continue reading

How to check ubuntu a 32 bit or 64 bit?

feature_img_ubuntu_32bit_or_64bit

Sometime you may need to know whether you are running a 32 bit or 64 bit Operating System to choose which version of software to download.

There are prominent 2 ways to find out

uname -a

if it is a 32bit Ubuntu, the output looks similar to below. Highlighted i686 or i386 identifies OS is 32bit

Linux UbuntuBox 3.19.0-59-generic #66~14.04.1-Ubuntu SMP Fri May 13 17:27:10 UTC 2016 i686 i686 i386 GNU/Linux

Continue reading

3 Useful Excel Tips For Dummies – How-To

All of us who use computer at a point of time come across a situation to use Excel due to its efficient way of handling data. Listed are few excel tips for beginners who starts working with excel.

For Newbies :

What is Excel?

Excel is an electronic spreadsheet program used for storing, organizing and manipulating data.

Tip 1 : Wrap the Text

Wrapping a text feature helps to make the content visible in a cell without increasing the width of the cell.

Step 1: Select the text to be wrapped.

excel word wrap

Step 2:  Click Wrap text button (as shown in the image)

Continue reading

How to disable right click in Windows xp / Windows 7

If you do not want to give right click access to the users for some security reasons. Follow the below mentioned steps:

Step 1:
Goto “Start -> Run” and Type “gpedt.msc” (this will open Local Group Policy Editor)

Step 2:
In the left side of the editor, select
“User Configuration -> Administrative Templates -> Windows Components -> Windows Explorer”

Continue reading

Remove Text Formatting from Gmail – Copy/Paste – Tips and Trick

When we copy a text from a web page or other source and paste them in a Gmail,the formating of the original text would be same.Some times it may be annoying we need it to be normal.In Gmail there is a simple way by just selecting the text’s and clicking the button ‘Tx'(as in image below) would format the texts to normal format.

Continue reading

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.