Thursday, November 28, 2013

Auto-fit columns to see all the text in excel

Excel Tip: Auto-Fit Columns

Here's a quick tip for all you Excel fans.

One of the more tedious things to do in Excel is to correctly set the width of the columns to fit to the text that you are typing. For example:
We need to fit the columns to the text so that all of the text can be seen. To do this quickly, hover over the right edge of the column header until your mouse turns into a doublesided left-right arrow. Then double click to have the column Auto-Fit quickly to the text.

If you have multiple columns that need to be Auto-Fit, select all of the columns you need to Auto-Fit and then follow the same procedure by double clicking on any of the selected columns' dividers. Just like that, your columns are all auto-fitted!


Tip courtesy: 
http://tpltechnology.blogspot.in/2008/08/excel-tip-auto-fit-columns.html

\m/

Tuesday, June 25, 2013

Inserting pdf into a latex file

Hi all,
If you have a pdf file and you need to insert it into another pdf file/other files that you created using latex, then you can do two things:

1. Either use the
                \usepackage{pdfpages}
  and then use the
                 \includepdf[scale=0.82]{filename.pdf}
  to insert your pdf

2. You can also use the \includegraphics environment to insert the pdf.


\begin{figure}
 \centering
 \includegraphics[scale=0.8]{filename.pdf}
\end{figure}

The second method was found to be more user friendly and the pdf was automatically aligned to the center, while the first one didnt.

Hope this helped.
Ciao

Friday, June 14, 2013

How to remove programs that automatically startup with system boot in Windows

Hi,
My Windows had become slow to startup and I sensed that the reason might be Skype that was taking a hell lot of time to start. So I removed it from the startup programs list by following the steps given below:

Type msconfig in Run dialog box and press enter.
Select the Startup programs tab and uncheck Skpye!

Hurray!
ciao

Sunday, June 9, 2013

Automatic spell check in Kile

Hi all,

I recently came to know that my kile version 2.0.85 has the option of enabling automatic spell check.
Go to Tools-> Enable Automatic Spell Check
Voila! :)

ciao

Wednesday, March 20, 2013

Configure QuickBuild in KILE

While using kile I had a tough time pressing
alt+2 (latex)
alt+4 (dvi2ps)
alt+8 (ps2pdf)
in the given order for good compiling and then going on to open adobe or document viewer to view my pdf document.
I figured out that Configuring Kile QuickBuild option will do the trick to do the above steps automatically in sequence.

Kile-> Settings -> Configure Kile
In the window that opens up, open Build under the Tools tab.
In this, select the commands under Tool drop down list in the desired order.

In order to enable the Viewpdf option you may have to install the ocular pdf viewer.

Njoy!

Saturday, March 2, 2013

Passwords with special characters like & / etc while setting proxy in ubuntu

While using terminal in ubuntu, there arise situations where u need to type out your passwords.
URL encode your password to use them.

For example: Lets your password be 123@123
to use in
http_proxy="username:password@10.106.80:80"
URL encode the password as

123%40123

as the URL encoding of @ is %40
URL encoding of other characters can be obtained from
http://www.degraeve.com/reference/urlencoding.php

Njoy!

Friday, March 1, 2013

Cadence: Parametric analysis on temperature

go to tools> parametric analysis
then at the pop up window, go to 
setup> pick name for variable... > sweep 1

at the form there should be a param called temp or tempdc, 

click it and enter the desired range.

Enjoy!