Menu
Cart 0

PCM Courseware Blog — Excel Up to Speed

Spice Up Your MS Office Applications by Changing the Theme

Posted by Roger Hyttinen on

Spice Up Your MS Office Applications by Changing the Theme

Microsoft Office allows you to change the look and feel of your Office applications (Word, PowerPoint, Outlook, Excel, Publisher and OneNote) by switching up the Office theme. By default, the theme is set to Colorful; however, there are several themes to choose from: Colorful (the default theme in Office 2016) -The Ribbon is the color of the primary application (green for Excel, Blue for Word, etc.) Dark Gray - A light gray & dark gray lower contrast theme Black - A high-contrast black theme with white text White  (classic Microsoft Office theme) - Features white Ribbon and background To Change...

Read more →

Stop Automatic Creation of Hyperlinks in Excel

Posted by Roger Hyttinen on

When you type in a URL into a cell, Excel automatically creates a clickable hyperlink, which may not always be what you want. Some people find this behavior annoying. Luckily, you can easily disable it by changing Excel’s AutoCorrect settings. Here’s how: To Stop Automatic Creation of Hyperlinks Click the File tab on the Ribbon. Click Options to display the Excel Options window. Click Proofing in the left pane. Click the AutoCorrect Options button to display the AutoCorrect dialog box. Click the AutoFormat As You Type tab. Under the Replace As You Type area, uncheck the checkbox next to Internet...

Read more →

Copy Excel Formatting using the Format Painter

Posted by Roger Hyttinen on

Using the Format Painter button on the Home Ribbon allows you to copy the formatting from one cell or cell range to another cell or cell range. This procedure copies all formats including font typeface, number formatting, cell and font color, alignment, etc. to the new cell range. To copy the formatting to several locations, double-click the Format Painter button. It will then continue to be activated until you click its icon to deactivate it. To Copy Formats from One Cell or Cell Range to Another Select the cell or cell range whose formatting you wish to copy. Click the...

Read more →

How to Hide Zero Values in Excel

Posted by Roger Hyttinen on

How to Hide Zero Values in Excel

If you have formulas or functions in your spreadsheet that evaluate to zero, all those zeros can make your worksheet unsightly and messy, especially if you have a lot of zeros. Luckily, Excel has an option that allows you to hide zeros, giving your spreadsheet a more professional and polished look. This can also help you to find and evaluate cells that contain non-zero values. To Hide Zeros in Excel Click the File tab on the Ribbon. Click Options. In the left pane, click the Advanced category. Scroll down until you see Display Options for this Worksheet. Click the checkbox...

Read more →