Студопедия
Случайная страница | ТОМ-1 | ТОМ-2 | ТОМ-3
АрхитектураБиологияГеографияДругоеИностранные языки
ИнформатикаИсторияКультураЛитератураМатематика
МедицинаМеханикаОбразованиеОхрана трудаПедагогика
ПолитикаПравоПрограммированиеПсихологияРелигия
СоциологияСпортСтроительствоФизикаФилософия
ФинансыХимияЭкологияЭкономикаЭлектроника

Use the F4 key for absolute references

Why to Study it? | Absolute vs. Relative references | VLOOKUP Function | Examine the Insert Function dialog box |


Читайте также:
  1. Absolute vs. Relative references
  2. Formula references
  3. List of References
  4. References
  5. Translator's Notes and References

 

The screen above shows the formula corrected so that it will give the desired results after it is copied.

To convert a relative reference to an absolute reference while building a formula, press the F4 key immediately after clicking on the desired location with the cursor (in this case, the immediately after selecting the cell that has $4,100 in it).

The formula changes to show a $ in front of both the column and the row for that location.

You will notice that if you continue to press the F4 key, the command toggles to set the column, then the row, then both as absolute references.

Trivia: Excel uses the $ to indicate absolute references because in the early days of spreadsheets PC keyboards had so few keys that software designers had to find multiple uses for each symbol. The company that first did this now out of business, but the $ stuck.


Дата добавления: 2015-09-01; просмотров: 38 | Нарушение авторских прав


<== предыдущая страница | следующая страница ==>
Formula references| Using Functions in Excel

mybiblioteka.su - 2015-2024 год. (0.005 сек.)