| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling in empty cells -
When I download a database into excel - it sets up the data fields as follows:
company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
Maybe more to do with how your database is outputting the data than anything
excel is doing. But have a look here for how to solve it in excel http://www.contextures.com/xlDataEntry02.html -- Allllen "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
Maybe more to do with how your database is outputting the data than anything
excel is doing. But have a look here for how to solve it in excel http://www.contextures.com/xlDataEntry02.html -- Allllen "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
Just give this try..
Enter the formula in say D2 =D1 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
It should be...
Enter the formula in say D2 =D1 Copy cell D2 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Just give this try.. Enter the formula in say D2 =D1 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
Jacob -
Yes that did work... Thanks... I have no Idea why it worked but hey, it's all about results - "Jacob Skaria" wrote: It should be... Enter the formula in say D2 =D1 Copy cell D2 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Just give this try.. Enter the formula in say D2 =D1 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
The formula entered is to get the value from top cell. So once we select the
blank cells and paste formulas; excel adjust the formula reference to pick the value from the top cell of each selected cell. Note that now you are having formulas in ColA (not values). To change that Select column A. Copy. Rightclick PasteSpecial Values..to have all the cells with values... If this post helps click Yes --------------- Jacob Skaria "stumped-in-excel" wrote: Jacob - Yes that did work... Thanks... I have no Idea why it worked but hey, it's all about results - "Jacob Skaria" wrote: It should be... Enter the formula in say D2 =D1 Copy cell D2 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Just give this try.. Enter the formula in say D2 =D1 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filling in empty cells -
Hi,
Here is another approach that does the same thing: 1. Select the entire range of cell, blanks and not and press F5, Special, Blanks, OK 2. Type = , Up Arrow, Ctrl+Enter (the three keystrokes = UpArrow Ctrl Enter) In general you will next want to convert these formulas to values: 1. Select all the cells and press Ctrl C 2. Choose Edit, Paste Special, Values -- If this helps, please click the Yes button. Cheers, Shane Devenshire "stumped-in-excel" wrote: Jacob - Yes that did work... Thanks... I have no Idea why it worked but hey, it's all about results - "Jacob Skaria" wrote: It should be... Enter the formula in say D2 =D1 Copy cell D2 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Just give this try.. Enter the formula in say D2 =D1 Select column A. Press F5. Click Special From GoTo window select Blanks. Right clickPaste SpecialFormulas.. -- If this post helps click Yes --------------- Jacob Skaria "stumped-in-excel" wrote: When I download a database into excel - it sets up the data fields as follows: company name person Acme Smith Jones Brown Bender Howard Mason Fortune Black Rain Is there a way to auto fill the blanks with the company name above? so it looks like company name person Acme Smith Acme Jones Acme Brown Bender Howard Bender Mason Bender Fortune Black Rain any help would be appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling a series into a non-empty column | Excel Worksheet Functions | |||
| Help on filling empty cells with string + row() | Excel Discussion (Misc queries) | |||
| Filling empty cells with a value | Excel Discussion (Misc queries) | |||
| Filling in empty cells in columns | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
![stumped-in-excel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
