M
M
Max2017-09-27 13:04:27
Spreadsheets
Max, 2017-09-27 13:04:27

How in Excel (preferably Google Spreadsheets) to add a row ALMOST at the very beginning with a simple click, and not a series of clicks?

RNmUcsoKkZs.jpg
You can add a line at the bottom of the table simply by clicking and starting to type. But at the top.
After the FIRST line

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
vaut, 2017-09-27
@vaut

And how do you imagine it?
Everywhere (libreoffice, excel and Google) this is done in two clicks:
1) select the line
2) insert the line above.
If we skip the first or second paragraph, everything will be bad for us ...
If you need the first row of the table to always be empty, then you can look for a solution using scripts.

X
x67, 2017-09-27
@x67

order a macro for 500 rubles or use a filter and sort - add lines at the end, and then sort by the desired parameter (date added, for example).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question