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 LailaK 6 years ago
Fill in the blank: I cannot leave the house without ———————.
by Renee S 7 years ago
As I was driving down the road the other day I noticed.....
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 Tamarii2 9 years ago
EACH OF US HAS WITHIN US A VOID THAT ONLY...................CAN FILL.CAN YOU FILL IN THE BLANK?
by noorjamali 7 years ago
fill the blanksound travels.........................in water than in air.
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"...
|HubPages Device ID|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Google Analytics|
|HubPages Traffic Pixel|
|Google Hosted Libraries|
|Google AdSense Host API|
|Conversion Tracking Pixels|
|Author Google Analytics|
|Amazon Tracking Pixel|