You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

How to link rows in Excel so they will stay together during sort?

How to link rows in Excel so they will stay together during sort?

Price: FREE

In Excel I am trying to track body weights over time for hospital patients, linked with specific interventions on the row below. I would like to link these 2 rows of data permanently so that when I sort based on intervention, the body weight data will stay with the intervention.

Visit publisher's web-site: How to link rows in Excel so they will stay together during sort?

Category and Tags: ExcelTutorials : : Charts

Related Tutorials

Reference to a Cell content

Free: Yes
Tags: Excel ›

I have a workbook that I periodically place info into. It has numerous worksheets and I want to link back and forth as I build it. The problem is, when I insert rows, columns or sort data, the link stays put to the cell, and the contents sort away. I need the bookmark to stay with the info in the cell, so that as I sort or add rows and columns, the info is linked to properly when I click on the link on the other worksheets and I am not simply directed to a geographical location on the linked to sheet. Is there any way to " lock" the info to the cell so that when I sort or add rows or columns, the info stays with the original cell as it is sorted or moved?

Keeping Rows Together

Free: Yes
Tags: Excel ›

Is there a way to keep rows together in Excel so that when you sort the rows will stay together and so that when there is a page break the rows will stay together on a page? I have a spreadsheet where the first three rows are merged in column A and then are not merged in columns B and on. When I try to sort by Col. A I get a "merged cells have to be identically sized" message.

Sort column data while locking together objects in different rows

Free: Yes
Tags: Excel ›

So I need to sort a list of objects in a column, but besides having data just in the adjacent columns, there is also data below the adjacent column that is matched to the need to be sorted cell. I've attached an excel document as an example of what I need done.
I want to sort this data by the delivery month, so I cant make a bunch of data that is similar to this format ascending or descending. I would then want all the adjacent data to stay the same which would be easy enough, but I also want the data below that I have outlined to stay with the data as it is sorted
Is there a way to lock the cells below (sum,high, median, launch) so that they stay with each group of data? I have a feeling this is impossible, but maybe someone here has a fix.

Retaining cell borders when sorting

Free: Yes
Tags: Excel ›

I have a database I am making, each 2 rows have a cell borders in a certain format.
I need to (once I am done entering all of the data) sort them ascending by name.
I know how to sort, however, when I sort it will sorts the data but the cell borders stay in the same place.
= How do I make it so that I can group 2 rows worth of cell together in a manner that would retain my border scheme when I decide to sort. I need the borders to move WITH the cell data, and I need both (2) rows to stay together when sorting, maybe by grouping them somehow.

Use macro to sort column

Free: Yes
Tags: Excel ›

I have 3 columns of info-B,C,D.
I want to sort the numbers in D in ascending order, but I need the info in B and C to stay with the number in D.
I do not want to do it through "sort" because 5 worksheets has 77 rows, and the sorting is in sections in those 77 rows. If you can show me the macro for the first section, Rows 6-18, I can figure out the rest. Please do not leave anything out of the macro, like the beginning and the end words, because I cannot write them, I can only edit the ranges.

Related Applications & Scripts

Ultimate Reciprocal link exchange script

Free: No
Tags: PHP › Excel Link Exchange

Softbiz reciprocal link exchange script is very powerful tool to help you with your search engine standing by increasing your site's link popularity. Script automates the job of exaching links with your link partners.Visitors can exchange links by filling a simple form. You can approve/disapprove the link partners request.
How is this reciprocal link exchange script special?
-Multi level organization of links
-Invites your visitors to exchange link
-Link exchange is fully automatic
-100% automatic reciprocal link validator
-Tracks traffic you recieve from link partners
-Automates job of keeping track of which link -partners are still linking to you
-Very strong admin panel

Add your site to our free link directory

Free: Yes
Tags: Web Services › Excel Link Indexing

This is a totally free and extremely popular link directory, which already received over 1000 approved link submissions within the past month. Our link directory consists of search engine friendly categories where you can add your website and/or scripts to. No reciprocal link or fee is required, and you will never receive any spam. So simply submit your site and you are done!

Online link extractor utility

Free: Yes
Tags: Web Services › Excel Link Based

Free link extractor tool helps in extracting the url or link from a specific web page.

Check for Reciporical Link

Free: Yes
Tags: PHP › Excel Link Checking

Use this script to check if reciporical link agreements are being honoured. Check for a given link in a remote page.(Demo + source code included)

Submit Form Link - Javascript

Free: Yes
Tags: JavaScript › Excel Forms

A very simple and powerfull Submit Form Link javascript! Submit Link Form : Replace a "classic" submit button by a text or image link to process a form !

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing