true

Learn Microsoft Excel Training from the Best Tutors

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

Search in

Did you know about Shortcuts of Excel

24/07/2018 0 0

Ctrl+Shift+F3	Create name by using names of row and column labels	Insert, Name, Create
Ctrl+Shift+F6	Previous Window	Window, ...
Ctrl+Shift+F12	Print	File, Print
Alt+Shift+F1	New worksheet	Insert, Worksheet
Alt+Shift+F2	Save	File, Save
Alt+=	AutoSum	No direct equivalent
Ctrl+`	Toggle Value/Formula display	Tools, Options, View, Formulas
Ctrl+Shift+A	Insert argument names into formula	No direct equivalent
Alt+Down arrow	Display AutoComplete list	None
Alt+’	Format Style dialogue box	Format, Style
Ctrl+Shift+~	General format	Format, Cells, Number, Category, General
Ctrl+Shift+!	Comma format	Format, Cells, Number, Category, Number
Ctrl+Shift+@	Time format	Format, Cells, Number, Category, Time
Ctrl+Shift+#	Date format	Format, Cells, Number, Category, Date
Ctrl+Shift+$	Currency format	Format, Cells, Number, Category, Currency
Ctrl+Shift+%	Percent format	Format, Cells, Number, Category, Percentage
Ctrl+Shift+^	Exponential format	Format, Cells, Number, Category,
Ctrl+Shift+&	Place outline border around selected cells	Format, Cells, Border

0 Like 0 Dislike

Follow 2

Other Lessons for You

Hidden Gems Of MS Excel - Track All Comments At Once OR Delete All Comments At Once

*this Article is about Comments in MS Excel, NOT NotesClick here to Learn difference between Comments and Notes You have added many Comments on a Worksheet.Now, You are unable to track All Comments....

Ankur Sharma

2 0

Datedif() Function

Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

Saburudeen MA

0 0

Tips - How to put PivotTable Field List back at its Original Position?

Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...

Ankur Sharma

2 0

TODAY WE LEARN MIN FORMULA, HOW TO USE IT.

1 A B 2 NAME MARKS 3 Vinita 50 4 Anjali 34 5 Mahima 73 6 Kartrina 18 7 Mahender 65 8 Silver 48 =min(B3:B8) ANSWER 18 =MIN(number 1, {number 2},...)

Saurabh Sharma

0 0

Hidden Gems of MS Excel - Reapply Filter

Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur Sharma

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

can i teach

35 Answers

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything...

11 Answers

Can a person learn advanced level MS Excel through YouTube videos?

7 Answers

Dear sir,how to convert number to text in excel by formula?

8 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

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

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel 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.