palswhe.blogg.se

Create a temporary column next to your target column.The easiest way to select alternate cells, in a column is by creating a new temporary column next to your target cell and using Selection offset in the following way: Now let’s jump into some methods you can use to select every other cell in a column in Excel Method 1: Using Go to Special and Selection Offset So, you have to go about it the long way. Maybe you need to do some sort of calculation or operation that involves only the odd or even-numbered cells, or every nth cell.Īs of now, there’s no straightforward function or menu item to get this done. Maybe you need to color every alternate cell with a particular color. There may be a variety of reasons that one might need to select alternate cells or every nth cell in a spreadsheet. Why Would You Need to Select Every Other Cell in Excel? How to Sum up Values of Every Alternate Cell.How to Select Cells in Every Other Column.Method 1: Using Go to Special and Selection Offset.Why Would You Need to Select Every Other Cell in Excel?.