Browsing "Older Posts"

Browsing Category " Excel "
A rule of three, you can use Excel very quickly solve. As the formula in Excel and tasks, calculate, we show you in this Tip.

The rule of three in Excel
  1. In Excel, click a cell in which you want to display the result. Tap your The rule of three formula, as an example, "=A1*B1/C1".
  2. If you then press the enter key, no result is displayed. The cells A1, B1 and C1 are not yet filled.
  3. Enter in the respective cells of the values. Imagine for example, the following rule of three: Three programmers need for a program 24 hours. How long will it take five programmers?
  4. To solve this task, type in A1 and the value 3, and in B1 24. In C1 specify a value of 5.
  5. In the cell with the formula you will see the result displayed.

Excel: rule of three count

By David Amoyal → Saturday, May 24, 2014

A rule of three, you can use Excel very quickly solve. As the formula in Excel and tasks, calculate, we show you in this Tip. The rule of ...

We will show you how to fields in Excel automatically mark in color.

Fields in Excel automatically highlight - for what?

Excel: fields Highlighted Excel: fields Highlighted With the automatic selection of cells in Excel, it is still easier, documents, and plans to evaluate and errors or problems to be detected. For example, you can create task lists and get a colored Feedback, who has his number of hours has passed.

Cells automatically mark in color: create rules
Through the so-called rules, you can define values for which a cell can be marked.
  • First, select the rows and/or columns, the rule should be taken into account. Drag the Cursor over the corresponding cells.
  • Then select the "Start"tab, the Option "Conditional formatting".
  • Under the Option "rules to Highlight cells", you will find different ways to define rules, including, for example, "greater than", "less than" or between two values.
  • Depending on which option you select in the new dialog box, enter numeric values. Then you can click on the right side of the window, choose a color. The Change will be broadcast live on the selected area will be updated.
  • Confirm your rule by clicking on the button "OK" button.
Excel rules edit or delete
If you want a rule to edit or even delete, proceed as follows.
  • Under the tab "Conditional formatting" select the bottom Option "manage rules".
  • Then a window opens in which all active rules. Select the appropriate rule.
  • Click on the Minus button to add the rule to delete, or click on "edit rule"to the values or the rule to edit.

Excel: fields automatically mark in color

By David Amoyal → Friday, May 23, 2014

We will show you how to fields in Excel automatically mark in color. Fields in Excel automatically highlight - for what? Excel: fields Hi...

How to enter a line break in a cell in Excel insert, we show you in this guide.

Line break in Excel cell insert

Excel: insert line break in Excel: insert line break To a line break in Excel insert, you have two options.
  • Manual line break: If you have a line break manually insert want to press you to the appropriate location, the key combination Alt+Enter. You can now available in a new line within the cell continue to write. Pressing Alt+Enter generates multiple line breaks in a row.
  • Automatic line break: Click with the right mouse button on the corresponding cell, and select "format cells". Click on the Tab "orientation" and put a check mark in front of the "word wrap". Then confirm by clicking on "OK".

Excel: line break in cell insert

By David Amoyal → Monday, May 12, 2014

How to enter a line break in a cell in Excel insert, we show you in this guide. Line break in Excel cell insert Excel: insert line break ...

CSV import into Excel
Not all of the tables in Excel Format. Sometimes if you hit on alternative file formats - such as CSV files. This in Excel to import, can cause problems. It is actually quite easy.

Instructions to Import a CSV file

Older Excel versions have significant problems alternative delimiters as the semicolon to recognize. Was your CSV document with commas, if the Import. In the case of Excel 2000, 2002 or 2003, open a blank sheet. Click in the menu under the section, "tools", "import External data," and then click "import data" or alternatively "text file".

This will open the conversion wizard. Set the point of the option to "Disconnected". The alternative Option "fixed width" meets seldom, except for all of the records are in the length is the same. In the next Dialog, you will now need the delimiter in the fields. Once you have the correct separator have selected, click on "finish". The CSV file should now Excel.

Does the CSV Import is also under Excel 2010?

Yes, even in Excel 2010 works to Import a CSV. However, there is a small deviation. After creating a new spreadsheet open, select "data", "External data" and then "import text file". Then there is the Import identical to previous versions of Excel. You insert the width as well as the delimiter.

Is there a Trick to Import to make it easy?

If you OpenOffice/Libre Office parallel to Excel, you can use the CSV there first open. These applications detect CSV files, namely at the Start, so that automatically to be a very intuitive Import wizard starts. This is for some users better to use than the Import into Excel. Simply select the encoding, as well as the delimiter.

Once the CSV then open, save the document as an Excel spreadsheet. This can now be easily open it in Excel, without lengthy detour through the Import wizard.

CSV import into Excel

By David Amoyal → Friday, May 2, 2014

Not all of the tables in Excel Format. Sometimes if you hit on alternative file formats - such as CSV files. This in Excel to import, can ...