MS Excel Keyboard Short-cuts

• Ctrl + A − Selects all contents of the worksheet.
• Ctrl + B − Bold highlighted selection.
• Ctrl + I − Italicizes the highlighted selection.
• Ctrl + K − Inserts link.
• Ctrl + U − Underlines the highlighted selection.
• Ctrl + 1 − Changes the format of selected cells.
• Ctrl + 5 − Strikethrough the highlighted selection.
• Ctrl + P − Brings up the print dialog box to begin printing.
• Ctrl + Z − Undo last action.
• Ctrl + F3 − Opens Excel Name Manager.
• Ctrl + F9 − Minimizes the current window.
• Ctrl + F10 − Maximize currently selected window.
• Ctrl + F6 − Switches between open workbooks or windows.
• Ctrl + Page up − Moves between Excel work sheets in the same Excel document.
• Ctrl + Page down − Moves between Excel work sheets in the same Excel document.
• Ctrl + Tab − Moves between Two or more open Excel files.
• Alt + = − Creates a formula to sum all of the above cells
• Ctrl + ' − Inserts the value of the above cell into cell currently selected.
• Ctrl + Shift + ! − Formats the number in comma format.
• Ctrl + Shift + $ − Formats the number in currency format.
• Ctrl + Shift + # − Formats the number in date format.
• Ctrl + Shift + % − Formats the number in percentage format.
• Ctrl + Shift + ^ − Formats the number in scientific format.
• Ctrl + Shift + @ − Formats the number in time format.
• Ctrl + Arrow key − Moves to the next section of text.
• Ctrl + Space − Selects the entire column.
• Shift + Space − Selects the entire row.
• Ctrl + - − Deletes the selected column or row.
• Ctrl + Shift + = − Inserts a new column or row.
• Ctrl + Home − Moves to cell A1.
• Ctrl + ~ − Switches between showing Excel formulas or their values in cells.
• F2 − Edits the selected cell.
• F3 − After a name has been created F3 will paste names.
• F4 − Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
• F5 − Goes to a specific cell. For example, C6.
• F7 − Spell checks the selected text or document.
• F11 − Creates chart from the selected data.
• Ctrl + Shift + ; − Enters the current time.
• Ctrl + ; − Enters the current date.
• Alt + Shift + F1 − Inserts New Worksheet.
• Alt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
• Shift + F3 − Opens the Excel formula window.
• Shift + F5 − Brings up the search box.

Learn Excel

Inserting Data

For inserting data in MS Excel, just activate the cell type text or number and press enter or Navigation keys.

Inserting Formula

For inserting formula in MS Excel go to the formula bar, enter the formula and then press enter or navigation key. See the screen-shot below to understand it.

Modifying Cell Content

For modifying the cell content just activate the cell, enter a new value and then press enter or navigation key to see the changes. See the screen-shot below to understand it.

Coronavirus News: 43 Have Coronavirus In Andhra Pradesh After Attending Delhi Mosque Event

All 43 patients, who tested positive for COVID-19 in Andhra Pradesh on Wednesday, had returned to the state after attending the event at Delhi's Nizamuddin Markaz, the Chief Minister's Office said.

With 43 new COVID-19 positive cases, the total number of coronavirus cases in Andhra Pradesh has reached 87, informed the state's Nodal Office earlier today.

The 43 new coronavirus positive cases were reported between March 31 and April 1.

373 samples were tested during this time period and of them, 330 were negative while 43 tested positive.

240 COVID-19 cases have been reported in the last 12 hours across the country.

According to the Ministry of Health and Family Welfare, the total number of COVID-19 positive cases have reached 1,637 in India while 38 have died.

https://api.whatsapp.com/send?phone=41794752209&text=hi&source=&data=

To prevent infection and to slow transmission of COVID-19, do the following:

• Wash your hands regularly with soap and water, or clean them with alcohol-based hand rub.
• Maintain at least 1 metre distance between you and people coughing or sneezing.
• Avoid touching your face.
• Cover your mouth and nose when coughing or sneezing.
• Stay home if you feel unwell.
• Refrain from smoking and other activities that weaken the lungs.
• Practice physical distancing by avoiding unnecessary travel and staying away from large groups of people.

Applications are invited for filling up the following vacancies:

Bsnl 4g Will Tentatively Launch On March 1 2020 And To Announce 4g Only Plans

ఇండియన్ ఆయిల్ కార్పొరేషన్‌లో 321 ఖాళీలు

EPFO'లో ఉద్యోగాలు.. ఇవీ అర్హతలు

పోస్టుల వివ‌రాలు..