Excel tip to Quickly Fill Series of Numbers in a Few Seconds Fill Command

Microsoft excel is the powerful spreadsheet program and a great data visualization and analysis tool that is used often in all business level to collect , analyze , sort and manage data and keep it as a record or also to collect data implicitly.

Uses of excel can be listed as :

Data entry.
Data management.
Accounting.
Financial analysis.
Charting and graphing.
Programming.
Time management.
Task management.

besides these there are also some other applicable field of spreadsheet which can be explained in detail. Among all lets learn about how to quickly fill series of numbers in a few second in EXCEL SHEET.
firstly open the excel sheet and then just type number as 1 , 2 in the first column of the sheet and then select those two cell by clicking shift on the keyboard and after this you will see a plus like symbol at the left bottom of selected cell (when hovered on that small square like box below 2) as shown below in the image like :

and now simply drag the plus arrow and go upto what number you want to go.you will get all the desired number on the first column .
similarly do this for other column from anywhere you like to start.
second option
Now there is also another easy way for doing this for which the step you need to follow are mentioned below.

go to the first row/column of the cell and just type 1 (or any number you would like to get started with) .
go to home menu and then select the fill option from editing section.
go to series option in fill menu. Select linear in type
then just select the column in the dialog box appearing and then put start to stop value in the box as below.

5.click on ok button and then you will see the result.

Comments

About ADBL

Agriculture development bank limited was established in 1968 (2024 BS) under the act 1967 .it is a commercial bank of Nepal generally engaged in the promotion of rural area and farmers helping the government of Nepal to accomplish the task of making NEPAL a "Prosperous Nepal , Happy Nepal " by providing best quality service through its widespread network .it has 51% share of government and 49% share of general people and it has been listed in share market and SEBON with its worth of about 550 in an average and is providing good dividend to its share holders too. Most of its share holder are customers and employees. Having Glorious history of about 54 years with about 1.2 million happily satisfied customers , bank has celebrated its 54th anniversary making it as a leader in the agricultural sector of NEPAL with its customers , different services and products.it has done its investment in agriculture , industry , trade , commerce and households . just l...

establishing goals.

finding out your specific goals and objectives like knowing where you want to go and making key result about them and knowing or marking your progress is a key term for this. like if we want to see books online . this will be our objectives and that will give key result like selling of 100 books per day .this whole process will target our motive and helps in achieving it.there are many way of setting goals but what matters is to go with it productively.

Fundamental Analysis in summary

Fundamental analysis is a method of examining economical and financial status of any company or organization so that it can be helpful in decision making whether to buy or not the share of the company. it will help you to remove all the dilemma that you are having when you have to buy share of any company. EPS = Earning per share meaning it is the monetary value of earning per share of common stock of a company .the better it is , the good it is so the company having good EPS is considered better for investment in share market. BOOK value = net worth share =(ASSET - LIABILITIES )/TOTAL SHARE OF COMPANY book value can indicate whether a stock is under- or overpriced. When a company sells stock, the selling price minus the book value is the capital gain or loss from the investment.you will get amount as equal to book value of a company whether or not the company get profit and loss. Price to book value (PBV)Ration = it must be below 3 to consider comp...

TECH INFO

Search This Blog