How do I move a spreadsheet row in a worksheet to the bottom under the database section?

[Bruce Kieffer]

I want to move row 3 to the bottom of my worksheet. Can it be done? How?

[Boh]

The icons at the top of columns indicate the sorting order. At the moment your are primarily sorting by column G then D then E then F. Do you need all that? It's not so straight forward to get a particular row in a particular location in a data base spreadsheet. To do this I have sometimes resorted to not have any sorting of columns then the rows will arrange in the objects draw order. Send something to the back or front of a drawing and with a recalculate the item will appear either at the bottom or top of the worksheet. But this only works if there is no other sorting. 

 

Alternatively you could add another field to the record you are reporting on called "List order" or something. Make a column in your worksheet for that field and make it the primary sorting column. Put numbers in the field to get the sort order you want. If you just want one row to be at the bottom it just needs to have a higher number than all the others. Once you are done sorting you can make the column width for the "list item" column have zero width which will hide it away.

 

 

[michaelk]

I think he wants to move the row above the database to below the database.  The row that contains just the total.

 

Grab the bottom right corner of the worksheet and drag it down to resize the worksheet.  It takes a careful touch to do it without also creating a new column to the right, but it can be done.

 

Then select all the cells in row 3  and copy.  Select all the cells in the new row 5 and paste.  This will get all the formatting.  But because cell references are relative it might not get the reference for the quantity right.  So you may have to delete the contents of that cell and type in = and then click on cell 4C or just type in =4C.

[Bruce Kieffer]

Thanks @Boh and @michaelk. MK you are correct. And the second I read your answer I remembered I had asked this before. Here's two problems with this: First, I am old and I don't remember these things!. And for the real problem, Doing this is not at all intuitive. Somehow the user is supposed to know this? There should be a menu command to add rows under a database.

[michaelk]

@Bruce Kieffer, are you saying there may be features in worksheets that are not easily discoverable? 🙂 

 

It's gotten MUCH better the last couple years.  You no longer need to know the secret sorting trick or memorize functions.  But you're right, that one is still tough to discover by poking it with a stick.

[Bruce Kieffer]

@michaelk, I think that is what I'm saying!