How to increase or decrease values in excel without using formulas

Let's say you have to increase all the values in a worksheet to 10%. You can of course use a formula and multiply the value by 1.10. There is an alternate way, however, that you might like to use.
This will be useful specially when you need the new values without the formula. Use the excel paste special function. Yes, you've read it right,the paste special function!

Here's how to us this tool. First input the value in a cell, in this case the value 1.10. Copy this cell, then select all cells which contains the value to be changed and then right click. Choose paste special.

A dialog box will come up. Choose "multiply".

Click "OK". Now you're done! All your values are now 10% higher. All values are multiplied by 1.10. 

This can also be used to add, subtract, and divide the values by clicking the appropriate option buttons.

Happy computing!

Tweet

Add Bullets in Excel

Ever wondered how to add bullets in excel? It's so easy to do it in microsoft word. But how about excel?
Here's how.

On the selected cell, press Alt-0149. It will insert a bullet. Continue doing so for other cells or just copy paste the bullet and then add the text.

• Alt-0149
• Copy paste
• Or just repeat the key combination.

Works on all excel versions.

Happy computing!

Tweet

Copy as Picture in Excel

Excel2007:

Want to copy texts and graphs as picture? Here's how.

1. Click Paste -->As Picture--->Copy as picture.

2. A dialog box will then pop-up, giving you a choice to copy as picture or bitmap and if copied as shown on screen or when printed.

3. Choose between the appearance and the format

4. Paste as usual.

5. Done!

Excel 2010:

1. Go to home tab, copy, the select "copy as picture"

2. A dialog box will then pop-up, giving you a choice to copy as picture or bitmap and if copied as shown on screen or when printed.

3. Choose between the appearance and the format

4. Paste as usual.

5. Done!

Excel 2003:

There is a secret menu for this and this is how to get it.

1. Press the shift button while clicking on the Edit menu. There, a new menu will come up - "Copy as picture".

2. Click on this. The same popup dialog box will appear.

3. Choose between the appearance button (as printed or as seen on screen) and format (as picture or bitmap).

4. Paste as usual.

5. Done!

What for? Well, this will ensure that your graphs and your text will be consistent in its size and formatting when you paste it in the same sheet or on another office document such as word or PowerPoint.

This could be very useful when doing reports and presentations.

Happy computing!

Tweet

Shortcut to Format any Number in Excel

Here's some shortcut to easily convert a number to any format.
First, when you add a number in an excel cell, it defaults to a "general" format - "1234". To quickly change it to a "number" format - 1,234.00 here's what you do:

                      1. Click the cell with the number
                      2. Press Ctl-Shift-1
                      3. Done!

Easy!

Other combination and formatting results are as follows:

                     Ctl-Shift-2: Hour - 12:00AM
                     Ctl-Shift-3: Date -  18-May-03
                     Ctl-Shift-4: Dollar - $1,234.00
                     Ctl-Shift-5: Percent -1234%
                     Ctl-Shift-6: Scientific Notation -1.23E+03

Happy Computing!

Tweet

Wrap Text in a cell

Want to quickly wrap text in a cell? Simple. Use alt-enter to drop the next text. Do as many times as needed. It's that easy!

Tweet

Quick Redo in Excel: The Mighty F4

The Mighty F4. One of the most useful shortcuts I've learned is the F4. How is it used? Well, it is basically a keyboard shortcut for redo. Here's how it works, or at least the way I use it.

When you want to do something repetitive but does not warrant a creation of a macro, then use the F4. Example, you want to color different non-contiguous cells to blue. You could click the cell, format it to blue, click another cell, format it again and so on. Another way,quicker in my own opinion is to click a cell, format it, then click all other cells and press F4. This will definitely save some time.

This is specially true for tasks that require a lot of "mouse work" or clicks. You only do the "dirty work" once and then just F4 all the rest.

Try it out, you may like it! Hope it helps you well and make your work a little easier and quicker!

Happy computing!

Tweet

Excel Calendar Templates for Free!

It's a new year and of course a new calendar always comes in handy.

Enter vertex.com, I've seen this site a few years back trying to find some excel calendar templates and I've never looked at another site again! It has all sorts of useful templates and most are free such as this template.

Almost all types of calendars are available. Check the site and you'll almost always find what you need or look for.

Head to this link for the calendars (and other very useful templates). Kudos to the creator of this site!

http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html

Tweet

Fractions in Excel?

Yes, you read it right. If you use excel 2007, you can format decimals to fractions!


more on this on the microsoft site.


http://www.microsoft.com/Education/DisplayFractions.aspx

Tweet

Quickly Add New Series in a Graph

Want to add another series in a graph, a quicker way? Here it is. Instead of right clicking on the graph, choosing source data and use the add series, you could do this.

1. Select the series to be added.
2. Point the cursor to the side (until it becomes an arrow).
3. Click and drag to the graph.
4. You have successfully added the series!

you can then change the labels. You can also do this for other series. Also, you can select more than one column or row at a time and drag.
Happy computing!

Tweet

Copying Sheets the Quick Way

Want to have different sheets with the same or similar content? Here's one way to do it! Of course, you could always select all, copy, then paste to the other sheet. But, here's a quicker way (for me anyways).

CTL-LEFT CLICK the sheet you want to copy and then drag. You'll get an exact copy of the sheet with a name "OrigName(1)", "OrigName(2)", etc.

What's the use of this?Well, for one, if you should have similar sheets every month. You can create a sheet with the needed format, then do this copy sheet and just rename the sheets afterwards.

Hope this helps! If you have other ways, don't hesitate to share. We're all here to learn and share!

Tweet