Easy Way to Hide/Show Row/Columns In Excel

A very handy feature of Excel is its ability to hide rows and columns from a user without it affecting calculations in any way. This can be handy if you wish to hide calculations or certain information from a user. Hiding rows or columns can be performed in two ways, by selecting the row or column you wish to hide and going to Format>Row (or Column) >Hide or by selecting the row or column that you wish to hide, right clicking and selecting Hide.

Easy Way to Adding/Formatting Borders in Excel

Adding lines and borders is a quick way to format important information in Excel. Because by adding a line or border that we make the table easier to read.

Borders can be added to one or all sides of a cell or block of cells

• Select the cell or block of cell, than click The Borders option which is located under the Home tab of the ribbon
• Select the kind of border, (Bottom, Top, Left, Right, All, Outside, etc)

Easy Way to select cells, ranges, rows, or columns

Ther are many waysto select cells, ranges, rows, or columns.

To select	Do this
A single cell	Click the cell, or press the arrow keys to move to the cell.
A range of cells	Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection. You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.

Easy Way to Group and Ungroup Worksheets in Excel

When you work with files that consist of several sheets and forget to ungroup the sheets whereas the data which must be filled is different, there will be some sheets which are filled by the improperly data. So you need to ungroup the sheets first and then you can fill in the sheets by data that you want.
 

How to Group Worksheets in Excel

You can group together all or some of the worksheets in a Microsoft Excel workbook. The advantage of forming worksheet groups is that you can format the worksheets all at the same time. Keep reading to find out how you can use this time-saving feature of grouping worksheets in Excel.

Easy Way to Modifying Columns, Rows, & Cells

When working with tables we have to change the width of columns and rows as we need.
 
To Modify Column Width:

Position the cursor over the column line in the column heading and a double arrow will appear.

Modify Column Width

Left-click the mouse and drag the cursor to the right to increase the column width or to the left to decrease the column width.

Release the mouse button.

How to Entry Data in Excel?

There are several ways to enter data in MS Excel to be faster. Such as entering the same data or sequentially in several rows or columns. By knowing how to enter data quickly, especially for data that is patterned, we will be able to save more time.
 
Excel Data Entry Keyboard Shortcuts

Use Shortcut Keys

• Enter the current Date: Ctrl + ;

• Enter the current Time: Ctrl + Shift + ;

• Copy Value from cell above: Ctrl + Shift + '

• Copy Formula (exact) from cell above: Ctrl + '

• Copy Formula (relational reference) from cell above: Ctrl + D