If you want to switch it up a bit in 2014 by using less mouse clicks and more keyboard shortcuts, I have a great trick for you. Keyboard shortcuts are fast but speed is not everyone’s main objective, so for many of us memorizing keyboard shortcuts is not a priority. On the other end of the spectrum, there are keyboard shortcut wizards, with their fingers flying across the keyboard performing tasks at the speed of light. [Alt]-ernative to memorizing shortcuts …
Category: Desktop
How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once there, choose the “Custom” option from the left hand side. Under the word “Type” you’ll be typing in your custom number format. How to Type the Format Customizing time works a lot like customizing dates. However Excel rolls over the clock after 23 hours, so we’ll need to circumvent that. Let’s start with the basic characters. Formatting Characters Hours, Minutes, Seconds Put …
Most of us at some point have tried to find a particular number format, but we weren’t able to find one that satisfies our needs. There will be another blog to follow this one that specifically deals with time, this one is just about dates. How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once there, choose the “Custom” option from the left hand side. Under the word “Type” you’ll be typing in …
We’ve all seen Microsoft Excel error codes, and you’ve probably already figured what some of them mean. But when we get into more advanced Excel usage, the error codes we encounter can still be vexing. Understanding the following error codes will promote you to Excel’s Power User status! Excel TIP: Use the Formula tab’s Formula auditing tools to track error issues. We’re going to be using some of them here. #N/A Excel is saying “That lookup value isn’t valid” This usually happens …
Most of us at some point have tried to find a particular number format in Microsoft Excel , but we weren’t able to find one that satisfies our needs. We will have other blogs to follow, which will cover date and time, and positive and negative numbers, but for now we’re just going to cover the easiest, fastest ways to customize a number format. How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once …