 |
| Exel |
This article could easily have been called "tricks for Microsoft Excel 5000, given the large number of shortcuts that are hidden within the program, but we preferred to discuss only those unfamiliar features that may be useful for most users.
All the tricks presented here have been checked, and working correctly in version English-Excel 2003, running under Windows XP, although you also do before and after versions of the program.
1) Set the system date: Certainly, over a working session with Excel dates write several times, and in many cases it is the current day's date. Instead of typing, just by being positioned in the cell where you want to display today's date, simultaneously press the "CTRL" and "+".
2) Set the system date: In the same way that the trick number 1 writes the current date (in fact, the one with the computer), if we press "CTRL" and ":" time appears in the selected cell.
3) Repeat the above cell content: If you want to write in a cell the same content that is in the cell above, surely the fastest way is to press "CTRL" and "'" (apostrophe).
4) Repeat the contents of the cell immediately to the left: In the same manner as in trick # 3, if we press "CTRL" and "D" in the cell that is selected will copy the contents of the cell immediately to the left.
5) Put the contents of the cell in bold: If we change the format of the source which is written the contents of a cell to appear in bold, the most efficient way is to press "CTRL" and "N".
6) Highlight the cell contents: To emphasize, rather than using the toolbar is faster press "CTRL" and "S".
7) Goto italics: In the same way as in the two tricks above, if we put in italics (italics) the source of the current cell, just press simultaneously "CTRL" and "K".
8) Strikeout text in a cell: To change the style of the text of the selected cell to "strikethrough", simply press "CTRL" and "5."
9) Choose Format: If the format you want to apply to a cell is not one of the tricks mentioned in 5, 6, 7 or 8, we have the possibility to enter the menu "Format Cells" (Figure 1 ) by simultaneously pressing "CTRL" and "1"
10) Hide / Retrieve rows: As we know, in Excel you can have hidden rows or columns, eliminating the need "view" cells with intermediate results, or not we want to see. The simplest way to hide a row is to press "CTRL" and "9" at a time. The row in the current cell that will have "disappeared." If we want to recover just the key combination "CTRL", "Shift." And "8" will come back.
11) Hide / Retrieve column: As in the previous trick to hide the current cell's row just press "CTRL" and "0" (zero). If we wish that the column is visible again, we must press on three keys simultaneously "CTRL", "Shift." And "9."
12) Insert new worksheet: When you start working on a new book, Excel defaults to three sheets at (this number can be changed from menu options.) If for some reason we are inadequate, we can press "Shift." And "F11" and add a new leaf in our book.
13) Make a quick copy an existing sheet: To play one of the leaves of the current book, we must select the sheet you want as a model and then, using the tabs displayed at the bottom of the book drag the mouse horizontally and "CTRL" key pressed. We will see that the mouse cursor appears a "+". If the release in that time, we will have created a worksheet that is an exact copy of our model, even with the same format.
14) Close all Books: It is not uncommon to find several books open at once. If we want to close them quickly, without having to go through all of them can do this by pressing the Shift key. "And without letting go into the [File] menu. We will see that the [Close] be changed [Close All].
15) Insert a comment in a cell: Excel expert to add comments in each cell (Figure 2). To do this, we can simultaneously press "Shift." And "F2" within the desired cell and comment will appear for completion.
16) More than one line in the same cell: It is possible that the text within a cell has more than one line. To do this, write the data we want and press "ALT" and "ENTER", which will cause the cursor to move to a new line without changing cell. The height of the row is modified to allow viewing the entire text of the cell.
17) formulas Edit: When editing a formula in the formula bar and has selected some characters or numbers, pressing the Delete key deletes the selection. If you press the key combination "CTRL" and "Delete" when no characters are selected will delete all characters from the point where the cursor to the end line.
18) Fill a range of cells: To quickly enter the same value or text in a cell range, we must first select the range to be filled and then introduce the fill value. To end press "CTRL" and "ENTER" simultaneously, and the full range will be the new content.
19) Auto sum: While the button "AutoSum" has disappeared from the default toolbars of the 2003 version of Excel (but can be added manually) you can access this useful function by simultaneously pressing "Shift", " Alt "and" = "with the same effect as if we had pressed the button disappeared (see Figure 3).
20) Repeat the last action: "F4" key stores the last command or formatting applied. For example, typing a text or a number in two cells and then formatted in a bold font on them, and immediately activates the second cell and press "F4", this cell also automatically take the bold formatting.
 | |||||
| Figure 1. | | | | | |
 |
| Figure 2. |
 |
| Figure 3. |
21) Clear cells with "Autofill" feature can be used AutoFill to clear the cell contents. Only has to select the range you want to delete, move the cursor over the filling and drag the cursor over the block. As they passed over the cells take the color gray and when you release the mouse button erases the contents of all cells in gray (Figure 4).
22) Fast Scrolling with the scroll bars: While dragging the sliders in the sliders you can go pretty quickly from one area to another in a long form, if you also hold down the Shift key. "While drag with the mouse scroll bar, the movement will be even faster.
23) range selection accurately: In complex spreadsheets, very large or very small cells is difficult to select a set of them "dragging" the mouse. We do this by selecting the first cell and press the SHIFT key and then selecting the last cell, select all the range in the imaginary rectangle.
24) Recalculation manual: When we are working on very large leaves, we noticed that consume a lot of time in both open and every time you try to recalculate Excel to enter a new value. To make Excel recalculate only when we want, we can activate manual calculations from the [Tools / Options / Calculate] and then selecting [Manual] (Figure 5), allowing us to make the calculation each time you wish by pressing the "F9." It is useful to avoid confusion leave the option [Recalculate before save].
25) Random Numbers: Excel allows the generation of random numbers (random) by using the function RAND (). This function returns a number in the range 0 ... .. 1. Multiplying the formula RAND () by a number is obtained by the maximum of random numbers. For example, using RAND () * 10 the number will be between 0 and a maximum of 10. If we want to get numbers without decimals, we must change the format of the cell. Just keep in mind that the numbers change every time you recalculate the template, so if we want to fix them copied to another cell with [Paste Special] on the [Edit].
26) Moving the buttons on toolbars: There is a quick and easy way to relocate / remove buttons from the taskbar almost the entire Office package. Just keep
down Alt and drag the desired button to its new location. If you want to remove it, drag it to the document and release them there. To retrieve or add new buttons on toolbars, we must go to the [View / Toolbars / Customize ...]
27) Open a book at the beginning: If using Excel always work with the same template, it is possible we want this to load automatically when you open Excel. To do this, we can save in the folder \\ PROGRAM FILES \\ MICROSOFT OFFICE \\ OFFICE11 \\ XLSTART. In this way, the book will open automatically every time you start the program, regardless of what we call it.
28) Same column width: Excel provides an effective solution to the problem of obtaining columns noncontiguous same width. For two or more columns with the same width, we must follow the following steps: 1) select the column that has the width you want to apply to another by clicking the header. 2 º) With the cursor over the right-click with your mouse to open the contextual menu. 3 º) Click on the item Copy. 4 º) Click the column header destination, open the context menu again with a right click and choose Paste Special. 5 º) Check column width option and click OK.
29) Fractional Numbers: Enter fractional numbers in Excel can be annoying, because the character "/" is used for entering dates. If you enter eg 2 / 5, Excel interprets it as a date and formats it accordingly (February-May). To let you know that this is a fraction we load the number as follows: 0 2 / 5. The display will be 2 / 5, while internally stored program 0.4. Proceed
same values \u200b\u200bas 6 3 / 5, ie with a whole lot and other fractions.
30) Auto complete faster: Load Excel data with repetitive AutoComplete feature is turned on pretty fast method. But the tool itself is an alternative to streamline it further. If you are loading a list of values \u200b\u200band should be repeated one from the active cell (to fill) use the key combination Alt + Down Arrow. This displays a menu of previously entered values \u200b\u200b(Fig. 6). Select the appropriate time and will be written in the next cell.
 | |||
| Figure 4. | | | |
 |
| Figure 5. |
 |
| Figure 6. |
As we said at the beginning of the article, Excel being a complete and comprehensive program as there are many more than 30 ways to win in productivity. We wanted to show only the most common and useful, without getting into issues such as charts or macros in VBA (Visual Basic for Applications).
not hard to find many more ways save time using this program, just read carefully the accompanying full support, we invite you to do so and probably end up discovering that he was only using a small percentage of the features available in this excellent spreadsheet.
0 comments:
Post a Comment