From the Developer Menu Ribbon, select Visual Basic.
For this, we need to write a short module in VB Script. But we want alternate cells of Column A selected, not B. Notice that the numbers form every alternate cell in Column B.
When you click OK, you will see only the numbers selected in Column B.
From the ‘ Go To Special’ Dialog Box, select the radio button for ‘Constants’ and deselect all the checkboxes, except for ‘Numbers’.
Select ‘Go to Special’ from the sub-menu.
Click on the Find & Select button on the Home Tab’s ribbon.
Double click the fill handle and you will see a number and the letter A appear alternately in a pattern from cell B1 to B50 (something as shown below).
Enter any number, say 1 in cell B1, and a letter, say A in cell B2.
Right-click on the row header and select ‘Insert’ from the popup menu. So if you want to select cells from column A, create a temporary column in Column B.
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?
#Rangkuman isi buku psikologi pendidikan how to
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?.
0 kommentar(er)
