How to Use a Percentage Formula in Excel
To calculate a percentage in Excel, divide the part by the whole and format the result as a percentage. For example, type =42/50 in a …
Microsoft Excel 2013
How-to guides and tutorials about topics related to the Microsoft Excel 2013 application and ways that you can edit spreadsheets.
How to Combine Columns Into One in Excel
To combine three columns into one in Excel, click an empty cell and type =A2&” “&B2&” “&C2, then press Enter. This joins the three cells …
How to AutoFit Columns and Rows or Expand Row Groups in Excel
The quickest way to AutoFit a column in Excel is to double-click the right edge of its column header. To AutoFit from the keyboard, select …
How to Make a Christmas List Spreadsheet in Excel
To make a Christmas list in Excel, open a blank workbook, type headings such as Name, Gift Idea, Price and Bought in row 1, add …
How to Print Gridlines in Excel 2013 and Later
To print gridlines in Excel, click the Page Layout tab, check the Print box under Gridlines in the Sheet Options group, and then print with …
How to Insert an Arrow in Excel for Microsoft 365
To insert an arrow in Excel, go to the Insert tab, select Shapes, and choose the Line Arrow under Lines. Then click and drag on …
How to Calculate Age and Date Differences in Excel
To calculate age from a birthdate in Excel, put the birthdate in cell A2 and type =DATEDIF(A2,TODAY(),”Y”) in another cell. Excel shows the person’s age …
How to Change Excel Column Labels From Numbers Back to Letters (Excel 2013 and Later)
If your Excel columns are labeled 1, 2, 3 instead of A, B, C, the R1C1 reference style option is turned on. To switch back …
How to Return Excel Worksheets to Normal View
To return a worksheet to Normal view in Excel, click the View tab and click Normal in the Workbook Views group, or click the Normal …
How to Keep a Trailing Zero in the Second Decimal Place in Excel
Excel drops a zero at the end of a decimal, like showing 2.5 instead of 2.50, because cells use the General number format by default. …
How to Put a Bulleted or Numbered List in an Excel Cell
To put a bullet in an Excel cell, select the cell and go to Insert > Symbol, type 2022 in the Character code box, and …
How to Put Excel Column A on the Right Side
To put column A on the right side in Excel, switch the sheet to right-to-left. In Excel for Windows, go to File > Options > …
How to Fix a Slow Cursor in Excel
If the cursor feels slow or laggy in Excel, turn off animations. In Excel, go to File > Options > Ease of Access and uncheck …
How to Delete Data But Keep Formatting in Excel
To delete data while keeping cell formatting in Excel, select the cells and choose Home > Clear > Clear Contents. In Excel for Windows, you …
How to Combine First and Last Names in Excel
To combine first and last names in Excel, type =A2&” “&B2 in an empty cell, where A2 has the first name and B2 has the …