Splitting data using Text to Columns button in worksheet MS Excel

Splitting data using Text to Columns button in worksheet MS Excel

Split content with use Text Columns button Excel 2016 While working in Microsoft Excel, there are often times, when need to separate the data. The content present in a single cell has to split into other cells from a single cell. So, in this post, we’ll know about, How to Split the data from a cell to […]

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 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 in Excel ? So, the Filter button can be find at two […]

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 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 worksheet. Specifically, the Cells selected in the Vertical direction make the Column. And, […]

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 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 button. This button is part of the Illustrations group of […]

Read More →

Read More →

Understand Quick Access Toolbar (QAT) in MS Excel

Understand Quick Access Toolbar (QAT) in MS Excel

Utilize Quick Access Toolbar (QAT) Excel 2016 Let us understand about the Quick Access Toolbar. So, the QAT plays a very important role in Microsoft Excel. Also, it’s quite interesting to know about it, but overlooked by most of the users. This toolbar is the top right most blank space located above the Tab Ribbons. Particularly, by default […]

Read More →

Read More →

Set Printing for a worksheet document in MS Excel

Set Printing for a worksheet document in MS Excel

Set Printing for sheet content MS Excel 2016 In the previous post, the Fill Handle was part of the discussion. And, now we’ll know how to set up print for the Excel data, in this post. The Page Layout tab has the Page Setup group. So, this group has total Seven buttons. Firstly, the Margins button, […]

Read More →

Read More →



Top