Tuesday, 26 July 2016

Keyboard Shortcuts for Excel



Formatting

[Ctrl]B  Bold the selection
[Ctrl]I  Italicize the selection
[Ctrl]U  Underline the selection
[Ctrl]5  Strike through the selection
[Alt] and '  Open the Style dialog box
[Ctrl]1  Open the Format Cells dialog box
[Ctrl][Shift]~  Apply General format
[Ctrl][Shift]$  Apply Currency format
[Ctrl][Shift]%  Apply percentage format
[Ctrl][Shift]#  Apply Date format
[Ctrl][Shift]@  Apply Time format
[Ctrl][Shift]!  Apply Number format
[Ctrl][Shift]^  Apply Exponential number format
[Ctrl][Shift]&  Apply an outline border to selection
[Ctrl][Shift] and _  Remove outline border from selection


Navigation

[Ctrl][Page Down]  Move to the next worksheet in a workbook
[Ctrl][Page Up]  Move to the previous worksheet in a workbook
[Ctrl][F6]  Cycle between open workbooks
Arrow keys  Move one cell up, down, left, or right
[Ctrl] and an arrow key Move to the edge of the data region
[Home]  Move to the beginning of a row
[Ctrl][Home]  Move to the beginning of a worksheet
[Ctrl][End]  Move to the end of the used portion of a worksheet
[F6]  Move between panes in a split worksheet
[Ctrl][Backspace]  Display the active cell
[Enter]  Move down a cell in a selected range
[Shift][Enter]  Move up a cell in a selected range
[Shift][Tab]  Move one cell to the left in a selected range
[Ctrl] and . (period)  Move from corner cell to corner cell in a selected range


Selection techniques

[Shift][Spacebar]  Select a row
[Ctrl][Spacebar]  Select a column
[Ctrl]A  Select an entire worksheet
[Shift][Home]  Select from current cell(s) to the beginning of the row
[Shift][End][Enter]  Select from current cell(s) to last used cell in row
[Ctrl][Shift][Home]  Select from current cell(s) to the beginning of the worksheet
[Ctrl][Shift][End]  Select from current cell(s) to the end of the used portion of a worksheet
[Ctrl] and *
Select the data region surrounding the active cell
[Ctrl][Shift]O
Select all cells that contain a comment
[Ctrl] and [ Select cells that a selected formula directly references
[Ctrl] and ]  Select formulas that directly reference the active cell


Workbook basics

[Ctrl]O  Open a workbook
[Ctrl]N  Create a new workbook
[Ctrl]S  Save a workbook
[F12]  Open the Save As dialog box
[Ctrl]P  Print a workbook
[Ctrl]W  Close a workbook
[Shift][F11]  Insert a new worksheet
[Ctrl]9  Hide selected rows
[Ctrl][Shift]9  Display hidden rows in selection
[Ctrl]0  Hide selected columns
[Ctrl][Shift]0  Display hidden columns in selection
[Ctrl]F  Open the Find tab of the Find And Replace dialog box
[Ctrl]H  Open the Replace tab of the Find And Replace dialog box
[F7]  Run a spelling check on a worksheet or selected text


Working with data

[Enter]  Complete an entry and move to the next cell
[Alt][Enter]  Insert a new line within a cell
[F2]  Enable editing within a cell
[Ctrl][Enter]  Fill selected cells with an entry you type
[Ctrl]D  Fill data down through selected cells
[Ctrl]R  Fill data through selected cells to the right
[Ctrl][F3]  Create a name
[Ctrl]K  Insert a hyperlink
[Ctrl] and ; (semicolon)  Insert the current date
[Ctrl] and : (colon)  Insert the current time
[Ctrl]X  Cut the selected text or objects to the Clipboard
[Ctrl]C  Copy the selected text or objects to the Clipboard
[Ctrl]V  Paste the contents of the Clipboard
[Ctrl]Y  Repeat last action
[Ctrl]Z  Undo last edit
[Ctrl][Delete]  Delete from the insertion point to the end of the line
[Ctrl][Shift]+  Add blank cells
[Ctrl]- (hyphen)  Delete selected cells
[F11]  Create a chart from a range of data


Formula shortcuts

=  Begin a formula
[Ctrl][Shift][Enter]  Enter a formula as an array
[Shift][F3]  Display the Insert Function dialog box (Paste Function in Excel 97)
[F3]  Paste a defined name into a formula
[Alt]=  Insert a SUM AutoSum formula
Type a function in the Formula bar and press [Ctrl]A  Display the Function Arguments dialog box
[Ctrl][Shift] and "  Copy the value from the cell above the current cell into the current cell
[Ctrl] and '  Copy a formula from the cell above the current cell into the current cell
[Ctrl] and `  Toggle between display of formulas and cell values
[F9]  Calculate values for sheets in all open workbooks
[Shift][F9]  Calculate values for the current worksheet
[Esc]  Cancel an entry you're making in a cell or in the formula bar

Sunday, 17 July 2016

Ten best Indian Army quotes

Ten best Indian Army quotes:

1. "Either I will come back after hoisting the tricolocr, or I will come back wrapped in it, but I will be back for sure.”
 – Capt. Vikram Batra, Param Veer Chakra

2. “What is a lifetime adventure for you is a daily routine for us.” – Ladakh Leh highway  sign board Indian Army

3. “If death strikes, before I prove my blood, I swear I’ll kill death.” – Capt. Manoj Kumar Pandey, Param Veer Chakra 1/11 Gorkha Rifles

4. “Our flag does not fly because the wind moves it, it flies with the last breath of each soldier who died protecting it.”

5. “To find us, you must be good, to catch us you must be fast, but to beat us…………you must be kidding.”

6. “May God have mercy on our enemies, because we won’t.”

7. “We live by chance, we love by choice, we kill by profession.” – Officers Training Academy, Chennai

8. “If a man says he’s not afraid of dying, he’s either lying, or he’s a Gorkha.” –
Field Marshal Sam Manekshaw

9. “It is God’s duty to forgive the enemies, but it’s our duty to convene a meeting between the two.”

10. “I regret I have but one life to give for my country.” –
Officer Prem Ramchandani

Saturday, 16 July 2016

When We Need To Take The Rightful Decision.



Put A Frog In A Vessel Of Water And Start Heating The Water.
As The Temperature Of Water Rises, Frog Keeps On Adjusting With Increase In Temperature.
Just When The Water Is About To Reach Boiling Point, The Frog Is Not Able To Adjust Anymore.
At That Point The Frog Decides To Jump Out But Is Unable To Do So, Because it Has Lost All Its Strength In Adjusting With The Rising Water Temperature.
Very Soon The Frog Dies.
What Killed The Frog? Many Of Us Would Say The Boiling Water.
No, It's Frog's Own Inability "To Decide When It Had To Jump Out."
We All Need To Adjust With People And Situations, But We Need To Be Sure When We Need To Take The Rightful Decision.