Enter multiple rows or columns at once in Excel

Configurare noua (How To)

Situatie

As you start to organise your data, you’ll find that you’re constantly needing to add more rows or columns.

Depending on the size of your spreadsheet, you may need to add hundreds of rows at a time. We all know the right click and insert, but doing this constantly gets a little tedious.

Solutie

Here’s a quicker way:

Say you want to add 5 rows to your spreadsheet.

Simply highlight 5 of the existing rows, where you want to insert the new ones, then right click and select “insert”.

This will add the 5 extra rows you wanted.

If you want to add more than 5 rows, simply highlight the required number of rows and insert.

Tip solutie

Permanent

Voteaza

(5 din 8 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?