List of Photoshop CS5 useful common keyboard shortcuts

Familiarization of keyboard shortcuts in any software makes your work fast, easy and comfortable, and that’s is true with Adobe Photoshop CS5 provides a bunch of keyboard shortcuts to help accomplish your task in an effective way.

Now here is the list of available default keyboard shortcuts that can be useful to familiarized arranged according to group. 

ENVIRONMENT 

Shift+Tab  hide and un-hide all Photoshop panels.

Space Bar  hand tool that use to navigate over images.

}  Re-size the brush tip from small to big

{  Re-size the brush tip from big to small

Shift+}  adjust the hardness of the brush to strong

Shift+{  adjust the hardness of the brush to soft

Ctrl+~  Switch view of multiple image open in a tabbed.

TOOLBAR

D  Reset the default color of the toolbox the black for foreground color and white for background color.

X  Switch the background color of the toolbox to foreground color and vice versa.

L  Lasso Tool

M  Marquee Tool

W  Quick Selection Tool

C  Crop Tool

I  Eye Dropper Tool

]  Healing Brush Tool

B  Brush Tool

S  Clone Stamp Tool

Y  History Brush Tool

E  Eraser Tool

G Gradient Tool

O  Dodge Tool

P   Pen Tool

T  Text Tool

A  Path Selection Tool

K  3D Object Tool

N  Camera Tool

H  Hand Tool

R  Rotate View Tool

SELECTION

Ctrl+D Deselect

Shift+Ctrl+D Reselect

Alt +drag the mouse to constraint the square shape

Shift+drag the mouse to constraint the circle shape

Shift+Ctrl+I  Inverse selection

Alt+Ctrl+A Select All Layer

Alt+Ctrl+R Refine Mask

FILTER

Shift+Ctrl+R Lens Correction

Shift+Ctrl+X Liquify

Alt+Ctrl+V Vanishing Point

VIEW

Ctrl+Y View Proof Colors

Ctrl++  Zoom

Ctrl+-  Zoom out

Ctrl+0  Fit on Screen

Ctrl+1  Fit Actual Fixels

Ctrl+H Show Extras

Ctrl+’ Show Grid

Ctrl+R Show Rulers

Shift+Ctrl+; Snap

Alt+Ctrl+; Lock Guide

WINDOWS

Alt+F9 Action

F5 Brush

F6 Color

F8 Info.

F7 Layers

LAYER

Shift+Ctrl+N  Create new layer

Ctrl+J  Copy a layer

Shift+Ctrl+J  Cut a layer

Ctrl+G Group a layer, using this try to select the layers you want to group by pressing Ctrl key then click the number of layers you want to group.

 Shift+ Ctrl+G Ungroup layers.

Ctrl+E Merge layers

Shift+ Ctrl+E Merge visible

Shift+ Ctrl+[ Send to back

Shift+ Ctrl+] Send to front

Ctrl+] Bring forward

Ctrl+[ Bring backward

Alt+Ctrl+G Create clipping mask

IMAGE

Ctrl+L To access the levels dialog box

Ctrl+M To access the curves dialog box

Ctrl+U To access the hue/saturation dialog box

Ctrl+B To access the color balance dialog box

Alt+Ctrl+Shift+B To access the curves dialog box

Ctrl+I Invert

Shift+Ctrl+U Desaturate

Alt+Ctrl+I To access image size dialog box

Alt+Ctrl+I To access canvas size dialog box

EDITING

Ctrl+Z Undo the delete state

Shift+Ctrl+Z Step forward

Ctrl+V Paste

Shift+ Ctrl+V paste special

Shift+F5 Fill

Alt+Shift+Ctrl+C Content aware scale

Ctrl+T Free transform

Shift+Ctrl+K Access Color Settings Dialog box

Alt+Shift+Ctrl+K Access Keyboard Shortcuts dialog box

Alt+Shift+Ctrl+K Access Menus dialog box

Ctrl+K Access Preferences dialog box

FILE

Ctrl+N  Open New Document Dialog box

Ctrl+O  Open Document Dialog box

Alt+Ctrl+O Browse in Bridge

Ctrl+W Close Document

Alt+Ctrl+W Close All Document

Shift+Ctrl+W Close the Document and go to Bridge

Ctrl+S Save

Shift+Ctrl+S Save As

F12 Revert

Alt+Shift+Ctrl+I File Info.

Ctrl+Q Exit

SELECTION

Ctrl+D Deselect

Shift+Ctrl+D Reselect

Alt +Drag the mouse to constraint the square shape

Shift+drag the mouse to constraint the circle shape

Shift+Ctrl+I Inverse selection

Alt+Ctrl+A Select All Layer

Alt+Ctrl+R Refine Mask

FILTER

Shift+Ctrl+R Lens Correction

Shift+Ctrl+X Liquify

Alt+Ctrl+V Vanishing Point

But if you are not comfortable using the common shortcuts in Adobe Photoshop CS5 you can customized your own keyboard shortcuts by simply go to edit menu and click keyboard shortcuts or press Alt+Shift+Ctrl+K.Key.

then this is keyboard shortcuts dialog box.

you can select from three (3) where you can put shortcuts from menu, panel and tools then to modify just follow the instruction below.

 but before proceeding save first the set name or the shortcut key configuration 

from save dialog box you can name it what you want

you may now set your own keyboard shortcuts by following the instructions below.

if the shortcut keys you set is already in-used message below will appear, and you had an option to proceed that will remove the shortcut to its original function and be set to which you choose. after settings all done just click the button Accept to take effect. but make sure the name of your set or shortcut configuration is set on default like what we did we name that config. My Photoshop Personal Shortcuts.

you can save keyboard shortcuts configuration as many as you want. to switch from other sets just select the available name at the list.  

Configuring the .Net app.config to access Database via LAN

A sample configuration of vb.net application settings that allows to communicate via Local Area Network, using MSSQL Server Authentication mode.

Look for app.config in your project and open it then find the code that's look like below.

Just edit the IP Address which the MSSQL SEVER installed then the name of MSSQL SEVER supply the User Name and Password.

(click the picture to in-large)

Note: the above configuration will only works if the MSSQL SEVER has been configured to allows remote access.

VB.NET 2005 Debugging and fixing error issue

I' was a vb 6.0 programmer for about  year 7 but since I know that the application in vb 6.0 although can be installed in a new version windows operating system like Windows Vista, Windows 7 but eventually the compatibility issue will be a problem since Microsoft already drop its support in Visual Basic 6.0 last 2001 if I not mistaken, then the application written in vb 6.0 will become isolated eventually. That's why I decided ship from vb.net. Obviously is different environment although most of the vb 6.0 functionality are still intact in dotnet framework, but i can say that its different.

My first application I built in vb.net is a customized accounting system of a certain company, but during my development I encounter problems during debugging. and it cost me a lot of this type of error as a new to the framework.

in this picture a sample error generated during the build of my application, and it is intentional for the sake of illustration. this will occur if you made some changes in your code and windows form vice versa, that doesn't much each other. for instance I accidentally deleted the textbox name P_unit_idTextBox, that still used in my application then the error generate as shown here:

the problem is how do i fixed the error, and then restore the textbox on my form. if  I can't open the form. some suggested to edit the "designed.vb" of the form or the .resx but as a novice its to dangerous to do.

what I do in this problem is that i always make a backup of my application from time to time that I make changes to it. so that if that error occurred I simply delete the module or form that is affected, and then from the back-up file I enable to restore it, the time this type of error occurred again.

function code that convert number to words(vb6 to vb.net)

Public Function NumToText(ByVal dblValue As Double) As String
Static ones(0 To 9) As String
Static teens(0 To 9) As String
Static tens(0 To 9) As String
Static thousands(0 To 4) As String
Dim i, x, y As Integer, nPosition As Integer
Dim nDigit As Integer, bAllZeros As Integer
Dim strResult As String, strTemp As String, strTemp1 As String
Dim tmpBuff As String


ones(0) = "zero"
ones(1) = "one"
ones(2) = "two"
ones(3) = "three"
ones(4) = "four"
ones(5) = "five"
ones(6) = "six"
ones(7) = "seven"
ones(8) = "eight"
ones(9) = "nine"

teens(0) = "ten"
teens(1) = "eleven"
teens(2) = "twelve"
teens(3) = "thirteen"
teens(4) = "fourteen"
teens(5) = "fifteen"
teens(6) = "sixteen"
teens(7) = "seventeen"
teens(8) = "eighteen"
teens(9) = "nineteen"

tens(0) = ""
tens(1) = "ten"
tens(2) = "twenty"
tens(3) = "thirty"
tens(4) = "forty"
tens(5) = "fifty"
tens(6) = "sixty"
tens(7) = "seventy"
tens(8) = "eighty"
tens(9) = "ninty"

thousands(0) = ""
thousands(1) = "thousand"
thousands(2) = "million"
thousands(3) = "billion"
thousands(4) = "trillion"

'Trap errors
On Error GoTo NumToTextError

'Get fractional part
strResult = Format((dblValue - Int(dblValue)) * 100)
'Convert rest to string and process each digit
strTemp = CStr(Int(dblValue))

'Iterate through string
For i = Len(strTemp) To 1 Step -1
'Get value of this digit
nDigit = Val(Mid$(strTemp, i, 1))
'Get column position
nPosition = (Len(strTemp) - i) + 1
'Action depends on 1's, 10's or 100's column
Select Case (nPosition Mod 3)
Case 1 '1's position
bAllZeros = False
If i = 1 Then
tmpBuff = ones(nDigit) & " "
ElseIf Mid$(strTemp, i - 1, 1) = "1" Then
tmpBuff = teens(nDigit) & " "
i = i - 1 'Skip tens position
ElseIf nDigit > 0 Then
tmpBuff = ones(nDigit) & " "
Else
'If next 10s & 100s columns are also
'zero, then don't show 'thousands'
bAllZeros = True
If i > 1 Then
If Mid$(strTemp, i - 1, 1) <> "0" Then
bAllZeros = False
End If
End If
If i > 2 Then
If Mid$(strTemp, i - 2, 1) <> "0" Then
bAllZeros = False
End If
End If
tmpBuff = ""
End If
If bAllZeros = False And nPosition > 1 Then
tmpBuff = tmpBuff & thousands(nPosition / 3) & " "
End If
strResult = tmpBuff & strResult
Case 2 'Tens position
If nDigit > 0 Then
strResult = tens(nDigit) & " " & strResult
End If
Case 0 'Hundreds position
If nDigit > 0 Then
strResult = ones(nDigit) & " hundred " & strResult
End If
End Select
Next i
'Convert first letter to upper case
If Len(strResult) > 0 Then
strResult = UCase$(Left$(strResult, 1)) & Mid$(strResult, 2)
End If

EndNumToText:

'Return result
y = Len(strResult)
strTemp1 = Mid(strResult, 1, y - 1)

NumToText = strTemp1 & "only"
Exit Function

NumToTextError:
strResult = "#Error#"
Resume EndNumToText
End Function

Manipulate Your MS Word 2007 Document Using Shortcut Keys

Sometimes it is more comfortable to navigate and manipulate Microsoft Word Document using Keyboard instead of mouse specially if you're accessing tools that contained inside the menu and sub-menus and so on, but even the very accessible command buttons like bold, italic, underline etc. to be honest it is really comfortable to Press CTRL+B for bold, CTRL+I for Italic and CTRL+U for Underline. Much more for Copy, Cut and Paste command if you will not used each shortcut keys for it like CTRL+C for Copy, CTRL+X for Cut and CTRL+V for Paste you need to right-click select from the menu every time you will impose a command and its very tiring process but thanks for shortcut keys it helps a lot.

But despite of the benefits some users choose not to use this shortcut keys because it's difficult to remember the combination keys in the keyboard and it is true from the previous version of Microsoft Word like 1997, 2000, 2003, but for 2007 version up this problem were solved, so no need for the user to remember those all keys combination only one key to remember the Alt, Press the Alt key and all those shortcut keys will be visible at the toolbar menus above.

here is will happen when you press Alt key and the shortcut keys will be revealed from main menu.

say for instance you press Alt+H for Home, notice that another shortcut keys were revealed  

and if you choose particular tools like what I did I press the key Alt+FC then from the tools has another shortcut keys as we see.

try to practice some shortcut keys combination so we can use it confidently.

How To Reference Cells in Other Excel Files

Here is the problem if we maintained lots of data and report in Microsoft Excel, and we use several files to handle that data say for instance we use separate file for the list of inventory in the previous period or quarter and want to sum-up the inventory of the previous figure to the current figure using the two excel files.

Here is the formula that will help you.  

Like my previous post about How to Reference Cells in Other Sheet http://toxiod.blogspot.com/2011/12/how-to-reference-microsoft-excel-cells.html their is also a way on How To Reference Cells in Other Excel Files by using the formula similar to the previous example we just add the path where the excel files reside plus the name of the particular file. here is the formula ('The Path of the File\File Name\[Sheet Name]Sheet Name' Exclamation Point Cell Name)

Say for instance if we want to get the sum of the figure that contained from two separate excel files named Book1 Sheet1 Cell A1 and Book2 Sheet1 Cell A1 and want to display the result to other excel file named Book0.

here is the actual formula assuming that our file resided from Drive C

=SUM('C:\Book1\[Sheet2]Sheet2'!A1+'C:\Book2\[Sheet3]Sheet3'!A1)

How To Reference Microsoft Excel Cells into Other Worksheets

Here is the formula on how to reference cell in other worksheets:

Name of Sheet exclamation point Name of Cell. How can we use it?

Its like for example you have three sheets in your excel file called Sheet1,Sheet2,Sheet3 and we need to sum-up the figure from Sheet2 cell named A1 and Sheet3 cell named A1 from Sheet1 cell named A1. the actual formula would be like this =Sum(Sheet2!A1+Sheet3!A1)

 this is the result