Basic Shortcuts In Excel



Excel Shortcuts: Here are some excel shortcut I used for my everyday works.

1.Ctrl+PageUp/PageDown: To move through various pages within the excel sheet.

2.Ctrl+(Plus): To Insert new line(row/column) in excel sheet.(select the entire row/column if you want to insert a new row or column)

3.Ctrl+(Minus): To delete lines(row/column) in excel sheet.(first, select the row/column)

4.Ctrl+(arrows): To move to the last cell value(left/right/up/down)

5.Shift+(F11): To add a new sheet/tabs in excel

6.Ctrl+Shift+(L): To put the filter in the excel sheet (same shortcut press again to remove the filter)

7.Alt+ (Equal to”=”): To get the total of a column(If the filter is there it will calculate “Subtotal” or else “Sum”)

8.Alt + AEF: To convert Text numbers into number

9.Alt+HOI: To Auto fit the column width in the excel sheet.

10.Alt+ NVT- To create Pivot in the excel ( It will ask for the table range for the Pivot)

11.Alt+ JTID- To find the source table of the pivot (It will take you to the source table of the Pivot, You can also change the range here)

12.Shift+(Space bar): To select the entire row.

13.Ctrl+ (Space bar): To select the entire column.

14. Ctrl+9: To Hide Rows in excel sheet

15. Ctrl+0: To Hide a column in the excel sheet.

16.Alt OCU: To unhide row/column in the excel sheet.

Hope some of these shortcut will be helpful for you.




Comments

Post a Comment

Popular posts from this blog

Most Commonly Used Excel Functions

Image
Here, I have mentioned some of the Excel functions which are commonly used in the organizations and in our day to day work. 1.SUM:  To get the total of a group of cells. 2. SUM IF:  To get the totals with some criteria or condition (Ex- from a given list of products and their sales volume you want the total of one specific product) 3.SUM IFS:  To get the totals with more than one criteria. (Ex-In the previous example let add one more criterion, we want to check the sales of a particular product in particular month.) 4. SUM PRODUCT:  To get the sum by multiplying two or more sets of arrays.       5. IF ERROR:  To show the alternate results in case of formula error. Generally clubbed with some other formula to show the alternate results. 6. V lookup:  To find the data in the large datasheet by using one unique field. This is the most commonly used excel function. (Ex-Su...
Read more

FINANCIAL PLANNING & ANALYSIS Part - 1

Image
Financial Planning and Analysis is carried out to ascertain the financial strength and weakness of an enterprise. The main tools are Ratio Analysis and Cash flow and Funds Flow analysis. Ratio Analysis: Ratio Analysis is the comparison of different numbers from the balance sheet, Income Statement and Cash Flow statement against the figures of previous years, other companies, the industry or even the economy in general for the purpose of financial analysis. Ratio Analysis can be classified into four broad categories Liquidity Ratio: It derives the liquidity or short term solvency means ability of the business to pay its short term liabilities. Leverage Ratio: This is also known as Capital Structure. This may be defined as the ratio which measures the long term stability and structure of the firm. This can be further derived in two parts known as: (I)             Capital Structure Ratios (II)  ...
Read more

IND AS 41 : AGRICULTURE

Image
Accounting treatment for Biological assets are given in the Ind As -41. Previously There are no standards are given for the agricultural sectors in India therefore Ind As 41 is derived for proper treatment of the biological Assets and transactions related to the sectors. First lets understand, what is biological Assets? ·       Living Plant & living Animals are called as biological Assets. Types of biological Assets: Bearer Plants: Bearer produces for more than one year. For eg. All fruits Bearing Plants. It is derived in Ind As 16- PPE as self-constructed Assets Consumable Plants: Directly usable in ply or lumber (Furniture and Fittings). Consumable Plant and consumable Animals are derived in this standard which Ind As 41. Agriculture: Management of biological transformation of biological assets. Transformation in the form of Quality and Quantity. Quality: Change in Nutrients level Quantity: Change in Weight and Structure...
Read more