Monday, July 11, 2011

Change Excel Color Scheme

If you get frustrated from your excel colour, so you need to change it. You can change it in three different colours : Black, Silver & Default blue.

Here is the process :

Go to Excel Option then Select Popular tab & from the "Top options for working with excel" choose your color scheme & Ok.

Hide Sheet Tab/Name

If you want to to do some magic, so here is a trick

If you don't want to show your sheet name & want to hide sheet tab (i.e. Sheet1,Sheet2...Sheet..) Here is the process :

Go to Excel Option [from office button (as I told you in activate developer tab)] then

Advance tab from the right.

Down your scroll bar & from the "Display options for this workbook" & uncheck "Show Sheet Tabs" & Ok.

Get Ready...!!!

Wednesday, July 6, 2011

Keyboard Shortcuts - Ctrl Command

A- Select All
B- Bold (Selected Text)
C- Copy (Selected text or object)
D- Fill Down (Text or Value) / paste object
F- Find
G- Go To
H- Replace
I- Italic
K- Hyperlink
L- Create Table
N- New Workbook
O- Open Workbook
R- Fill Right
S- Save
T- Create Table
U- Underline
V- Paste
W- Close workbook
X- Cut
Y- Redo
Z- Undo

Saturday, July 2, 2011

Reduce Excel workbook size

You know very well how to lose weight. If you want to lose your weight you have to workout at Gym, do some yoga & course to lose weight. But no need to get excited, I'm not telling you how to lose weight. I just want to tell you how to reduce size of your excel Workbook.

If your excel file is more than 15-20 Mb, you can't send that through mail. Suppose your workbook size is 24 Mb & you want to send it through mail. But it is not possible to send it through mail. If you want to send it through mail :-

Open your Excel Workbook & Save it As Excel Binary Workbook (through Save As Command [F12]).
You will see that your file size has reduced. It will reduce your file size. It will reduce it 1/4 size of your file or it can be less than 1/4. Make a heavy file. Try it now.

Friday, July 1, 2011

See video & movies in excel

All of you know about videos site for watching movies. But if you want to see videos in excel without any sites. You want to resize video you can perform this this task. You can also embed flash games, movies etc.

Here is the process :

First Go to Developer tab in excel ribbon & click on Insert button, then click on More Controls. See the image.

If you don't have developer tab in your excel so click here..

Then select Showckwave Flash Object & Ok. After click Ok mouse pointer change into a Plus sign (+). Then draw a rectangle.

After drawing a rectangle you will see a cross rectangle.

Now right click on it & select Properties. Properties dialogue box will appear. Now find property of "Movie" & Paste embeded url of your video.

Embeded url - Go to -> Play any video. Right click on video & select copy embeded html then choose embed url from it like below

<object style="height: 390px; width: 640px"><param name="movie" value=""><param name="allowFullScreen" value="true"><param name="allowScriptAccess" value="always"><embed src="" type="application/x-shockwave-flash" allowfullscreen="true" allowScriptAccess="always" width="640" height="390"></object>

embed src url which is in " " (inverted commas/Quotation marks) - :

Paste it without Quotation marks in properties of movie in property dialogue box.

Then click on "Design Mode" button from the Developer Tab. Now you can play video in excel.

Activate Developer Tab

If you want to create macros, record macro & write macro or want to create some application, so you need to activate Developer Tab. It helps you to record & write macros & it displays your recorded macros.

Here is the process : -

click on Office Button then click Excel Options.

Then select from the left category options Select Popular then click on Show Developer tab in the Ribbon & Ok.

This process will activate your developer tab, now you can write or record your macros.