Excel Basics Archives - Page 3 of 177

How to Find a Named Range in Excel (4 Easy Ways)

Feb 9, 2023

For various Excel objectives, we occasionally change the names of cells and ranges to suit our needs. Finding and navigating to a specific named ...

How to Find a Named Range in Excel (4 Easy Ways)

[Fixed!] Excel MATCH Function Not Working

Mar 28, 2023

While working on a vast data set you sometimes get stuck with the MATCH function not working issue. So, to help you overcome this issue, we will ...

[Fixed!] Excel MATCH Function Not Working

How to Create a Weighted Sales Pipeline in Excel

Feb 2, 2023

Having a comprehensive picture of the leads and sales in a sales pipeline may undoubtedly boost conversion and sales rates. However, this may result ...

How to Create a Weighted Sales Pipeline in Excel

[Fixed] Excel Failed to Launch in Safe Mode (4 Easy Solutions)

Feb 1, 2023

When any unknown error causes the Excel file to not open, Excel safe mode can be a way to launch the file. This special mode can be run in multiple ...

[Fixed] Excel Failed to Launch in Safe Mode (4 Easy Solutions)

How to Find and Replace Text Color in Excel (3 Quick Ways)

Apr 17, 2023

Certainly, finding and replacing text color in Excel is a common task that we have to perform in order to organize, highlight and present data in a ...

How to Find and Replace Text Color in Excel (3 Quick Ways)

Excel Conditional Formatting for Odd and Even Numbers and Rows

Mar 12, 2023

While working with large data sets in Microsoft Excel, you may need to highlight odd and even numbers from the worksheet because of the convenience ...

Excel Conditional Formatting for Odd and Even Numbers and Rows

How to Customize Ribbon in Excel (2 Easy Ways)

May 17, 2023

In this article, you are going to learn about how to customize ribbon in Excel. In general, the ribbon is the strip of buttons and icons at the top ...

How to Customize Ribbon in Excel (2 Easy Ways)

How to Reduce Excel File Size by Deleting Blank Rows

Jan 29, 2023

In this article, we will demonstrate how to reduce Excel file size by deleting blank rows. Often a file in Excel becomes very large and takes a huge ...

How to Merge and Center Selected Cells in Excel (4 Ways)

Feb 2, 2023

You may need to use the same values in some cells. In that case, you don’t need to insert the same cell value repeatedly, simply you can merge and ...

How to Merge and Center Selected Cells in Excel (4 Ways)

How to Fix When Excel Not Responding Without Losing Data

Mar 22, 2023

Has your Microsoft Excel file suddenly ceased to function and begun to display the Excel Not Responding error message? Further, while attempting to ...

How to Fix When Excel Not Responding Without Losing Data

How to Ignore Blank Cells in Excel Sum (6 Ways)

Apr 12, 2023

This article will show you how you can ignore blank cells in Excel sum. In the spreadsheet, sometimes we have to sum a data range that has blank ...

How to Ignore Blank Cells in Excel Sum (6 Ways)

[Fixed] Excel Ribbon Keeps Disappearing (5 Easy Solutions)

May 10, 2023

Excel ribbon is like a navigation tool for the whole Excel workbook. One can access and use excel features using the ribbon tabs. So, it is mandatory ...

[Fixed] Excel Ribbon Keeps Disappearing (5 Easy Solutions)

How to Use Custom Autofilter in Excel for More Than 2 Criteria

May 18, 2023

Excel spreadsheet can be used for custom autofilter for more than 2 criteria. This filter option is particularly useful for sorting a dataset. In ...

How to Use Custom Autofilter in Excel for More Than 2 Criteria

How to Merge Vertical Cells in Excel (6 Easy Ways)

Feb 2, 2023

The Merging operation helps us combine more than one cell in Excel. Often, we find a data sheet that contains a lot of columns and rows, and this is ...

How to Merge Vertical Cells in Excel (6 Easy Ways)

How to Link Textbox to Multiple Cells in Excel (4 Easy Ways)

May 10, 2023

A textbox is a portable tool that is used to cover important text or information in Excel. You can drag the text box anywhere in the sheet. Also, it ...