how insert same text in empty cells in column (10000 rows)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide columns based on row values 2
VBA set thick borders around non empty cells in range 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Go To the next empty cell in Column A 3
Count latest number of continous not-empty cells in a row. 11
How to concatenate cells that meets a specific criteria in threecolumns 6
want to track time while paste value in multiple column of same roe 1

Back
Top