Having knowledge of how the different programs that make up the Microsoft Office package are handled can be useful enough to open many doors. At work, the use of programs such as Microsoft Word and Microsoft Excel are usually the daily bread.
If you are interested in starting to learn or deepen your knowledge of Microsoft Excel, you are in the right place. Here you can learn some techniques related to inserting or deleting rows.
Managing the lines
Has it ever happened to you? You deleted some data from a cell and you need to move the data from the cells or merge the following cells in Excel so there is no blank space.
The most common error in this type of situation is to copy or cut the information to paste it and continue with the sequence that is intended to be established.
Simplify and save time
The wonderful thing about Microsoft Excel, as well as all the other programs that are part of Microsoft Office, is that the developers have looked for all the best formulas to facilitate the work of their users.
To make an experience more enjoyable and simple, you must follow these steps:
- Select the cell or cells you want to delete.
- Press the right-click.
- A box will appear with four options.
- Check the box with the Scroll Up option.
Following this series of simple steps, you can get rid of all those cells that have been left blank, without having to proceed to copy or cut all the information below and follow the sequence.
The interleaved rows
They have provided you with a series of data (dates, telephone numbers, etc.) and now, you must add the names. To do this, you must insert a series of interleaved cells to be able to complete the assigned work.
Forget the tedious process of adding cells one by one… there are simple solutions using a series of tricks that will make your work easier.
More quick fixes
Microsoft Excel has a series of tools that will help you save time and effort, allowing you to complete your work in less time. As the case may be, here are some tips:
To insert: If you want to insert interleaved cells, one of the best solutions you could find is the following:
- Write a number in the column next to it (If your information is in column A, write the numbers in column B).
- Go to the lower right corner of the cell and drag the number.
- If this did not result in a number sequence, but instead the number 1 was copied and pasted, click Auto Fill Options (upper right corner of the last cell).
- Select the Fill Series option.
- This will cause the number sequence to be followed.
Once this series of actions has been carried out, what you will proceed to do is select, copy and paste cells from that series, in the same column. That is, if your numerical series is from 1 to 10, after 10 11 will not come, but will start with the number 1. Once this is done, the next step is:
- Select the column that contains the numbers.
- Click on the Sort & Filter menu, located on the right side of your tool ribbon.
- Select the Sort option from smallest to largest.
- This will make the numbers repeat, leaving interleaved rows in the column where you have the information.
- Delete the column with the numbers.
To eliminate: If, on the other hand, what you want is to eliminate the interleaved rows, you must proceed as follows:
- On the right side of your toolbar, locate the Search and Select option.
- A menu will be displayed, in which you will click on Go to special.
- In the box that will appear, select the Blank cells option.
- Once selected, click on the Delete option on your tool ribbon.
In this easy, practical and fast way, you will be able to add and delete the interleaved rows that you want, without having to follow bureaucratic protocols. Don’t waste any more time and apply your new knowledge in Excel.