How-To
8 Best Ways to Fix “Microsoft Excel Cannot Access the File” Error
If you receive the message “Microsoft Excel cannot access the file”, it means something has gone wrong with the file...
Microsoft Excel
How-To
Microsoft Excel “Sharing Violation” Error: Causes and How to Fix
Getting a “Sharing Violation” error while trying to save a Microsoft Excel spreadsheet on your computer? You may not have...
How-To
How To Insert Columns and Rows in Microsoft Excel (Mobile, Desktop, and Web)
It’s easy to add new columns and rows to an Excel spreadsheet. In this article, we’ll show you how to...
How-To
Microsoft Excel Formulas Not Working or Calculating? Try These 7 Fixes
Microsoft Excel is an incredibly powerful tool that can handle complex calculations with ease, but not when your Excel formulas...
How-To
How to Fix Microsoft Excel “Document Not Saved” Error
Microsoft Excel is an indispensable tool—if it’s working properly. If you encounter the document not saved error in Excel, you’re...
How-To
Why Microsoft Excel Keeps Crashing on Your Computer (And 14 Fixes to Try)
Microsoft Excel, part of the Microsoft Office suite, is an essential tool for many professionals. Unfortunately, Excel crashes can cause...
How-To
How to Autofill in Microsoft Excel
Autofill in Microsoft Excel is a wonderful tool that takes much of the work out of data entry. By using...
How-To
Function Syntax in Excel: All You Need to Know
Understanding how to construct formulas is a fundamental step in learning to use Excel. Here is a primer on the...
How-To
How to Get Rid of Dotted Lines in Microsoft Excel
Microsoft Excel is one of the best tools available for data collection, analysis, and visualization. However, because of its powerful...
How-To
What Is a “Value” in Microsoft Excel?
Value is a confusing term in Microsoft Excel. From actual values of data cells to a function and even an...
How-To
How to Make a Family Tree in Microsoft Excel
Microsoft Excel is one of the most versatile data visualization tools available today. It can be used to create easy-to-understand...
How-To
Can’t Break Links in Microsoft Excel? Try These 6 Fixes
If you’re working in Excel, you might have encountered a situation where you can’t break links to external references. This...
How-To
How to Unprotect an Excel Worksheet or Workbook (With or Without Password)
Do you want to make changes to your Excel workbook or worksheet, but find that they’re locked or protected? If...
How-To
How to Stop Microsoft Excel Toolbar From Disappearing
You’re working hard on a spreadsheet and suddenly, the Microsoft Excel ribbon vanishes. Where did it go? How do you...
How-To
How to Compare Two Columns in Microsoft Excel
When you want to compare values in different columns in Microsoft Excel, you can use more than just your eyeballs....
How-To
How to Break Links in Microsoft Excel
Microsoft Excel is a powerful tool, but keeping your Excel files tidy and functional is often difficult. Hyperlinks can be...
How-To
How to Make an Organizational Chart in Word, Excel, and PowerPoint
Graphs and charts are wonderful visuals that let you see information clearly. If you need to show the reporting structure...
How-To
How to Make a Copy of an Excel Worksheet or Workbook
If you make major changes to your Microsoft Excel workbooks or worksheets, it’s a good idea to make a copy...
How-To
How to Create a Combo Chart in Microsoft Excel
When you want to display different data sets visually, you can create a combination chart. If you want to show...
How-To
How to Convert a Word Document to an Excel Spreadsheet
If you’re working with numbers in Word but prefer to switch to Excel, you can do just that. There are...
How-To
How to Highlight Cells and Text in Microsoft Excel
By using a bit of color in your spreadsheet, you can make a cell or its contents pop. This makes...
How-To
How to Undo, Redo, and Repeat Actions in Excel
With the number of actions you are likely to perform in your Excel spreadsheets, you’re bound to make mistakes or...
How-To
4 Ways to Unmerge Cells in Microsoft Excel
Merging cells in Microsoft Excel is an excellent way to organize data spread across columns or rows. If you decide...
How-To
How to Calculate Annual Percentage Rate (APR) In Microsoft Excel
If you’re comparing loan offers or working out how much you’ll need to pay on your loan each year (and...
How-To
How to Make a Schedule in Microsoft Excel
You can find plenty of digital schedule apps, but if you want one you can share with others, print and...
