Copying formulas in excel - No change to cell reference

-
If you dont want the cell references to change when you copy and paste your formulas use $ signs.

example:
=$A1&B2.

this will not change A's row, only columns.

=$A$1

will not change both row or column

Comments

Post a Comment

Popular posts from this blog

Muslim Populace around the world

-
Image
This community consists of between 1.2 and 1.6 billion people, or roughly one-fifth of mankind. This diaspora is spread across many different nations and ethnic groups connected by religion and a shared sense of belonging.  With the exception of India, Ethiopia, China and Russia the majority of the population in the following countries are Muslim. Indonesia 202,867,000 (88.2%) Pakistan 174,082,000 (96.3%) India 160,945,000 (13.4%) Bangladesh 145,312,000 (89.6%) Egypt 78,513,000 (94.6%) Nigeria  78,056,000 (50.4%) Iran 73,777,000 (99.4%) Turkey 73,619,000 (98.0%) Algeria  34,199,000 (98.0  %) Morocco 31,993,000 (99.0%) Iraq  30,428,000 (99.0%) Sudan  30,121,000 (71.3%) Afghanistan 28,072,000 (99.7%) Ethiopia 28,063,000 (33.9%) Uzbekistan 26,469,000 (96.3%) Saudi Arabia 24,949,000 (97.0%) Yemen  23,363,000 (99.1%) China 21,667,000 (1.6%) Syria  20,196,000 (92.2%) Malaysia  16,581,000 (60.4%) Russia...
Read more

English Words that have originated from Tamil

-
Here is a list of 100+ words that have some root in Tamil language machila a hammock slung on a pole used for carrying passengers in many parts of Africa Portuguese, perhaps from Tamil macil, mañcil stage in a journey, from Hindi manzil, from Arabic mamoty a hand tool used for digging and cultivating in southeastern Asia Tamil mammaṭṭi, alteration of maṇ-veṭṭi, from maṇ earth + veṭṭi spade sandalwood the compact close-grained fragrant yellowish heartwood of a parasitic tree (Santalum album of the family Santalaceae, the sandalwood family) of southern Asia much used in ornamental carving and cabinetwork sandal sandalwood (from Middle English, from Anglo-French sandali, from Medieval Latin sandalum, from Late Greek santalon, ultimately from Sanskrit candana, of Dravidian origin; akin to Tamil cāntu sandalwood tree) + wood entry 1 Gurmukhi the alphabet that the sacred texts of the Sikhs in whatever lan...
Read more

English words that Originated from Telugu

-
Here is a list of words that have originated from Telugu metad a small field rat (Millardia meltada) Telugu dialect mettād metad rat a small field rat (Millardia meltada) Telugu dialect mettād bandaka okra Kanarese beṇḍe-kāyi or Telugu beṇḍa-kāya Nagari   devanagari Sanskrit nāgarī, literally, (writing) of the city, from nagara city, of Dravidian origin; akin to Tamil nakar dwelling, city, Telugu nagaru palace bandakka okra Kanarese beṇḍe-kāyi or Telugu beṇḍa-kāya bandicoot any of several very large rats (genera Bandicota and Nesokia) of southern Asia destructive to crops Telugu pandikokku bockadam an aquatic, mildly venomous snake (Cerberus rynchops synonym Hurria rynchops) native to India, southeastern Asia, and northern Australia borrowed from Telugu bukkaḍamu “eel, water snake” ...
Read more