Excel Basics

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

When you change fonts to all caps in Excel, you convert the selected letters to uppercase. This formatting technique turns lowercase letters into ...

How to Make a Checklist in Excel (with Easy Steps)

Checklists are essential for an individual to keep track of tasks already completed and tasks that need to be done yet. Excel can help in creating a ...

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

Changing font style in Excel is a process that enhances the visual appeal of the data. It includes changing the font name, size, and color as well as ...

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

Suppose we have a dataset and we want to print it. But we may wish for the printed sheet to look clearer. Increasing font size helps us to read the ...

How to Apply Abbreviation Using Formula in Excel

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single ...

How to Delete Every Other Column in Excel (5 Easy Ways)

Microsoft Excel is a very useful software. We use Excel functions and features for our educational, business, and other daily life purposes. ...

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

Microsoft Excel is undoubtedly one of the most essential and potent computer programs currently available. Using Excel's capabilities and resources, ...

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

Often, we need to delete all rows that don’t contain specific text in Microsoft Excel. However, it’s easier to clear the cell contents all at once ...

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

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 Randomize a List in Excel Without Duplicates (4 Ways)

Certainly, Microsoft Excel excels at arranging and manipulating data. Now, it is a well-known fact that Excel has numerous dedicated functions to ...

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

Microsoft Excel has a default font style and a vast number of different font styles to show the spreadsheet more beautifully to the user. However, ...

How to Select Specific Columns in Excel (4 Easy Methods)

While working in Microsoft Excel sometimes we need to select specific adjacent or non-adjacent columns to rearrange them. It might seem difficult to ...

How to Change Decimal Places in Excel Graph (3 Approaches)

While working with Excel, we deal with things like money, weight, and length and therefore we employ decimals. While dealing with those we may want ...

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

Sometimes you may set a character as superscript in Excel, maybe want them to appear slightly above the normal line of text. But when you see them in ...

How to Increase Font Size Using Keyboard in Excel (3 Easy Ways)

Using keyboards while working in Excel can increase efficiency and speed. It often saves time and reduces boredom. Changing the font size every time ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo