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?
1 Answer
Not your question? Ask your question View similar questions
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
