Find and Replace Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/find-and-replace/ Bestselling Excel and Power BI Courses Fri, 24 Mar 2023 06:15:50 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Find and Replace Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/find-and-replace/ 32 32 How to Lock Cells & Protect Worksheets in Excel (Leave Some Cells Open if You Need to) https://www.xelplus.com/excel-unlock-lock-cells-also-by-color/ Thu, 04 Jul 2019 09:00:00 +0000 https://www.xelplus.com/?p=12300 It's easy to lock and unlock individual cells in Excel. You can protect specific worksheets but leave some cells unlocked. You can even leave cells unlocked based on their color!

The post How to Lock Cells & Protect Worksheets in Excel (Leave Some Cells Open if You Need to) appeared first on Xelplus - Leila Gharani.

]]> How to Convert Numbers to Words in Excel https://www.xelplus.com/excel-formula-convert-numbers-to-words/ Thu, 16 May 2019 02:45:00 +0000 https://www.xelplus.com/?p=12345 Use this Excel formula (NO VBA, NO Macros) to convert numbers to words. Download the workbook and copy and paste to your own files. I show you how easily you can adjust the formula to fit your needs.

The post How to Convert Numbers to Words in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Hack to Change Horizontal Data to Vertical https://www.xelplus.com/excel-horizontal-data-to-vertical/ Sat, 11 May 2019 20:40:00 +0000 https://www.xelplus.com/?p=12358 Here's an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it's dynamic so if you add more values to the horizontal data it will reflect in the vertical one.

The post Excel Hack to Change Horizontal Data to Vertical appeared first on Xelplus - Leila Gharani.

]]> Excel’s Find and Replace (surprising features) https://www.xelplus.com/excel-find-and-replace/ Fri, 08 Feb 2019 23:46:00 +0000 https://www.xelplus.com/?p=12888 Excel's Find and Replace can do much more than meets the eye. You can Find a specific formatting and replace it with another format. You can also highlight all the results found in the cells. This tutorial will uncover some surprising features of Excel's Find and Replace feature.

The post Excel’s Find and Replace (surprising features) appeared first on Xelplus - Leila Gharani.

]]> Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> 3 Ways to Transpose Excel Data https://www.xelplus.com/transpose-excel-data/ Fri, 09 Nov 2018 12:02:00 +0000 https://www.xelplus.com/?p=9884 2 of the methods shown to transpose data in Excel are dynamic. Number 3 will surprise you. It will show you a simple way to switch your data from rows to columns or vice versa.

The post 3 Ways to Transpose Excel Data appeared first on Xelplus - Leila Gharani.

]]> Copy Excel Formulas Without Changing Cell References https://www.xelplus.com/copy-excel-formulas-without-changing-cell-references/ Mon, 26 Feb 2018 19:31:00 +0000 https://www.xelplus.com/?p=11059 Would you like to copy your Excel formulas from one place to another without the cell references changing? In this step by step tutorial I show you a very simple trick that does that.

The post Copy Excel Formulas Without Changing Cell References appeared first on Xelplus - Leila Gharani.

]]>