MS Excel Worksheets Tips Tricks

-
Worksheets

Renaming sheets
Double-click the sheet tab and type a name of up to 32 characters.
Spaces, hyphens, and underscores are allowed in worksheet names.
Press Enter when finished.

Coloring sheet tabs
Excel 2002/2003 Only
Right-click the sheet tab and choose Tab Color from the shortcut menu.
Select a color.

Moving worksheets in a
workbook

Drag the sheet tab to a new location.
Copying a worksheet in a

workbook
Hold Ctrl and drag the sheet tab to a new location.

Moving and copying
between workbooks
Right-click the sheet tab and choose Move or Copy to open the dialog
box.

Navigating between sheets Right-click the navigation buttons and select the sheet you want to
move to OR

Press Ctrl+PgDn to move to the next sheet; Ctrl+PgUp to move to the
previous sheet; Ctrl+Tab to move to the next open workbook.

Popular posts from this blog

Open Blocked Web Site in any Country

-
How to Open Blocked Web Site Like Youtube, if any web site blocked in any Country by using proxy address you can open web site in your country i have some sample proxy address free for you. use it and enjoy it Thanks 061244235034.static.ctinets.com:3128 112.65.135.54:8080 114.143.12.28:8080 118.175.12.178:3128 118.228.148.52:3128 118.98.169.50:80 119.147.113.116:80 119.167.219.78:80 119.180.24.12:8080 119.245.230.164:80 119.62.128.38:80 119.70.40.101:8080 119.70.40.102:8080 121.10.120.214:80 121.14.158.76:80 121.30.255.38:8080 122.139.57.46:80 122.139.60.102:8080 122.224.33.10:80 122.224.33.4:80 125.64.96.21:8008 147.91.193.101:80 173-203-206-253.static.cloud-ips.com:80 174.142.104.57:3128 174.142.24.201:3128 174.142.24.203:3128 174.142.24.205:3128 174.142.24.206:3128 187.51.150.2:8080 189.115.161.205.static.gvt.net.br:8080 189.3.177.146:8080 189.3.47.146:3128 189.3.50.34:3128 196.12.52.2:80 196.38.158.197:80 201.45.216.115:3128 201.73.223.150:8080 202.51.105.10:3128 202.51.107.37:8080
Read more

OPERATION OF STENO PHONE

-
OPERATION OF STENO PHONE 1 EXTENSION WANTS TO TALK TO MAIN STATION Lift the handset at ext. and depress the call push button, buzzer at main station will ring after lifting the handset at main station and by throughing the key at main station to right side, ext can talk with main station. 2 MAIN STATION WANT TO TALK TO EXTENSION Main station through the key towards the right side and depress the pushbutton, the buzzer will ring at ext. Main station can talk with ext when handset is lifted at the ext. 3 INCOMING CALL DURING CONVERSATION BETWEEN MAIN AND EXTENSION The exchange call can only be received at the main station by throughing the key to the middle position, main can talk with exchange. INCOMING CALL 4 MAIN STAION WANTS TO HOLD THE INCOMIN CALL AND CONSULT THE EXTENSION Main station press the pushbutton and through the key again towards the right. 5 MAIN STATION WANTS TO CALL AGAIN WITH EXCHANGE Through the key again back in middle position. 6 EXTENSION WANTS TO GET THE EXCHANG
Read more