Microsoft Excel Tips

Edit Custom Lists in Microsoft Excel 2019

Edit Custom Lists in Microsoft Excel 2019

Previous post: Sum Cells Text Numbers MS Excel 2016 What is Edit Custom Lists in Excel ? In Microsoft Excel “Edit Custom Lists…” is extremely powerful and helpful when we need to Create lists for use in sorts and fill sequences.   Where is Edit Custom Lists button located in Excel ? This option can […]

Read More →

Read More →

Sum Cells Text Numbers within same Cell Microsoft Excel

Sum Cells Text Numbers within same Cell Microsoft Excel

Add Numbers Text of multiple cells Excel 2016 Previous Post: SumIf function of Formulas tab in Microsoft Excel 2016 This post guides us on about Sum Cells Text Numbers. The prior post, illustrates about the SumIf function. It is part of the Math Trig functions of the Formulas tab. This function helps users to add numbers on […]

Read More →

Read More →

Splitting data using Text to Columns button worksheet MS Excel

Splitting data using Text to Columns button worksheet MS Excel

Split content use Text Columns button Excel 2016 Previous Post: Apply Filter on data with Cells in worksheet Microsoft Excel 2016 While working in Microsoft Excel, there are often times, when we need to separate the data. The content present in a single cell has to be split into other cells from a single cell. So, in […]

Read More →

Read More →

Apply Filter on data with Cells in worksheet Microsoft Excel

Apply Filter on data with Cells in worksheet Microsoft Excel

Apply Filter on content in spreadsheet Excel 2016 See Previous Post: Using Flash Fill feature tool worksheet Microsoft Excel 2013 In this post, we’ll explain about, What is the use of the Filter ? And, How to Apply Filter in a workbook ? In the first place, before answering these questions; let us know the positions of the Filter button […]

Read More →

Read More →

Using Flash Fill feature introduced from Microsoft Excel 2013

Using Flash Fill feature introduced from Microsoft Excel 2013

Use Flash Fill feature of Microsoft Excel 2016 See Previous Post: Advantages Text Box over Cell content Microsoft Excel 2016 Through this post, we’ll discuss about; How to Use Flash Fill feature ? This remarkable tool had been introduced in Excel, from the 2013 version. Also, the other things to know, are the Column and the Row in the […]

Read More →

Read More →

Advantages of Text Box over Cell content in Excel 2016

Advantages of Text Box over Cell content in Excel 2016

Benefits of Text Box in worksheet MS Excel See Previous Post: Understand Quick Access Toolbar (QAT) Microsoft Excel 2016 In this post, we’ll know about the advantages of the Text Box. First of all, the Text-Box is part of the Text group. This group is present in the Insert tab ribbon. Also, the Text Box can be find inside the Shapes […]

Read More →

Read More →

Top