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

Slicer in Excel

Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...

Rakesh R

2 0

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

Advanced Excel - Excel What-If Analysis Goal Seek !

Amey Vidvans

0 0

For the Best Training You Need the Best Trainer

Microsoft Excel Beginner, Intermediate and Advanced course will provide a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level to learners. Microsoft...

Prasad

0 0

Today am teach You advanced excel formula like TEXT FUNCTION

IN THIS SCENARIO, WE WILL HELP OF TEXT FUNCTION WE FIND OUT DATE, MONTH, YEAR A B C D E F 1 2 =TEXT(B3,"DDD") =TEXT(B3,"MMM") =TEXT(B3,"YYY") 3 ...

Saurabh 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

What is shortcut to rename the spreadsheet name?

34 Answers

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

9 Answers

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff

7 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

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.