Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how insert same text in empty cells in column (10000 rows)
a column with 10,000 rows - 90% of them are empty. I want to put the same bit
of text in every empty cell without pasting or extending the range 1000 times. Can I identify cells which are empty and put the same text in them? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how insert same text in empty cells in column (10000 rows)
Select that range
edit|goto|special click blanks Now the selection is just the blank cells in that original selection Type your stuff, but instead of hitting enter, hit ctrl-enter. All the cells in the current selection will be filled with what you type -- constant or formula. bromptongadgets wrote: a column with 10,000 rows - 90% of them are empty. I want to put the same bit of text in every empty cell without pasting or extending the range 1000 times. Can I identify cells which are empty and put the same text in them? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I remove hidden empty text cells from Excel? | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) |