Tip 63 – How to Insert Multiple Rows in Excel
Learn how to insert multiple rows in Excel.
In Excel, you can insert multiple rows in several ways:
Here are the steps that is outlined in the video.
1) Select a row.
2) Hold Shift and drag the fill handle.
Here are the other ways.
1) Using the ribbon:
* Select the number of rows that you want to insert.
* Go to the “Home” tab on the ribbon.
* In the “Cells” group, click the “Insert” button.
* Select “Insert Sheet Rows” from the drop-down menu.
2) Using the right-click method:
* Select the number of rows that you want to insert.
* Right-click on any of the selected rows.
* Select “Insert” from the context menu.
3) Using the keyboard shortcut:
* Select the number of rows that you want to insert.
* Press “Ctrl + “+” on your keyboard.
4) Using the “Table” option:
* Select the cell where you want to start your table.
* Go to the “Insert” tab on the ribbon.
* In the “Tables” group, click the “Table” button.
* Excel auto-creates a table with required rows.

Tip 64 – How do I make angled cells in Excel?
Learn how to make cells 45 degrees in Excel.
Here are the steps to rotate text in a cell:
1) Choose the target cell or cells.
2) Right-click and pick “Format Cells.”
3) Go to the “Alignment” tab.
4) Adjust text rotation using the arrows.
5) Click OK to save changes and close.
You can also rotate text by using the ribbon option:
1) Choose the target cell or cells.
2) Access the “Home” tab.
3) Click “Orientation” in the “Alignment” group.
4) Pick your rotation angle from the menu.
5) To reset, choose “Horizontal” from the menu.
Here are the steps outlined in my video.
1) Select row of cells.
2) Home — Alignment — Angle Counterclockwise

Tip 65 – Fill Handle
How do you use a fill handle? – Excel Tips and Tricks
Learn how to use a fill handle in Excel.
To use the fill handle, you can do the following:
1) Choose cells with data or formulas.
2) Hover over the fill handle until a plus sign appears.
3) Drag to the target cells.
4) Release to copy or fill.
Here are some of the thing you can do with Fill Handle.
1) Duplicate Data By Dragging Or Double Clicking
2) Delete data
3) Create Sequence (or increment or Decrement)
4) Use Flash Fill

Tip 66 – Why Fill Handle Excel not working?
Learn about why your fill handle is not working in Excel.
1) File — Options
2) Advanced
3) Place check on “Enable fill handle and cell drag-and-drop”
4) OK

Tip 67 – Count How Many Times A Character Appears In A Cell
Learn how to count how many times a characters appears in a cell in Excel.
Use this formula.
=LEN(A2)-LEN(SUBSTITUTE(A2,”#”,””))

Tip 68 – What is the shortcut key to highlight a row in Excel?
Highlight Row
To select the whole row, click on any cell, and press Shift + Space.
Highlight Column
To highlight a column, click on any cell, and press Ctrl + Space.
Ctrl + Space

Tip 69 – How To Highlight Active Row in Excel
Learn how to highlight active row in Excel.
Here are the steps outlined in the video.
1) Ctrl + A
2) Home — Style — Conditional Formatting
3) New Rule
4) Select “Use a formula to determine which cells to format”.
5) =ROW()=CELL(“ROW”)
6) Format
7) Fill tab.
8) Select yellow colour.
9) OK
10) OK
11) Right-click sheet. View Code.
12) Select Worksheet
13) Enter
Target.Calculate
14) Close Code editor

Tip 70 – How do I use slicers to filter data in Excel?
1) Select header
2) Ctrl + Shift + L
OR
Data — Sort & Filter — Filter
To apply Slicer, follow these steps.
1) Ctrl + A
2) Ctrl + T
3) OK
4) Insert — Filters — Slicer
5) Select header
– Lead Studio
– Year
6) OK

Tip 71 – Deleting All Formatting
To clear formatting, follow these steps.
1) Ctrl + A
2) Home — Editing — Clear
3) Clear Formatting
Clear All
Deletes everything from the selected cell(s).
1) Ctrl + A
2) Home — Editing — Clear
3) Clear All
Clear Formatting
Delete all formatting from the selected cell(s).
1) Ctrl + A
2) Home — Editing — Clear
3) Clear Formatting
Clear Content
Deletes the content of the cell from the selected cell(s).
1) Ctrl + A
2) Home — Editing — Clear
3) Clear Content
Clear Comment
Deletes cell comments from the selected cell(s).
1) Ctrl + A
2) Home — Editing — Clear
3) Clear Comments
Clear Hyperlinks
Deletes hyperlinks from the selected cell(s).
1) Ctrl + A
2) Home — Editing — Clear
3) Clear Hyperlinks
Remove Hyperlinks
Deletes hyperlinks and formats the cell from the selected cell(s).
1) Ctrl + A
2) Home — Editing — Clear
3) Clear Hyperlinks

Tip 72 – How To Create Multiple Worksheets From A List Of Cell Values
Learn how to create multiple worksheets from a list of cell values.
Here are the steps.
1) Place cursor in any name
2) Insert — Tables — PivotTable
3) Existing Worksheet
4) For Location, select B1 (or any cell)
5) OK
6) Drag “My Friends” into Filters.
7) Select the new PivotTable
8) PivotTable Analyze — PivotTable — Options — Show Report Filter Pages…
9) OK