10 Simple Must Known Tips for Microsoft Excel 2007

This is a selection of general tips for Excel 2007 which most of you will find useful. Many of these apply to earlier versions of Excel as well.
1. Generate Random Numbers

If we need to generate random numbers to simulate a scenario. It can get a little irritating to keep on typing random digits all the time.

To generate a random number, use the RAND() command.

For example,

To generate a number between 0 and 500,
=RAND()*500

Similarly, randomly generating numbers between any two numbers can be done using RANDBETWEEN(bottom,top)
Bottom is the smallest integer RANDBETWEEN will return.
Top is the largest integer RANDBETWEEN will return.
For example:

=RANDBETWEEN(50,100)
will generate random numbers between 50 and 100.

2. So Many Worksheets, So Little Space

Have you ever had an Excel workbook with multiple sheets,
for Example : January to December

Rather quickly, you get to the point where you no longer can see all the tabs in one view. Of course, you can use the built-in tabs navigation buttons, and go the next, previous, first, or last sheet, but wouldn’t it be great if there was a way to see all the sheets and be able to click on the one you want to work on?

Simply right-click the tabs navigation buttons and a floating list of all the worksheets in the workbook will appear. It is especially useful when sheet names are long.

You can also use two great keyboard shortcuts:

CTRL+PageUp ->activates the previous sheet in your workbook
CTRL+PageDown activates the next one.

3. Quick Graph
One expects to go through a dozen steps in a Wizard to make a graph. Assuming that the graph data is basic, simply

pressing [F11] will create a graph with the selected cells instantaneously.

That’s not all! In case you don’t like the graph that’s been created for you because it’s chosen the wrong fields or the style doesn’t suite it, you can right-click on the graph and change the graph type or the cells selected.

4. Insert Current Date and Time
This can be done using shortcuts.

Pressing [Ctrl] + [;] will add the date.
pressing [Ctrl] + [Shift] + [:] will add the time.

5. Using Only Keyboard
Moving a mouse to the different menus and toolbars very often during your work can be a little inefficient at times. The easy-to-use shortcuts are highly recommended. One does not have to remember three key combinations to do a particular task.

Press [Alt] key to know the shortcuts of all ribbons.All the shortcuts will be displayed on the ribbons.

Pressing [Alt] + [R], for example, will show you the Review Ribbon along with the additional keys for each of the tools on it. So pressing [C] now will create a new comment.Once you get used to this technique and slowly start remembering the keys it can save a lot of time.

6.Moving Cells with Data
Moving a certain cell with data around would mean cutting and pasting the value onto another cell. Actually you can do it in Another easy way.

one can move chosen cells around is by moving the mouse pointer over the border of a particular cell till it becomes an arrow. Then move the cells to the chosen destination and let go of the left-click.

7.Show All Formulas
Normally, viewing the formula used in a cell includes clicking on each and every cell. Instead of doing this, a view for looking at all the formulas on the worksheet at one glance can be enabled by

Clicking on the Formula ribbon and then on Show Formulas. All the formulas in each cell on the worksheet are immediately displayed

8.Entering same data in Multiple Sheets.
Multiple worksheets can be allowed to receive the same data being added to a particular sheet.

Press [Ctrl] and go on left-clicking on the worksheets that you want to add data to.Then enter the text or numbers on the first sheet which will then be automatically replicated onto all the sheets which you have selected.

9.Dividing the Worksheet Space
Worksheets are bound to get very large, and navigating through one can get hectic.for example , you got a table from A to Z and you are comparing the B and Y cells,then you have to scroll here and there.The best way to reduce the large amount of scrolling required to move from one corner of the table to another is to split the worksheet. It makes a window, so to speak, which lets you view one area of the worksheet while you use the main region as well.

To do this,

look for a tab at the right bottom of the screen where the two scrollbars meet, click on it, and drag it. The newly-created division can also be disabled by clicking on the divider and moving it to the extreme end of the screen.

10.Creating Duplicate worksheets
There may be cases where a copy of an existing worksheet is required as a blueprint to work on an another worksheet in a same file.
It can be done by making a copy of it

By pressing [Ctrl] and left-clicking on it and dragging it to the location where you need it.

Popularity: 5% [?]