MS-Excel Short Key

-

Home
Move to column A
Tab
Navigate a cell - right
Shift + Tab
Navigate a cell - left
Ctrl + Arrow
Move to edge of current data region
End + Arrow
Move to edge of current data region
Shift + Arrow
Navigate a cell - all arrow directions - with selection
Ctrl + Home
Move to the beginning of the Worksheet
Ctrl + End
Move to the end of the Worksheet
Alt + Page Down
Move one screen to right
Alt + Page Up
Move one screen to left
Ctrl + Page Down
Move to the next worksheet
Ctrl + Page Up
Move to the previous worksheet
F6
Move to the next pane in split worksheet
Shift + F6
Move to the previous pane in split worksheet
Ctrl + .
Move to the corners of selection and verify your selection
Ctrl + `
Switch between value and formula
Alt + T, U, T
Trace Precedents
Alt + T, U, D
Trace Dependents
Alt + T, U, A
Remove all arrows
Ctrl + [ or Ctrl + ]
Switch to Data Sheet from the formula or vice-versa
Editing
F2
Edit cell contents
Shift + F2
Edit/Create a cell comment
Delete
Delete cell contents
Ctrl + -
Delete selected row or column
Ctrl + Delete
Delete all text to the right of current editing
Alt + Enter
Enter a new line while editing in the same cell - word wrap
Ctrl + +
Insert a row or column before selection (row/column selection)
Ctrl + Shift + A
Type a function; press combo; inserts function syntax
Ctrl + Enter
Select range; enter data/function; press combo; copies to selection
Shift + Enter
Stop editing and move a cell up
Ctrl + Alt + V
Paste Special (Version 2007 and above)
Ctrl + F3
Define names
Shift + F3
Open all functions dialog box
Ctrl + A
Display a function window for the typed function
Ctrl + D
Copy down the selection
Ctrl + R
Copy to the right in the selection
Ctrl + Shift + "
Copy contents of above cell in the current cell and edit
Ctrl + ;
Enter Date
Formatting
Ctrl + 1
Display Format Cells dialog box
Ctrl + Shift + ~
Apply number format
Ctrl + Shift + !
Apply number format
Ctrl + Shift + $
Apply currency format
Ctrl + Shift + %
Apply percentage format
Ctrl + Shift + #
Apply date format
Ctrl + Shift + &
Apply outline border
Ctrl + Shift + _
Remove outline border
Selection
Ctrl + Shift + *
Select data region around current cell
Shift + Home
Extend selection to beginning of row
Shift + Spacebar
Select entire row
Ctrl + Spacebar
Select entire column
F8
Turn on/off selection mode; then start moving around
Shift + F8
Multi-select - select range; press combo; select another range; repeat
Alt+;
Select visible cells (ignores hidden rows/columns in the selection)


Popular posts from this blog

SCFT - Single Cell Function test

-
Single Cell Function test SCFT is for verifying whether individual BTS works well or not, by making a single cell function test of BTS hardware and software. Essential items to be tested are as follows: 1) BTS Transmitter Output Measurement Test 2) Initial parameter establishment (Pilot PN/System ID/Site ID/Frequency, Neighbor List) 3) Call Origination and Termination Test 4) Softer Handoff Test/Antenna installation check (Direction, Tilt, Transmission Line) 5) Single Cell Coverage Test 6) Noise Floor Test 7) Parameter check.
Read more

Troubleshooting for GSM KPIs (SD Block & SD Drop)

-
KPIs to be monitored: ·             SD Blocking ·             SD Drop SDCCH Channel: ·    SDCCH channel is a dedicated channel which is using for LAC updation, Call Setup, SMS in Ideal mode. It works in UL & DL SD Blocking: ·    SD Blocking means that you are not getting SD resource for the call origination. When MS connects with Network then RACH and AGCH are provided. After AGCH, SDCCH is provided but if SDCCH is not provided at this time due to some problem or due to unavailable of SD by BSC. KPI Formula in Ericsson: ·             SDCCH CONGESTION = (CCONGS / CCALLS) * 100 ·             CCONGS - Congestion counter. ·  ...
Read more

PS core network

-
Image
The PS core network consists of two parts, the traditional General Packet Radio Service (GPRS) core network and the new Evolved Packet System (EPS) core network. The PS core network connects mobile subscribers to Packet Data Networks (PDNs) such as the Internet, corporate networks or operator services networks.  a functional overview of the PS core network. Logical entities and interfaces are shown in black and form a 2G/3G network, while the blue boxes and lines in Figure  show the LTE/EPC related parts. The LTE/EPC network can be regarded as an extension and evolution of existing 2G/3G networks. From a node implementation perspective, there is no strict border between the two networks. The corresponding logical entities of GPRS and EPS networks can be deployed concurrently in Ericsson PS core nodes, such as the SGSN-MME and EPG; these are marked in red. In addition, Ericsson GPRS nodes can be upgraded with EPC functionality by software only. Network evolution i...
Read more