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

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

VBA Function - RIGHT

RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Karthik Dale

0 0

Practical use of Two way Look-up (Category: Advanced Excel)

///////////////////////////////////////////////////////////////

Rakesh Pradhan

0 1

Top 30 formulas in Excel

Generally, we are only use maximum "30 formulas" in our day to day routine. let's explore with below formulas and let me know which one is your favorite. Vlookup If Iferror Sum Count Sumif Countif CountA Index Match Left Right Mid Tri...

Vikas Chauhan

0 0

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data

Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Ankur Sharma

3 1

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 a person learn advanced level MS Excel through YouTube videos?

7 Answers

What is shortcut to rename the spreadsheet name?

34 Answers

Excel formulas in advance level?

39 Answers

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

8 Answers

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

11 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.