10+Simple+Tips+for+Microsoft+Excel+2007

[|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. Have you ever had an Excel workbook with multiple sheets, <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> for Example : January to December <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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? <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">You can also use two great keyboard shortcuts: <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">CTRL+PageUp ->activates the previous sheet in your workbook <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> CTRL+PageDown ->activates the next one. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> One expects to go through a dozen steps in a Wizard to make a graph. Assuming that the graph data is basic, simply <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">pressing [F11] will create a graph with the selected cells instantaneously. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> This can be done using shortcuts. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">Pressing [Ctrl] + [;] will add the date. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> Pressing [Ctrl] + [Shift] + [:] will add the time. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> 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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">Press [Alt] key to know the shortcuts of all ribbons. All the shortcuts will be displayed on the ribbons. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> 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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> 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 <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">Clicking on the Formula ribbon and then on Show Formulas. All the formulas in each cell on the worksheet are immediately displayed <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> Multiple worksheets can be allowed to receive the same data being added to a particular sheet. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> 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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">To do this, <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> 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. <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;"> It can be done by making a copy of it <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">By pressing [Ctrl] and left-clicking on it and dragging it to the location where you need it.
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2. So Many Worksheets, So Little Space **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3. Quick Graph **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4. Insert Current Date and Time **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">5. Using Only Keyboard **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">6. Moving Cells with Data **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">7. Show All Formulas **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">8. Entering same data in Multiple Sheets. **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">9. Dividing the Worksheet Space **
 * <span style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">10. Creating Duplicate worksheets **