Excel: How to Format UPC With Leading Zero
Jul 17, 2012WindowsComments (1)
Having trouble getting UPC numbers to show up properly in Microsoft Excel? Excel may format a UPC strangely if the cell is formatted as Text (e.g. 8.08282E+11) or may remove leading 0's if the cell is formatted as a Number. Some solutions involve using a function or adding a single-quote to the beginning of each UPC, but those don't work well with bulk UPCs. The better solution is to use a Custom format for the UPC cells.
Continue Reading ›
Windows 7: Literal Number File Name Sorting
Apr 25, 2012Windows
In Windows 7, numbered file names are sorted based on numerical value:
Continue Reading ›
How To Turn On File Extensions In Windows XP And 7
Feb 11, 2012Windows
By default, both Windows XP and Windows 7 hide the extensions for common files, such as .jpg, .pdf, .html, and .doc. I recommend changing this behavior, so that you can more easily change the file extension and determine the file type of a file. To do this, you need to uncheck "Hide extensions for known file types" in Folder Options. Follow the below instructions for your operating system.
Continue Reading ›
How to Assign Custom Keyboard Shortcuts in Photoshop CS5
Feb 8, 2012WindowsComments (1)
Want to change a keyboard shortcut for something in Photoshop? Annoyed that Brightness/Contrast doesn't have a keyboard shortcut by default? It is easy to assign a keyboard shortcut in Photoshop, just be wary that most keyboard shortcuts are already in use, so chances are you'll have to remove a shortcut from something else first. There's plenty of things you probably don't use (like shortcuts to specific Filters), so that shouldn't be a problem.
Continue Reading ›
7 Photoshop Keyboard Shortcuts for Web Designers
Dec 12, 2011Windows
These are the Photoshop shortcuts that have improved my efficiency when designing websites the most. Some are basic; some are a little more obscure. I thought I would share them.
Continue Reading ›
How-to: Animated gif in Adobe Photoshop CS3
Aug 24, 2010WindowsComments (1)
With CS3, Adobe incorporated features from ImageReady into Photoshop, so you can now create animated gifs completely inside Photoshop. Here's how:
Continue Reading ›
NewerPage 2Older