Hello John

 

Good Morning 

 

I hope this email finds you well.

 

Have you ever needed to fill in a blank range of cells? 

 

In this issue, learn how to accomplish this task quickly. I’ll explain the steps below, but if you’d rather watch a video with the steps, you may view it here: https://youtu.be/CoKiJPojnr0.

 

While you’re at our YouTube channel (youtube.com/jackiekiadii), feel free to check out other video tutorials, like our videos, and subscribe. 

Fill In Blank Cells Quickly

 

Step 1 – Select the Dataset

 

Click anywhere in your dataset and hold CTRL A to select the entire dataset.

 

Step 2 – Find all Blank Cells

 

Hold CTRL G to activate the GoTo dialog box.

Click the Special command button.

 

Select Blanks, then click OK. This highlights all of the blank cells.

 

Step 3 – Enter Data in Selected Cells

 

Type what you want to place in all cells. This can be text, numbers, or even formulas. 

 

Instead of hitting the Enter key, hold down the CTRL key while you hit ENTER to enter the information in all cells.

 

It’s as easy as 1-2-3.

 

If you’re a visual learner, check out our step-by-step video here: https://youtu.be/CoKiJPojnr0. Don’t forget to like, share, and subscribe! 

 

Interested in learning more about Power Query? Contact us for more information about our 1-on-1 and group training. We also handle automating Excel processes using Power Query and VBA (Visual Basic for Applications). 

 

Warmly,

Jackie Kiadii, CEO
Phoenix Computer Consultants, LLC
t. 770-498-7333
e. training@probiztechnology.com
a. 1100 Peachtree Street Suite 200 Atlanta, GA 30309
l.   http://www.linkedin.com/in/jkiadii
c. http://www.linkedin.com/company/probiztechnology