Learn Microsoft Excel Training from the Best Tutors

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

Search in

# How to write square in excel?

Professional Tutor with 15 years of experience.

Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript

Advanced Excel, VBA Automations, Reporting Insight

Hi Dharmendra, Your question is not very clear...let us know if this suffice your query. #To get square of any number, type the formula "=(Number)^2" #To get square root of any number, type the formula "=SQRT(Number)"

MS Excel Professional Teacher, Accounts & Costing Tuition.

Hold down ALT key and press 0178 in numberpad, then release ALT key Alt-0178 = ² Alt-0179 = ³ Alt=0190 = ¾ This work in all Excel. TRY IT NOW

Software Professional Trainer with 26+ years of Experience in Software Design and Development

Use Superscipt optiion to write square in excel. Click small arrow icon below in the font group and check superscipt option in the checkbox

1.Please goto Home tab in excel window 2. select launcher mark at right bottom of the font group 3. Format cells dialog box will come 4. Select font tab 5. check superscript option the press ok

If you want to type 5 Square ( 5^2) in a cell. Type '52 in the cell -> Select the letter 2 alone -> Format -> Cells -> Fonts -> click on the check box Superscript.

HR/Payroll Trainer

Write the base word (Ex- Metric) go in to format cell tick on superscript - ok- and write 2.

Expert In Microsoft Office

Hi Sir, Please use ^ symbol to square any number (Eg. =5^2; which means 5 * 5). Hope this answer your question. Let me know if you have any query. Thanks,

Computer Teacher

Use following formula in cell. = num1 ^ num2

Related Questions

Is there any free software to convert a word file to PDF?
When you go to print comment in place of Printer, you will get print to PDF or Microsoft print to PDF. IF you click on this, the word document gets converted in PDF.Also, you can go to File and Save and...
Gaurang
How can we convert date into days for any year?
Enter the DATE Select the cell with the returned date. Click the Home tab. Click Format Cells: Number in the Number group.
Sensoph
Can you help with this Excel formula?
Sajjan

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.
BINAYAK
can i teach
Yes you can teach, if you are interested in Teaching and willing to share your Knowledge and Expertise to others.
Abdul

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

Related Lessons

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

Cell Properties
G

Gagan G.

In this video, learn about Advanced Excel: - Data Input and Hidden Features, - Worksheet Navigation, - Excel Formulas & Functions, - Data Cleaning and Formatting. VBA and its useful Built-in Functions,...

Dynamic HyerText Markup Language (DHTML)
Dynamic HyerText Markup Language (DHTML) is a combination of Web development technologies used to create dynamically changing websites. Web pages may include animation, dynamic menus and text effects....

AND Function In Excel
Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE. Eg. =AND(A2>1, A2<100) which means answer displays TRUE if A2 is greater than 1 AND less than...

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

### 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