

Category Archives for "Excel Tips"

4 How to Split Multiple Lines in a Cell into a Separate Cells / Columns

Split Multiple Lines in a Cell into a Separate Cells or Columns - Result needed

In Excel, you can use the Text to Columns functionality to split the content of a cell into multiple cells. You can specify the delimiter (such as a space, comma, or tab) and the Text to Columns would use this delimiter to split the content of the cells. Examples of this include splitting first and […]

1 How to Sort Data in Excel using VBA (A Step-by-Step Guide)

Excel already has a couple of ways to sort data quickly. You can easily sort a data set by using the sort icons in the ribbon or the sort dialog box. Then why do you need to know how to do this using VBA? Knowing how to sort data using VBA can be helpful when […]

1 How to Hide a Worksheet in Excel (that can not be unhidden)

xlSheetVeryHidden selected to hide the worksheet in Excel

Hiding and Unhiding worksheets in Excel is a straightforward task. You can hide a worksheet and the user would not see it when he/she opens the workbook. However, they can easily unhide the worksheet if they want (as we will see later in this tutorial). But what if you don’t want them to be able […]

0 Excel AutoFormat – A One Click Data Formatting Trick

Do you spend a lot of time formatting data in Excel? If yes, then you may find the AutoFormat option useful in speeding up your formatting work. It allows you to quickly apply a preset formatting on a data set that has one header row and one header column. It allows you to quickly apply […]

0 Test Multiple Conditions Using Excel IFS Function

Excel 2016 came with a new function – the IFS function. You can use this function to test multiple conditions at once and then return the result based on it. This is helpful as you don’t have to create those long nested IF formulas that used to get confusing. Note that the IFS function is […]

5 Get Only the Numeric or the Text Part from a String Using Excel Formulas

Dataset to get the numeric or the text part in Excel

There is no inbuilt function in Excel to remove all the text part from a string and get only the numeric part (or vice versa – remove the numeric part and give only the text part from a string in a cell). However, this can be done using a cocktail of Excel functions. Let me show […]

4 Understanding Absolute, Relative, and Mixed Cell References in Excel

Mixed Cell References in Excel - Formula

A worksheet in Excel is made up of cells. These cells can be referenced by specifying the row value and the column value. For example, A1 would refer to the first row (specified as 1) and first column (specified as A). Similarly, B3 would be third row and second column. The power of Excel lies […]

« Previous 1 2 3 4 5 … 33 Next »