In this video tutorial, I show you two ways to hide zero values in Excel 2010. In my example, I have a worksheet with formulas to add two amounts that I will be adding to throughout the year. Since I don’t want the zeros to appear in my worksheet, I try two different methods to hide them.
The first is by using Advanced Excel Options (File – Options – Advanced – Display Options for this Worksheet) and un-checking the “Show a zero in cells that have zero value” box.
The second method is by selecting the part or all of the worksheet to apply the formatting to and using Conditional Formatting (Home – Conditional Formatting – Highlight Cells Rules – Equal To) and formatting cells that are equal to 0 with custom formatting. In custom formatting, I change the font color to white. This changes all zero values to white so they are hidden from view and from printing.
I’ve compiled everything I’ve learned about Facebook and put it into a complete guide on learning the bare-bones basics of what social media is to creating marketing strategies for your page. Some of the content is similar to what I’ve written in my blog posts, but I go far more in-depth and have combined my knowledge into one resource.
Here’s what I cover in my book:
What is Facebook?
How Does Facebook Work?
Why do People Share so Much Information?
How do Businesses Fit into Social Media?
Why Does Facebook Matter?
How to Create a Business Facebook Page
Pages vs Profiles
Basic Setup Instructions
Making Your Page Look Great with Profile & Cover Images
What to Post on Your Business Facebook Page
How Often Should I Post on my Facebook Page?
What Should I Post on my Facebook Page?
So what’s the Most Engaging Stuff to Post on my Facebook Page?
Where Can I Find Content for my Facebook Page?
What About Posting Business/Promotional Content?
Setting up a Posting Schedule
Engaging with Fans
Negative Comments & Reviews
Facebook Contests & Sweepstakes
Things to Keep in Mind
How to Schedule Facebook Posts
Manage Your Facebook Page in Minutes a Week Using the Scheduling Tool
Growing Your Fan Base Organically
Ideas to Organically Grow Your Fan Base
Growing Your Fan Base with Facebook Ads
Types of Facebook Ad Results
The Planning Phase
Creating Facebook Ads
Managing Ad Campaigns
Keeping Ads Fresh
4 Reasons Why You Should Never Buy Likes for Your Facebook Page
Measuring Your Success
What Should I Include In My Social Media Report?
If you enjoy my blog, don’t forget to check out my YouTube channel. Many of my videos correspond to my blog posts and it’s a great resource for easy video tutorials on social media, Adobe and Microsoft programs.
Thank you for all your support along my journey—if it weren’t for readers like you, I wouldn’t have a reason to write.
In this example, we have a fictional address list in which part of the data is in all caps and the rest is in sentence case. Additionally, some zip codes have the additional 4 digits and for this example, we only want to use 5-digit zip codes.
We use the UPPER function to change all the text to uppercase and the LEFT function to choose only the first 5 digits of the zip code. Also shown is paste values.
Video recorded using Cam Studio (www.camstudio.org)
In this video, we are creating a simple HR employee hire form and limiting the user to selecting numeric months and years from a drop-down list on a separate tab. The tab can be hidden from the workbook once the form is complete so the user cannot alter the data.
The tutorial was done in Microsoft Excel 2010, but the function will be similar in previous versions.