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

Quick Auto Sum in Excel

Want to use a keyboard shortcut to quickly sum up a column or row of data? Here's how:

• Go to the end of the row or column (first cell with no values)
• Press Alt-= (Alt and equal sign)
• Auto sum is immediately inserted.
• Done!

Quick. Effective. Simple.

Happy Computing!

Tweet

Quick Navigation in Excel (Control Key)

If you want to go to the last data in a row or column, simply use this combination:

Ctrl-Arrow key.

Example, if you are at the top of the column and you want to go to the last data of that column (before any break), then use the Ctrl-Arrow Down. If you were at the bottom, then use Ctrl-Arrow up.


Same rules for Ctrl-Left Arrow and Ctrl-Right Arrow.

Now it's quicker to navigate highly populated sheets!

Happy Computing!

Tweet

Highlight All Cells Referenced by a Formula

Here's a quick shortcut to highlight all cells referenced by a formula. Go to the cell with the formula then hit

Ctrl-[ (control and open square bracket).

You will see all referenced cells highlighted. To move to the next selection (highlighted cell), simply press enter.

Very useful for auditing worksheets!

TIP: If you want to determine the OPPOSITE of it- that is formulas that reference the current cell  then simply use:

Ctrl-] (control and close square bracket)

Very useful for auditing sheets!

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

Display all formulas in a sheet with a single key combination!

Want to show all formulas within a sheet with just a sing key combination? Yes! With this combination, you can toggle this to display the results or the formula.

Here it is Ctrl - ~ (it's ctrl key and the tilde, key before "1").

That's it, you can now conveniently see and hide the formulas in your sheet.

Works with any version of excel.

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

Hiding the Excel 2007 Ribbon Shortcut

Using a netbook and want to save some screen space? Try to hide the "Ribbon". The ribbon is where the menus in excel 2007 are.

To quickly hide and unhide it, just use Ctl-F1. That's it!

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

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