true

Learn MS Office Software Training from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Shortcut for adding big data or Columns in MS excel

Kimsi J.

19/07/2019 0 0 View Comments

1. Simply click on the next cell of column where you want the sum.

2. Press Alt and = keys together.

3. It will show the sum and range of sum.

4 Click Enter key and you will get sum of the column.

0 Like 0 Dislike

Follow 2

Saurabh Sharma | 12/09/2019

In advanced excel there are two way to get an answer first answer mam told us and know where you got the answer use the =sum() and select your range after that you will get your answers, both tricks give you the same answer

0 0

Other Lessons for You

Shortcuts in MS Excel-1 !!!

Shortcuts Keys in MS-Excel : Ctrl-C : Copy Ctrl V : Paste Ctrl X : Cut Ctrl F : Search Ctrl B : Bold Ctrl I : Italic Ctrl U : Underline Ctrl 5 : Strikethrough Ctrl A : Select All Ctrl Z : Undo Ctrl...

Arungeetha A.

0 0

How to add bullets Point in MS-EXCEL

There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3....

Pradeep Agrawal

0 0

Simple Charts In Excel

i. Charts: A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude,...

Itech Analytic Solutions

0 0

Common MS Excel Shortcuts to make life easier!

Hi All,I am new to UrbanPro with a passion for learning and teaching analytical tools, MS Excel being the one of them. Excel is one of those master tools which seems untapped to its fullest potential;...

Shruti S.

0 0

What Are Macros?

i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost...

Itech Analytic Solutions

0 0

Find MS Office Software Training near you

Looking for MS Office Software Training ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

MS Office Software Training Questions

How many columns can be created in MS Excel?

5 Answers

What are the top excel functions management consultants use?

6 Answers

How can I create a letter head on excel?

21 Answers

What is VBA and what is its importance?

5 Answers

How do I delete a worksheet in MS Excel?

14 Answers

Looking for MS Office Software Training Classes?

The best tutors for MS Office Software Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

Learn MS Office Software Training with the Best Tutors

The best Tutors for MS Office Software Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.