Video instructions and help with filling out and completing Fill Form 2220 Preceding

Instructions and Help about Fill Form 2220 Preceding

Exhale versus exiled how to fill in blank cells above in this episode we will compare two ways filling in black cells using values above to show how much time you can say using the go-to shortcut in Excel which is activated by pressing the function key f5 sometimes you find yourself staring at hundreds or thousands of rows of data where some of the cells have been left blank in order to make the row headings easier to read if you want to sort or filter the list you need to fill in the blanks here's an example we have 500 rows of data with blanks in column B now you could manually fill in the blanks by copying and pasting but this is a really slow approach let's see how much faster it is to use Excel to go to feature and some other nice shortcuts on the left hand side I am going to manually copy and paste on the right hand side I am going to use the f5 go-to shortcut after the comparison I will give you a step-by-step walkthrough of each shortcut are used it took 16 seconds using all those shortcuts without the shortcuts it took 30 seconds to do 40 rows so it would take me longer than 6 minutes to do 500 votes that's over 20 times faster and much more accurate - as promised earlier I will give you a step-by-step walkthrough of each shortcut I used I have also listed the steps in the description underneath this video expand the description to see them select all of the values and blanks in column B by clicking on the column B header press f5 to bring up the go to menu press alt + S to select special cells press alt + K to select all blank cells type in the formula equals cell above press ctrl + Enter to fill the formula into all the blank cells selected select column B by clicking on the column header right click the selection border drag selection border one column to the right then drag the selection one column to the left finally select paste as values to overwrite any formulas as values if you liked this episode visit my blog of launch Excel comm where it's my mission to launch your excel learning day