How can I automatically fill cells in a spreadsheet?

Asked by Last Modified  

1 Answer

+1

Follow 1
Answer

Please enter your answer

Corporate Excel Trainer - 20Years

You need to use the famous Fill Handle of a cell. It is at the lower right corner of a cell. When you click on a cell you will find a lower right corner as a small dark square. Thats the Fill Handle. Hover on the Fill Handle and it will turn into Cross-Hair. Then Click on it, keep the left mouse button...
read more
You need to use the famous Fill Handle of a cell. It is at the lower right corner of a cell. Whenyou click on a cell you will find a lower right corner as a small dark square. Thats the Fill Handle. Hover on the Fill Handle and it will turn into Cross-Hair. Then Click on it, keep the left mouse button pressed and drag it to the cell range where you want to auto-fill. Depending on the type of data in the first cell, of which you are using the fill handle, range selected will get auto-filled. For example: 1. If the first cell has a number, lets say 5, then the rest of the range will be filledwith 5. 2. If you select first two cells having numbers as 1 and 2, and use the fill handle of the two cell-range, then the rest of the cells will be filled with incremental numbers, i.e. 3, 4, 5, 6, etc. 3. If your first cell is a date, the remaining cell in the range will be filled with dates with increments of a day. 4. If your first cell is an alpha numberic number, lets say Prod001, then the rest of the cells will be incremented by 1, i.e. Prod002, Prod 003, etc You can play with this option and find your way out. Now this is not all. Once you have dragged the fill handle to the desired cell range. At the end of the lower right corner of the range, you will find Auto-Fill options icon. Hover on it and click on the drop down black arrow, you will get options to change the auto-fill method. So in example 3 above, if you have auto filled dates in a range, you can click on the auto-fill icons drop down arrow to find various options to fill, e.g. by months, by weeks, by year. Try this out and you can do wonders. My online course covers this and a whole lot more about data handling, data representation and data analysis, by using real life Excel files a company uses. Contact me if interested. read less
Comments

Related Questions

What are the top excel functions management consultants use?
there are more than 600 functions inbuilt in excel, with or without a add on. most consultants turn towards kudos its much simpler and GUI friendly as they wont have time to write complicated functions....
Profile Photo
Md
0 0
View Comments6
What is the use of Format painter in MSExcel?
In Microsoft Excel, the Format Painter is a tool that allows you to quickly copy formatting from one cell or range of cells and apply it to another cell or range. It helps you maintain a consistent...
Profile Photo
Kirthi
0 0
View Comments5
Hi All, My question is how to define age calculation in excel by formula?
Enter DOB in one cell. For example in Cell A1. Then in the cell where you want to calculate Age there write as =(TODAY()-A1)/365.25 .25 has been added to the 365 because to accommodate the leap year days in between.
Profile Photo
BINAYAK
How can I create an organization chart in MS Excel?
Best option would be smart art tools for creating an organisational chart.
Profile Photo
Poojashree
0 0
View Comments5
How can I learn MS Excel from the beginning to the advanced level, online?
you can take online or home tution training. from basic excel level to advanced excel.
Profile Photo
Saisree
0 0
View Comments5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

How to work fast while working on MS Excel?
Many people struggle to find out the way on how they can work faster while working on MS Excel/Access or VBA. let me share the tip for that. If you are new or working since long time on Excel/Access...
Profile Photo

Microsoft Power BI
Microsoft Power BI is a free, self-service business intelligence cloud service that provides non-technical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's...
Profile Photo


5 Tips For Improving Your Documentation Immediately.
Tip 1) Quit it with the Passive Voice The passive voice is a plague on effective documentation. It reduces its clarity, its consistency, and the efficiency and tightness of the writing. The passive voice...
Profile Photo

HTML (Hypertext Markup Language)
HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file intended for display on a World Wide Web browser page. The markup tells the Web browser how to display a Web page's...
Profile Photo

Recommended Articles

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you