Nov 30, 2014 · Hi, I am often in the situation that I want to copy the cell fill color to another cell, without the rest of the format, like borders, fonts, etc...Oftentimes the fill color is not one of the …

Oct 13, 2017 · So whenever I've used Excel (2016) in the past, when dragging a handle or doubleclicking the autofill box, the autofill series has been the default option. i.e. dragging the …

Jan 27, 2020 · Hmm, when I try any of the copy and paste options, my Excel (2013) is not looking back to the original sheet. Instead, the formula copies over exactly as written and creates a …

Feb 15, 2010 · Hi, Is there an easy way to automatically select all the cells in a worksheet that contain a specific word? I want to be able to select all of them and then move all of them in …

Apr 13, 2011 · Copy the cell you want to copy. With the hidden rows hidden, select the entire range you want to copy to. Press Alt>; (that's the shortcut for visible cells only). This should …

Mar 16, 2024 · I have a spreadsheet with form control checkboxes next to various cells. I would like a formula where if the checkbox is selected, then it copies a specific cell and pastes it into …

Aug 4, 2025 · Your ability to copy and paste, sort, even select cells will be hampered. The better alternative is hidden deep in the Format Cells dialog. Since merged cells can be problematic …

Nov 7, 2005 · Question: How do I copy/paste just the "header" rows of a data table that has been grouped/outlined using the GROUP functionality? Seems like a straightforward question, but I …

Apr 16, 2019 · Hello I have what I think will be a very simple question. How do i drag a cell to copy into other cells without the number changing? example: I type 20 into a1, i want to drag it to …

Jul 1, 2003 · Excel defaults to filling a series with the autofill. I put 1 in cell a1 and autofill down it goes to 2,3,4,5... How do I change the default so it stays 1 all the way down? I know to use …