MICROSOFT EXCEL

-

  • Shortcut Description

Ctrl+A Select all contents of a worksheet.
Ctrl+B Bold all cells in the highlighted section.
Ctrl+C Copy all cells in the highlighted section.
Ctrl+D Fill down. Fills the cell beneath with the
contents of the selected cell. To fill more than
one cell, select the source cell and press Ctrl
+Shift+Down to select multiple cells. Then press
Ctrl+D to fill them with the contents of the
original cell.
Ctrl+F Search current sheet.
Ctrl+G Go to a certain area.
Ctrl+H Find and replace.
Ctrl+I Puts italics on all cells in the highlighted
section.
Ctrl+K Inserts a
hyperlink.
Ctrl+N Creates a new workbook.
Ctrl+O Opens a workbook.
Ctrl+P Print the current sheet.
Ctrl+R Fill right. Fills the cell to the right with
the contents of the selected cell. To fill more
than one cell, select the source cell and press
Ctrl+Shift+Right to select multiple cells. Then
press Ctrl+R to fill them with the contents of the
original cell.
Ctrl+S Saves the open worksheet.
Ctrl+U Underlines all cells in the highlighted
section.
Ctrl+V Pastes everything copied onto the
clipboard .
Ctrl+W Closes the current workbook.
Ctrl+X Cuts all cells within the highlighted
section.
Ctrl+Y Repeats the last entry.
Ctrl+Z Undo the last action.
Ctrl+1 Changes the format of the selected cells.
Ctrl+2 Bolds all cells in the highlighted section.
Ctrl+3 Puts italics all cells in the highlighted
section.
Ctrl+4 Underlines all cells in highlighted section.
Ctrl+5 Puts a
strikethrough all cells in the highlighted section.
Ctrl+6 Shows or hides objects.
Ctrl+7 Shows or hides the toolbar .
Ctrl+8 Toggles the outline symbols.
Ctrl+9 Hides rows.
Ctrl+0 Hides columns.
Ctrl+Shift+: Enters the current time.
Ctrl+; Enters the current date.
Ctrl+` Changes between displaying cell values or
formulas in the worksheet.
Ctrl+' Copies a formula from the cell above.
Ctrl+Shift+" Copies value from cell above.
Ctrl+- Deletes the selected column or row.
Ctrl+Shift+= Inserts a new column or row.
Ctrl+Shift+~ Switches between showing Excel
formulas or their values in cells.
Ctrl+Shift+@ Applies time formatting.
Ctrl+Shift+! Applies comma formatting.
Ctrl+Shift+$ Applies currency formatting.
Ctrl+Shift+# Applies date formatting.
Ctrl+Shift+% Applies percentage formatting.
Ctrl+Shift+^ Applies exponential formatting.
Ctrl+Shift+* Selects the current region around
the active cell.
Ctrl+Shift+& Places border around selected cells.
Ctrl+Shift+_ Removes a border.
Ctrl++ Insert.
Ctrl+- Delete.
Ctrl+Shift+( Unhide rows.
Ctrl+Shift+) Unhide columns.
Ctrl+/ Selects the array containing the active
cell.
Ctrl+\ Selects the cells that have a static value
or don’t match the formula in the active cell.
Ctrl+[ Selects all cells referenced by formulas in
the highlighted section.
Ctrl+] Selects cells that contain formulas that
reference the active cell.
Ctrl+Shift+{ Selects all cells directly or indirectly
referenced by formulas in the highlighted
section.
Ctrl+Shift+} Selects cells which contain formulas
that directly or indirectly reference the active
cell.
Ctrl+Shift+| ( pipe ) Selects the cells within a
column that don’t match the formula or static
value in the active cell.
Ctrl+Enter Fills the selected cells with the
current entry.
Ctrl+Spacebar Selects the entire column.
Ctrl+Shift+Spacebar Selects the entire
worksheet.
Ctrl+Home Move to cell A1.
Ctrl+End Move to last cell on worksheet.
Ctrl+Tab Move between Two or more open Excel
files.
Ctrl+Shift+Tab Activates the previous workbook.
Ctrl+Shift+A Inserts argument names into a
formula.
Ctrl+Shift+F Opens the
drop-down menu for fonts.
Ctrl+Shift+O Selects all of the cells that contain
comments.
Ctrl+Shift+P Opens the drop-down menu for point
size.
Shift+Insert Pastes what is stored on the
clipboard.
Shift+Page Up In a single column, highlights all
cells above that are selected.
Shift+Page Down In a single column, highlights
all cells above that are selected.
Shift+Home Highlights all text to the left of the

  • cursor .
  • Shift+End Highlights all text t

Comments

Post a Comment

Popular posts from this blog

CROP PRODUCTION MADE EASY...(Cucumber)

-
Image
CUCUMBER PRODUCTION **INTRODUCTION* Cucumber is a long vegetable with a dark green skin and light green flesh that is usually eaten raw. It is enjoyed by many and is one of the main constituents of fruit salad. **LAND PREPARATION* It thrives well in rich loamy or clayey soil. It does not require too much water for its growth. The land is cleared and ploughed if necessary. Mounds or ridges are made ready for the planting. **PLANTING* Improved seedlings are used for maximum output. These seeds are incorporated 2 per hole at a regular spacing of about 1ft - 2Ft on the mounds or ridges. This is best done around April/May. **FERTILIZER APPLICATION* This is best done after 2 - 3 weeks using N.P.K 15:15:15. Small holes are made at a distance of about 4 to 5 inches away from the young cucumber plant and the fertilizers are incorporated inside about match box full size. The spacing is to avoid causing harm to the young plant. **WEEDING* Weeding is done at regular inte
Read more

CUCUMBER FARMING... 1 MILLION NAIRA EXPERIENCE... SEE PHOTOS

-
Image
I dont believe in "internet farming, but I feel the need to encourage other Nigerian youths out there who want to venture into agribusiness. It has not been easy so far to farm in Nigeria. The challenges have been enormous but *in Lil Wayne's voice* "we doing aite". I'll just get straight to the point. This is a true farming experience of a Vegetable farmer, he says; "am a vegetable farmer. And farm majorly cucumber. I am pro-organic farming (it's very expensive in Nigeria). I employ technologies from around the world (especially thailand) that suit our climate and culture. I've been into this for quite a while now. Decided to upload pictures of how I plant and the agronomy I employ in my cucumber farming. To get more ideas from the pros here and tovexcite the intending farmers. First of all, this is 1 hectare of land, by the special grace of God, this land produced a gross profit of 1million in 2 months. This is when the land was in preparat
Read more

Top 5 Reasons Why Poultry Farming Is So Lucrative In Nigeria...See Photos

-
Image
Modern Day Poultry Farming in Nigeria Poultry Farming has become one of the most lucrative Nigerian businesses, and is arguably the big thing in Nigerian agriculture. Many big businesses, entrepreneurs, retired uncles, job seekers and Nigerians living overseas are making inroads into the sector, either to pursue their keen interest in livestock farming or to rake in big money. In the last decade Nigeria’s poultry farming industry has changed into a full-blown sustainable business sector, and contributed greatly to the nation’s economic stature. Like me, there are numerous supporters of poultry farming in Nigeria, who in some way or another, are trying to draw focus and promote this old but growing sector, and highlight its benefits. The most notable feature of poultry farming is that it ensures phenomenal returns in a blink of an eye, but it is also sensitive. With a population of about 160 million, where most citizens consume poultry products on a regular basis, Nigeria is a luc
Read more