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?
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