Skip to main content

Excel: Unmerge cells and automatically fill the unmerged cells with the content of the merged cell

  1. Unmerge all cells in column A and B
  2. Select all rows in column A and B from your first row of data to your last row of data.
  3. Press CTRL+G to open the Go To box
  4. Click Special
  5. Choose Blank Cells
  6. In the formula bar enter = then press the Up arrow. You'll end up with a formula like =A1. DO NOT PRESS ENTER
  7. Press CTRL+ENTER and this will populate your formula to all selected cells and simulate a "fill down".
  8. Copy-paste as values as required.

Comments

Post a Comment

Popular posts from this blog

Gujarati/Family relations

Gujarati/Family relations - Wikibooks, open books for an open world In Gujarati culture: These are the "titles" for family members. With the exception of Father, Mother, and Grandparents (who are called by the title only), all of these titles are added after the name of the person. Father: Papa or Bapuji Mother: Ba, Mummy or Maa Brother (also male cousins): Bhai (e.g. Haresh Bhai) Brother's Wife: Bhabhi (e.g. Komal Bhabhi) Sister (also female cousins): Ben (e.g. Mayuri Ben) Older Sister: Didi (e.g. Mayuri Didi) Sister's Husband: Banevi or Jijaji (e.g. mahesh Jijaji) Father's Younger Brother: Kaka (e.g. Rajesh Kaka) Father's Younger Brother's Wife: Kaki (e.g. Komal Kaki) Father's Older Brother: Kaka(e.g. Jiten Kaka) Father's Older Brother's Wife: Kaki (e.g. Bhavna Kaki) Father's Oldest Brother: Mota Kaka(e.g. Jiten Kaka) Father's Oldest Brother's Wife: Moti Kaki (e.g. Bhavna Kaki) Father's Sister: Foi,Fui (also
3 comments
Read more

How to turn off Xiaomi "Don't cover the orange area" or "Don't cover the earphone area"

If you get the “Don’t cover the orange/earphone area of the screen” message when you turn on your phone’s screen all the time, it means that you’ve turned on the Prevent pocket dial feature and something is blocking the proximity sensor at the top part of your phone. Sometimes it's quite annoying and simple one-time solution is to press volume up & back button at a time to disable. Infact Prevent pocket dial is a good feature that prevents you from rejecting or picking up calls by accident when the phone is in your pocket by using the proximity sensor. If this feature isn’t working properly on your Xiaomi phone, the check whether anything is blocking area next to earphone where proximity sensor is placed. Mostly it caused by screen guard. You should remove it. If you still facing problem then here’s how to turn it off: 1. From your device’s Settings, tap Lock screen & password. 2. Slide the Prevent pocket dials switch to the off position. (Slider will be greye
Post a Comment
Read more

Disable Google Chrome extensions auto update

Disabling extension update: Edit preferences json-file for Google Chrome on Windows:  C:\Users\<USERNAME>\AppData\Local\Google\Chrome\User Data\Default\Preferences on Ubuntu for Chromium:  ${HOME}/.config/chromium/Default/Preferences In this file find the extension preferences block and set  "update_url"  property like  "http://localhost"  for example. For now according to given url updating of that extension is simply impossible. To locate that preferences block use extension id which you can find at  chrome://extensions/  page with "Developer mode" enabled. In simpler words, open "Preferences" file with wordpad and replace "update_url":"https://clients2.google.com/service/update2/crx" with   "update_url":"https://localhost" source:  https://productforums.google.com/d/msg/chrome/l3zOZeO-5-M/Y7VaR0KCWNIJ Disable all Google Chrome updates: 2.1. Any OS Just type  chrome://p
1 comment
Read more