Ask Experts Questions for FREE Help !
Ask
    mmurrey's Avatar
    mmurrey Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 22, 2010, 06:32 PM
    how to connect cells in excel in sequence
    How do you link cells from one sheet to another in a workbook if the cells are in a sequence? I use the formula ='Sheet1'!C2, etc. but entering the formula for each cell is tedious. Is there a faster way if the cells are in sequence?
    Scleros's Avatar
    Scleros Posts: 2,165, Reputation: 262
    Hardware Expert
    		  
    #2

    Jun 24, 2010, 09:10 AM
    If the layout of the cells matches in both sheets, such as vertically in a column, enter the formula in the first cell and then copy and paste it (CTRL-INSERT, SHIFT-INSERT) via the Windows clipboard to all the other cells. Excel will index the cell reference in the pasted formula. This is a basic core Excel feature for all formula.

    Alternatively, you can also select the source range(s), navigate to the destination sheet, and choose Paste > Paste Link. This is handy for situations where the source range is not contiguous but the destination range is.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Macro Out of Cells [ 9 Answers ]

I have an excel macro that keeps coming up with the error message that it is out of cells. I am wondering if there is anything I can do?

Count certain coloured cells in excel [ 1 Answers ]

Hi I have numerous coloured cells on an excel worksheet and I want to make a formula to count the different colours... ie all the red ones, the green ones etc... Which formula would I use

Excel - Count how many cells have a certain color [ 1 Answers ]

Is there a formula to count how many cells within a row have a certain color. For Instance if I have A1 to M1 filled in with text and 8 are colored yellow then I want my result in N1 to say 8. Any way to do this?

Excel - Merge Cells [ 3 Answers ]

Any way to merge a number of cells into one cell, for example the title of many columns in a table?

Multi line cells in excel [ 4 Answers ]

Hey guys, any idea how to have multiple lines in a single cell in excel? I'm trying to make my table look a little neater, but it makes some of my comments overlap into following cells - is there any way to make the rows higher and to have 2 lines of text in a cell? Thanks in advance - Cap

View more questions Search