Ask Your Question
0

how can I insert new data at the top of a spreadsheet?

asked 2018-11-01 02:35:00 +0100

searchwest gravatar image

updated 2018-11-01 03:59:02 +0100

Ratslinger gravatar image

I'm keeping bank account records and I need to add new transaction details above older transactions.

Edit:

What I need to do is to paste unformatted text into 4 or 5 columns for 5 bank accounts. Each account.is a new sheet. The number of rows is different each time, depending on the latest transactions since I last updated.. There is some process in excel where you can paste rows and move previous details down.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-11-01 10:31:33 +0100

ajlittoz gravatar image

updated 2018-11-01 10:32:30 +0100

Put the cursor in a cell of the top row and Sheet>Insert Rows>Rows Above.

Despite the plural form in the menu item label(s), this command inserts only one row. To repeat for the desired number of rows (better this number be small because you add one at a time), type Ctrl+Shift+Y. The key combination reissues the last command.

Once you have inserted the needed rows, paste your data in the first cell.

edit flag offensive delete link more

Comments

1

It is possible to insert multiple rows at once using Insert Rows For example, you can select 20 rows, apply Insert Rows Above command and 20 rows will be added above the selection.

SM_Riga gravatar imageSM_Riga ( 2018-11-02 13:08:08 +0100 )edit

Thanks for the tip

ajlittoz gravatar imageajlittoz ( 2018-11-02 13:56:43 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-01 02:35:00 +0100

Seen: 47 times

Last updated: Nov 01 '18