You can select multiple cells by clicking the first cell in your range, then while holding your click, drag the cursor in the direction that you want to expand your range, until you have reached the cell that is at the end of the desired range. These selection shortcuts will also be helpful if you are copying and pasting formulas to a range of cells with Ctrl +C and Ctrl + V. Cell selection shortcutsīefore I go over the autofill shortcuts, I'll show you a few ways to quickly select a range of cells that you want to copy formulas into.Īn important part of being able to effectively use the autofill shortcuts that are explained in the section below, is being able to quickly select the cells that you want to copy formulas to before using the shortcut. If you don't want to use shortcuts and prefer simply dragging the fill handle, this is perfectly fine. The shortcuts below can help you quickly select cells and copy them to other locations.
#How to do an if then formula in excel how to#
To describe the examples in this article I will stick to the traditional way of teaching how to autofill formulas, which is to click and drag the fill handle until the desired cell/range has been reached / copied to.īut in your case you may have hundreds or even thousands of rows, and so below I'll also mention some different shortcuts that you can use to make things faster, especially when you have a large number of columns or rows to be filled / copied to. If you actually want a formula in every single cell of a column, it can be as simple as copying your formula, selecting the entire column, and then pasting the formula into the entire column (more on this below). In the examples below we will be copying formulas down a range of cells, such as C3:C17, which we will refer to as a "column"… since when it comes to real world spreadsheet applications, where we usually have headers in our sheet, if we are talking about applying formulas to a "column", we are often referring to a range of cells within that column. If you are searching for a way to apply a formula to an entire column, you might have been searching for a single formula that can handle that task without having to copy multiple formulas, and this can be done by using the ARRAYFORMULA function in Excel.īut in this article we will stick to using autofill / fill down to copy formulas. This article shows how to copy formulas in Excel, but click here if you want to learn how to copy formulas in Google Sheets. Click on a cell with a formula in it, press Ctrl + C on the keyboard to copy it, then select another cell, and press Ctrl + V on the keyboard to paste the formula Alternative method: You can also copy and paste cells that have formulas in them to copy formulas.Release your click when you have reached the last cell that you want the formula copied into.Drag the fill handle down to the bottom of the column/range that you want your formulas to copy into.
#How to do an if then formula in excel plus#
0 kommentar(er)
