Excel Basics Archives - Page 16 of 124

How to Change Font in Excel to All Caps (8 Simple Ways)

Jul 6, 2024

The following dataset shows company department purchases. We will change the name font to all caps for the person related to the purchase. ...

How to Change Font in Excel to All Caps (8 Simple Ways)

How to Make a Checklist in Excel – 5 Steps

Aug 9, 2024

This is the sample dataset: Step 1 - Enable the Developer Tab Click Customize Quick Access Toolbar above the Home tab. ...

How to Make a Checklist in Excel – 5 Steps

How to Change Font Style in Excel (5 Easy Ways)

Aug 4, 2024

In this Excel tutorial, we will describe how to change font style. Changing font style in Excel is a process that enhances the visual appeal of the ...

How to Change Font Style in Excel (5 Easy Ways)

How to Increase Font Size for Printing in Excel (2 Suitable Ways)

Jul 6, 2024

Method 1 - Apply Scaling Option to Increase Font Size for Printing in Excel STEPS: Click on File. Select Print. The Print ...

How to Increase Font Size for Printing in Excel (2 Suitable Ways)

How to Apply Abbreviation Using Formula in Excel

Jul 11, 2024

We will use the following sample data set to apply abbreviations. Method 1 - Combine TEXTJOIN, ISNUMBER, MATCH, CODE, MID, ROW, INDIRECT, ...

How to Apply Abbreviation Using Formula in Excel

How to Delete Every Other Column in Excel: 5 Easy Ways

Jul 7, 2024

Method 1 - Use Custom Sort Feature to Delete Every Other Column Steps: Add row 3 over the header row. Input the following formula in cell ...

How to Delete Every Other Column in Excel: 5 Easy Ways

How to Delete Hidden Columns in Excel (2 Simple Methods)

Aug 2, 2024

Method 1 - Using the Inspect Document Feature in Excel to Delete Hidden Columns STEPS: Select column D. Right-click and choose Hide. ...

How to Delete Hidden Columns in Excel (2 Simple Methods)

How to Delete All Rows Not Containing Certain Text in Excel?

Jul 4, 2024

In the following dataset containing information about some fruits, Apple is listed multiple times. Let's delete all the rows except those containing ...

How to Delete All Rows Not Containing Certain Text in Excel?

How to Create a Table from Another Table in Excel (3 Easy Ways)

Jun 14, 2024

Method 1 - Merging Multiple Columns to Create Table from Another Table in Excel Steps: We use the table below for this example: Select ...

How to Create a Table from Another Table in Excel (3 Easy Ways)

How to Randomize a List Without Duplicates in Excel – 4 Methods

Aug 3, 2024

The dataset showcases a List of Stock Prices. Method 1 - Using the INDEX, SORTBY, and SEQUENCE Functions Steps: Select B16 ...

How to Randomize a List Without Duplicates in Excel – 4 Methods

[Fixed!] Excel Default Font Is Not Changing (4 Quick Solutions)

Jul 9, 2024

We'll use the following simple dataset of 10 employees. The font is the default Calibri, and we want to change it to Arial. Solution 1 - ...

[Fixed!] Excel Default Font Is Not Changing (4 Quick Solutions)

How to Select Specific Columns in Excel – 4 Easy Methods

Aug 7, 2024

The dataset showcases Product, Quantity, Unit Price, and Total Price. Method 1 - Using a Keyboard Shortcut to Select Specific Columns ...

How to Select Specific Columns in Excel – 4 Easy Methods

How to Change Decimal Places in Excel Graph: 3 Methods

Jul 5, 2024

Method 1 - Utilize Data Labels of Excel Graph to Convert Decimal Places STEPS: Insert the graph. For this, select the data. Go to the Insert ...

How to Change Decimal Places in Excel Graph: 3 Methods

[Fixed!] Excel Superscript Not Working (6 Ideal Solutions)

Aug 6, 2024

There are various reasons why superscript formatting may not be working as expected in Excel. In this tutorial, we will discuss these reasons and ...

[Fixed!] Excel Superscript Not Working (6 Ideal Solutions)

How to Increase the Font Size Using the Keyboard in Excel – 3 Methods

Jul 8, 2024

This is the sample dataset. Method 1 - Using the Format Cells Feature Steps: Select the cell and highlight the text you ...