Skip to main content

Posts

Showing posts from October, 2021

New Article

How to SUM by matching partial text in Excel

3 Different ways to Hide or Unhide Rows and Columns in Excel 2016

While working on large data table you may need to hide single row or some rows and single column or columns. In Microsoft Excel this is very common operational activities for all types of users. This feature allows you to hide less important rows or columns and keep your focus on important data area. On the other hand, if you need to update source data, set a new column or row formatting for your working area, or share your data table to others, then you may need unhide or show all the hidden rows or columns. So, it's good if you learn it.   This tutorial will teach you 3 different ways about how you can hide or unhide rows and columns singly or multiple in your Excel worksheet. As well as, after hiding rows or columns, I'll also share 3 different ways about how you can unhide the hidden rows or columns in Excel worksheet.     Start from Select Rows and Columns:   Before going to start our lesson, first off all you need to select the rows or columns perfectly. In...

How to Freeze or Unfreeze Rows and Columns in Excel 2016

Generally when you are working with large data table in Excel, you have to move your cursor up down, left right often. If you not use Freeze, then it would be difficult for you to recognize the field title or row header. If you use Freeze feature then it becomes very easy to identify the row and column header and for this you can work smoothly on your large data table even you move from one area to another area of the same data table. In this tutorial I've tried to present how to lock some areas of rows and columns as Row or Column Title or Header to visible always while scrolling in Excel Worksheets. This feature is known as Freeze in Microsoft Excel. This feature allows you to keep freezes rows and column visible while you navigate to another area of the same worksheet. You will find the detail steps on how you can freeze one row or multiple rows, freeze one column or more columns, and freezing rows and columns at once. How to freeze top row in Excel: This is very easy to apply i...

How to change the row height and column width in Excel 2016

While working on a data table, it needs to adjust the cell height and width depending on cell values for making data table easy to work with. Microsoft Excel has more than one different ways to change the column width and the row height. You can change it through Mouse Pointer or from Menu feature in seconds. The most easiest way is double clicking. I'll try to present here all the ways, so that you can choose your best. In this tutorial, you will learn how to change the row height and column width in Excel 2016. I've tried to present here 3 different ways for rows height and column width separately. You can choose the most efficient ways for you to use it in your worksheets.   Change Row Height: In Microsoft Excel, the default row height is determined by the font size. As you increase or decrease the font size for a specific Row or Rows, Excel automatically changes the row height. So, depending on cell value (font size, wrap text, line break text) you can adjust your Row Heigh...

Remove spaces between words or numbers in Excel cells

There are Many ways to remove extra spaces but in this tutorial I'll share 2 most common ways to remove spaces between words or numbers in Excel cells. These are: TRIM formula, Excel Find and Replace options. Why it happens: When you copy paste data from an external source to Excel then it can be happens. For example, if you copy a data table from Web Based Software or Web Page and then Paste them to an Excel Worksheet, then an extra space will add along with your each cell values. This space usually add at the end of the cell values, but you can also find them at the beginning or in the middle point of a cell value. For this additional spaces your data table looks disorderly and it becomes difficult to work with. For example if you use Find option to find a First Name "Bill Jillen" which has no extra spaces, then it will not found in your data table. Thus it is very important to remove spaces between words or numbers in Excel cells to do good data analysis. The Solutions...

Selecting Cells and Ranges of a Data Table in Excel 2016

A device of computer is Mouse by which you can easily select, drag (Press Left Click of a Mouse and Hold it and then move it over a Data Table) cells of a Data Table. But for faster and work like a professional, you can also use Keyboard Shortcut. In this tutorial I've tried to share 8 different cursor movements for Selecting Cells and Ranges of a Data Table in Excel 2016. If you practice these, then it's good go for next level.   Faysal Easy Excel Video Tutorial of Selecting Cells and Ranges in Excel One: Select Single Cell: To select any of a single cell of a data table, just Left Click (Right Handed Mouse User) on that cell. Now this cell has selected. You can apply any formatting to test it. Two: Select More cells in a Range: Most of the Excel users will use Mouse Left Click + Drag to Select more than single cells in a range of a data table. But if you are not keen on using the mouse, you can use the keyboard to select the cells you want. Press and Hold the Shift key and ...

How to Insert or Delete a Cell in Excel 2016

    The Ctrl+ or Ctrl- key can be used to insert or delete individually selected cells as well. Highlight the cells you want to insert or delete, then press the above shortcut key to do fast for Excel modeling world.