How to auto fill all the blank cells with some predefined values in Microsoft Excel 2007 or 2010?
I am working a large excel file which consists many rows and many columns. There are several cells which is totally empty i,e. blank and has no value. I would fill all the blank cells with the value "N/A". How to do this quickly?
To do it quickly you need to Sort the data. To be able to Sort, the Data must be in a "Table"
A Table is a group of Data which has continuous Header cells across the top and continuous Row cells along its left side. Any interruption in the Top row and Left column will be seen as the end of the Table.
IMPORTANT: the row immediately above the Table must be empty. Insert a Row just above the Table. Hide the row if you don't want to see it. (same rule for the column just to the left of the leftmost column, it must be empty)
Then Sort the Table. (you must 'select' a cell within the Table or Sort won't know what to sort)
BEFORE YOU SORT, be sure the leftmost column has values that will allow you to Unsort when you're done! Call the first Column 'Unsort' and fill it with numbers 1 to whatever.
And always SAVE before you Sort, in case it goes awry.
Sort the Table.
When all the empty cells are together, enter whatever you want in the topmost empty cell of a column.
Select the value you have just entered, hold Shift, press End then down arrow, (then Up arrow once to Unselect the next piece of data)
Ctrl + D is the fasted way to Fill Down the value in the topmost cell of the selection. Repeat for each column.
Unsort when done using the numerical series in the Leftmost column.
Is there any shortcut to do this. The process is much lengthy!
I could do all the above steps in 90 seconds. Even if you just entered them manually you should have it done by now!
How big is this spreadsheet?
by Renee S 7 years ago
As I was driving down the road the other day I noticed.....
by LailaK 6 years ago
Fill in the blank: I cannot leave the house without ———————.
by Joseph De Cross 6 years ago
"The Greatest, or silliest thing I did for love......." Fill the blank.We look back and we see ourselves saying: Did we do that?" What have you done for your better half without thinking? Are you guys still together? Do you regret it?
by Paula 3 years ago
Fill in the BLANK with Fact or Fiction; Funny or Sad, Serious or Silly.......Deep thoughts are filled with realities & fantasies. We focus on our life, our loves, our trials & hopes.............BUT..."What's really a hot mess in my life is"...
by Tamarii2 9 years ago
EACH OF US HAS WITHIN US A VOID THAT ONLY...................CAN FILL.CAN YOU FILL IN THE BLANK?
by floating mind 9 years ago
How would you fill in the blank for this quote, "Life is _____, then you die!"Fill in the blank with either one word, or a paragraph, or a hub. Make it your own. Do not let the category throw you off. This quote fits a very wide range of categories.
Copyright © 2019 HubPages Inc. and respective owners. Other product and company names shown may be trademarks of their respective owners. HubPages® is a registered Service Mark of HubPages, Inc. HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.
|HubPages Device ID||This is used to identify particular browsers or devices when the access the service, and is used for security reasons.|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Traffic Pixel||This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.|
|Remarketing Pixels||We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.|
|Conversion Tracking Pixels||We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.|