| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Special editing
When using Excel 2003, I could fill blank cells in a column with contents
from a preceeding cell using the Edit menu. Specifically, after selecting the range then on the Edit menu i would click Goto/Special/BlanksOK. Then enter first cell address in selected range (ie =a1) and press CTRL+ENTER. This would fill the balnk cells with the content of the preceeding cell. How is this done in Excel 2007? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Special editing
The same way.
What doesn't work for you? Mister Ed wrote: When using Excel 2003, I could fill blank cells in a column with contents from a preceeding cell using the Edit menu. Specifically, after selecting the range then on the Edit menu i would click Goto/Special/BlanksOK. Then enter first cell address in selected range (ie =a1) and press CTRL+ENTER. This would fill the balnk cells with the content of the preceeding cell. How is this done in Excel 2007? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pop up box needs editing --- HOW? | Excel Discussion (Misc queries) | |||
| EDITING | Excel Discussion (Misc queries) | |||
| Min Max Editing | Excel Worksheet Functions | |||
| Min Max Editing | Excel Discussion (Misc queries) | |||
| Editing the name box | New Users to Excel | |||
Linear Mode
