drag

Hey all new here great forum.. Need some help with formula. I am referencing same value from another tab in same workbook and I want to drag the formula down but only include the fixed value in every 4th row. I tried OFFSET and ROW but it seems to not be working.

Hi I have A1=10, A2=20, A3=sum(A1,A2). If I copy cell A3 and paste it in H13, I will get sum(H11,H12). So far is good; however, if I drag cell A3 and drop it in H13, then I will get s=sum(A1,A2). Why drag and drop keep the cell reference but copy and paste is not? Thank you.

First Time Poster so forgive the bad formatting. I am building a basic spreadsheet for our warehouses to use to print location labels. I data is in this format. In order to print labels, I need to stack the info on top of each other. When I do this and drag the formula down, it is jumping three...

With Formatted Cells, (Borders, Fills, etc.), when you want to drag the contents of 1 cell to the other by just grabbing the edge of the cell, it sometimes erases the formatting of that cell, if it has a color fill it will be reset to white, as well as other formatting is reset. Also the...

I am sorry in advance for the title i am not sure how to word the title or really how to form this question. Back in the day i would drag a cell from the bottom corner and "fill formatting" or "fill series". for some reason this is gone now and replaced with a new menu that i don't understand.I...

I want to be able to drag a name from a list and drop it into a cell, I don't want to use the inbuilt drag and drop as if I do this it copies across the original cell format and the copy and paste values is a bit beyond some others who have to use the worksheet. Is there a way to do this in...

Help please... So this seems a bit strange. But then again it may be something some of you may have encountered before. I have a spreadsheet, only 2mb. When i enter figures manually it updates a couple of graphs (no biggie- my laptop can handle this and then some) but it keeps...

Good Day, I am trying to create a sequence of bar code number in Excel that I can drag down to run in sequential order. I would need the last digit to increase by one number as I drag it. I cannot seem to get it to work as it does not run in sequence. I converted the number to text because it...

Hi All, I want to create an asset management work sheet that I can drag an object that holds a value (vehicle 1) for example and place it in another cell. The idea is a yard management document where I have a set number of Vehicles and I want to allocate them by dragging and dropping them into...

Property Name <colgroup><col><col><col><col><col><col><col></colgroup><tbody> Unit Mix Rent $ Square Foot Studio D8 H8 1 Bed, 1 Bath D9 H9 1 Bed, 1.5 Bath D10 H11 1 Bed, 2 Bath D11 H13 </tbody> Property Name...

Hello, I am trying to write a formula that will perform the following function, and drag down a column: IF the value in column K is <0, the value in the same row of column I is the equivalent positive. The values in column I remain as a maximum. This is an example of the result I'm looking...

I've got a sheet that goes... 1 1 2 2 3 3 I want to highlight those and drag it down so it looks like... 1 1 2 2 3 3 4 4 But at 4 I get this 3.6 4.057142857 Any ideas on how to do this? MS Office Plus 16.5

Hi all, Ive got the following formula and want to drag it but changing G:G in relation to the column =SUMIFS(INDIRECT("'"&$F$4&"'!G:G"),INDIRECT("'"&$F$4&"'!C:C"),$E28,INDIRECT("'"&$F$4&"'!A:A"),$E$4) Sorry, I didnt make this formula and really dont understand so well how this works so any...

Hello, Is it possible to replace the text in a cell with the same text after you drag and drop that cell to an adjacent cell? For example replace Unit 1 in cell P2 after I drag it into M1?

hi all ive seen many templates have a drag/arrow icon on the bottom of the last row or column. What ive seen it do is have data stored only when you drag the arrows down then more data appears how can i do that. Thanks

I am not comfortable with macros, (this week was the first time I've tried one) I have 31 sheets that I am moving data to on the master sheet. I finally used $$ to lock the cell and column, so I can drag the formula down, but is there any way I can type something to increment the sheets ex...

Hi, I want the following pattern to continue for the length of the worksheet but it doesn't follow the correct pattern when I drag down. This is what I want the pattern to be: Sheet 2 Z1 = 'Sheet 1'!AD2 Sheet 2 Z2 = 'Sheet 1'!AK2 Sheet 2 Z3 = 'Sheet 1'!AD3 Sheet 2 Z4 = 'Sheet 1'!AK3 Sheet 2 Z5 =...

=COUNTIF(B:B,"*01*") How can I drag down the 01 down to 120 please

Hi, how can I keep one variable in an excel formula static? For example, using the following formula, I want B1 to remain the same for the formula when I drag it down the column it is placed in Formula: =(B1/A2)/100 Then I want to be able to drag down the formula in column B so it would copy...

This may or may not be a simple question. But how do I add a row (with assigned formulas) so that the formulas are automatically applied to the new cells, without having to drag the cell down myself. Also how can I make the new row copy the other row's merge settings? Thanks in advance.