Wednesday, September 28, 2011

How to Enable Hyper Terminal In Windows 7

Hyperterminal Windows 7.
Windows 7 Hyperterminal.
Hyper terminal is used for data communication via serial port com or TCP/IP Winsock. Unfortunately on Windows 7, Windows 8 and Windows 10 we can't see anymore, even though many of us who still need it, and it is not the solution if we have to go back to Windows XP.
The solution :

Friday, September 23, 2011

List of Microsoft Excel Keyboard Shortcut

Just as in other Microsoft Office Software,  in Microsoft Excel  if we want to work  faster or you don't like to use a mouse, then you can use keyboard to hit the shortcut key.
 

Bellow are list of shortcut keys for Ms Excel :


NoShortcutDescription
1      Ctrl + A      select all
2      Ctrl + B      make Bold 
3      Ctrl + I      make italic
4      Ctrl + K      insert link.
5      Ctrl + U      make under line
6      Ctrl + P      Show print dialog
7      Ctrl + Z      Undo
8       F2      Edit  selected cell
9       F5      Go to defined cell
10       Shift + F5      showing search form
11       F7      Check spelling
12       F11      making chart
13       Shift + F3      Insert function / formula
14      Ctrl + Shift + ;      Insert time (hour,min)
15      Ctrl + ;      insert date
16      Alt + Shift + F1      new worksheet
17      Ctrl + 5      strikethrough
18      Ctrl + F9      Minimize
19      Ctrl + F10      Maximize 
20      Ctrl + F6      Switch between opened excel
21      Ctrl + Page up      toggle beetwen Sheet to the left
22      Ctrl + Page down      toggle beetwen Sheet to the right
23      Ctrl + Tab      toggle beetwen opened  excel
24      Alt + =      add sum formula
25      Ctrl + '      inserting the value upside cell
26      Ctrl + Shift + !      Number in coma format
27      Ctrl + Shift + $      currency format
28      Ctrl + Shift + #      date formating
29      Ctrl + Shift + %      formating in percent
30      Ctrl + Shift + ^      format in scient
31      Ctrl + Shift + @      time formating
32      Ctrl + Arrow key        move to next text
33      Ctrl + Space      select all columb
34      Shift + Space      select all row.

Tuesday, September 20, 2011

Kill Task using Click Mouse, Without Ctrl+Alt+Del

If  your program stop working and appears warning Not Responding, we usualy have to kill the process by pressing the combination key Ctrl + Alt + Del  to get into task manager to end  the troubled program.

We can also kill Process / End task by using click the mouse, without pressing the Ctrl + Alt + Del

We can make the shortcut for Kill Process, so if we need to make ending task  just Click the shortcut using mouse.

To make the Shortcut
 Right click on the screen on the desktop, click New -> Shortcut
 In the column type the location of the item copy and paste this code:
taskkill.exe / f / fi "status eq not responding"
 Click Next, click Finish.


See Also :
 How to lock the leftmost column or top row cells in Ms Excel 2007 
 How to Remove or Disable Ctrl-Alt-Del when Log in to Windows 
 Creating New Folder in Windows 7 without  click mouse 

Sunday, September 18, 2011

Freeze Panes in MS Excel 2007 (lock the leftmost column or top row)

If you work with spreadsheets with large size, and want the top row or leftmost column (which usually contains a description, number, date, name, etc) are always visible (because of  limited display screen of computer), we can use the Freeze Panes tool.

1. Open your Excel Spreadsheet Document
2. Highlight  the cell just below the second row and second column, (assuming the first row and first column to be locked)
3. Click the View Tab
4. Click Freeze Panes
5. Click Freeze Panes,  

the row and first column will lock, to see the result try moving to the far down or right side cell.


To restore to its original state (without freeze panes)
1. Click the View Tab
2. Click the Freeze Panes
3. Click unfreeze Panes.

Saturday, September 17, 2011

Displaying Random Home Page in Browser

Want something different every time you open your computer's browser?.

The following
interesting web sites provide links to make random page of their articles.
Just put the link on the Home Page settings in your browser, then every time the browser is run, will present a different page.

Thursday, September 15, 2011

How to Backup and Restore HP ProCurve Switch Configuration via Serial port

For anticipation loss or destruction the configuration of a managed switch, we should backup the configuration, so if a problem occurs, we can easily restore or copy the configuration file into a new equipment.

For HP ProCurve Networking (switches ProCurve 2910, 2510 series, etc.), one of the way to backup and restore is done through a serial port rs 232, using a hyper terminal connection.

Step by step Backup

Assumptions, Switch has been connected to the computer using a serial cable and use the hyper terminal and logged in as a manager (administrator)

• Type : copy startup-config xmodem pc then hit the enter key
• Click on the Transfer menu and then select Receive File

Wednesday, September 14, 2011

Script to make the computer speaks according to the words we wrote


With a few script, we can make the computer speak according to the text that we have written.
Follow these steps :

• Open Notepad
• Copy and Paste to notepad these script bellow
Dim message, sapi
message=InputBox("What do you want me to say?","Speak to Me")
Set sapi=CreateObject("sapi.spvoice")
sapi.Speak message 

Monday, September 12, 2011

Enabling Telnet in Windows 7

Unlike the previous windows, Windows XP and Windows Vista, Telnet in Windows 7 By default is not activated.

Here are the steps to enable Telnet in Windows 7

1. Click Start
2. Click Control Panel
3. Select View By : Large icons or small icons ( at the up right of the page )
4. Select Programs And Features
5. Click Turn Windows features on or off ( at the up left of the page )
6. Give a checklist at Telnet Client
7. Click OK.