Deleting Empty Rows in Excel by Shortcut (3 Steps)
In this tutorial, we will show a three steps process of removing all empty (adjacent or non-adjacent) rows in Excel – by using a shortcut.
Excel Tricks
Excel Shortcut to Delete a Row [3 Video Demos]
Deleting rows in Excel using a shortcut In this tutorial, I will show you how…
Excel Shortcuts to Insert Current Date and Time [3 Examples]
Inserting the current date and time is generally required as you are working with Excel worksheets. The following shortcuts can be used for inserting date and time in Excel:
How to Hide Selected Row(s) in Excel by Shortcut?
How to hide one or more rows quickly by using a keyboard shortcut?
How to AutoFit Column Width in Excel? [Shortcut]
So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut…
A brief about show/hide formulas in Excel
In this tutorial, you will learn how to show or hide the formula in the cells and formula bar in Excel.
How to Add a New Line in Excel Cell?
If you have long text to enter in an Excel cell or just require pushing…
Wrapping Text in an Excel cell
In certain cases, the cells in a worksheet contain text that is bigger than the…
Insert One or multiple rows in Excel
In this tutorial, I will show you how to add one or multiple rows in Excel. With demos, you can also see the shortcut for adding rows.
Unhide columns, rows and sheet in Excel
In the first section, I will show you with screen shots, how to unhide the column(s) in Excel. This is followed by the section to unhide rows and finally, you can see how to unhide a sheet.
Add/Remove Columns in Excel
In this tutorial, you will learn how to add a column in between other existing columns.Two ways of adding the column in for that scenario are explained below.
Moving Columns and Rows in Excel
In simple terms, moving the rows and columns in Excel is just the matter of copy and paste or pressing the short keys Ctrl + X and Ctrl + P, that you might already used too while working in Excel, MS Word or other programs.
Freezing Columns in Excel
In Excel, freezing the first column (the left most) is pretty easy. Similarly, freezing two or more columns is easy that I will show in this tutorial.
2 Ways to On/Off Scroll Lock in Excel
If you suddenly start seeing navigating from cell to cell is stopped while pressing the arrow keys and rather navigating in the worksheet then your scroll lock is ON.
How to Freeze Panes in Excel?
Freezing the rows or columns while working in a long workbook can be really useful. For example, the top row contains the headers of the workbook and while entering data or analyzing it
