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, type =A2&” “&B2&” “&C2, and press Enter. Excel joins the three cells with …
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; for a row, double-click the bottom …
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, Bought and Wrapped in row 1, …
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 Line Arrow under Lines. Then click and drag on the …
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
To keep a trailing zero in Excel, so 2.50 doesn’t turn into 2.5, select the cells and click Increase Decimal on the Home tab until …
How to Put a Bulleted or Numbered List in an Excel Cell
To put a bulleted list in one Excel cell, double-click the cell, press Alt+7 on the number pad (or use Insert > Symbol with character …
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 cell cursor feels slow or laggy in Excel, turn off Excel’s animations: click File > Options > Accessibility and clear Provide feedback with …
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 …