How to Save an Excel Table as Image?
While Excel is the primary choice when it comes to analyzing data, a lot of reporting is still done with other tools such as Microsoft PowerPoint or Word. This also …
Steve Scott
How to Remove Panes in Excel Worksheet (Shortcut)
Excel has a feature where it allows you to divide a worksheet into two or four panes. This helps as you can treat each of these panes separately and can …
Excel Logical Test Using Multiple If Statements in Excel [AND/OR]
![Excel Logical Test Using Multiple If Statements in Excel [AND/OR]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/Excel-Logical-Test-Using-Multiple-If-Statements-in-Excel-ANDOR.png)
To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate conditions that will show two outcomes. This Excel IF statement …
How To Set Column Width in Inches (or Centimeters) in Excel?
I was recently asked if there is a way to set column width in inches in Excel. This was for a template this person was creating where they wanted the …
How to Find Duplicates in Excel (Conditional Formatting/ Count If/ Filter)
When you are working on a large number of data then you will encounter a few duplicate entries. Sometimes these duplicate values are very useful but many times you want …
How to Lock Cells in Excel [Mac, Windows]
![How to Lock Cells in Excel [Mac, Windows]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-Lock-Cells-in-Excel-Mac-Windows.png)
If you are protecting a worksheet, then that means you are locking all the cells. You cannot perform any editing on those cells. To perform the editing of the cells, …
How to Open Excel File [xls, xlsx] Online (for FREE)
![How to Open Excel File [xls, xlsx] Online (for FREE)](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-Open-Excel-File-xls-xlsx-Online-for-FREE.png)
When you open an Excel file online, you will find a new workbook automatically displayed. The workbook contains various worksheets that hold actual data and information. Initially, the workbook opens …
How to Fill Blank Cells with Value above in Excel?
Sometimes, you may have a dataset where there are empty/blank cells in a dataset that should have been filled with the same value. Below is a common example where the …
10 Best Excel Books (that will make you an Excel Pro)
When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, books can do a much better job …
How to Compare Two Columns in Excel (using VLOOKUP & IF)
When you’re working with data in Excel, sooner or later you will have to compare data. This could be comparing two columns or even data in different sheets/workbooks. In this …
How to Remove Formulas in Excel (and keep the data)
Watch Video – How to Remove Formulas in Excel Sometimes you may want to remove formulas from the worksheets but keep the data. It is also recommended to remove formulas …
Multiple If Statements in Excel (Nested IFs, AND/OR) with Examples
We use the IF statement in Excel to test one condition and return one value if the condition is met and another if the condition is not met. However, we …