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, |
|
Since 2001, Phoenix Computer Consultants LLC has provided Excel and other Microsoft Office training to thousands of business professionals. |
|
|