- #Highlight every other row in openoffice calc how to#
- #Highlight every other row in openoffice calc manual#
- #Highlight every other row in openoffice calc software#
- #Highlight every other row in openoffice calc code#
- #Highlight every other row in openoffice calc license#
Then click OK, every other row in the selected range from the second row is deleted at once, see screenshot:įor a starter user of Microsoft Excel, using VBA macro is a little complicated. Then a dialog pops up for selecting a range. Set InputRng = Application.InputBox("Range :", xTitleId, InputRng.Address, Type:=8)ģ. VBA code: Delete every other row in selection: Sub DeleteEveryOtherRow() Click Insert > Module, and paste the following macro in the Module Window. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.Ģ. Click to download Kutools for Excel!Īctually, VBA macro is also a good choice to resolve this problem.ġ. Kutools for Excel's Select Interval Rows & Columns utility can help you to find and select every other or nth rows or columns, and then you can do some operations as you need. Select every other or nth row, column and then delete them at once At last, you can delete the helper column C as you need. Then it deletes every other row, and you need to click Filter button again to show only the rows with 1. Select the visible rows with 0, and click the Home > Delete > Delete sheet rows to delete these rows. Then click the arrow button beside C1, and only check the 0 under the Select All option. Select the column C, and click the Filter button under Data tab. In this case, we enter the numbers in helper Column C. In a blank column besides original data, enter 0,1,0,1…,0,1. Microsoft Excel's Filter command can help you quickly filter every other row and then delete them at once, please do as follows:ġ.
#Highlight every other row in openoffice calc how to#
And this article will show you some tricky things about how to select every other row or column first and then delete them quickly.ĭelete every other row in Excel with Filter commandĭelete every other row in Excel with VBA codeĭelete every other row or column in Excel with Kutools for Excel If you want to quickly delete every other row or column in Excel, the main point is how can you quickly select every other row or column first and then apply the delete operation to them. ' now set color to Odd (number) rows (are even indexes)ĪctRange = actSheet.getCellRangeByPosition(0,i,lCols,i)ĪctRange.How to quickly delete every other row in Excel? ' set range to one color (performance issue)ĪctRange = actSheet.getCellRangeByPosition(0,lStartRow,lCols,lRows)ĪtPropertyValue("CellBackColor", lEvenColor) ' style heading found: increase start row If INSTR(oCell.CellStyle, "Heading") > 0 then ' watch out on first 4 rows if they might be formatted as heading MsgBox(sQuestion ,35, sModulSubName & " - " & sModulVersion)ĪctSheet = & CHR(10) & "No: apply to actual sheet only" & CHR(10) & "Should all sheets be affected?" _ "Applying alternating background colors to used cell range."_ ' more than 1 sheet, ask if macro should work on all sheets & "Macro " & sModulSubName & " will terminate now." _ & CHR(10) & "range in CALC Documents and will only work there."_
& CHR(10) & "background colors to the rows of the used cell"_ & CHR(10) & "This Macro applies alternating, pre-definied" _ "Macro not called from CALC Document." & CHR(10) _
#Highlight every other row in openoffice calc manual#
Sub colorCalcTableRowsEnglish ' manual extension ' =ĭim sModulName, sModulSubName, sModulVersion
#Highlight every other row in openoffice calc software#
'this program if not, write to the Free Software Foundation, Inc., 59 Temple
#Highlight every other row in openoffice calc license#
'You should have received a copy of the GNU General Public License along with See the GNU General Public License for more details. 'WARRANTY without even the implied warranty of MERCHANTABILITY or FITNESS FOR 'This program is distributed in the hope that it will be useful, but WITHOUT ANY 'Foundation either version 2 of the License, or (at your option) any later
'the terms of the GNU General Public License as published by the Free Software 'This program is free software you can redistribute it and/or modify it under HTH 'Copyright (c) 2004, 2016 Winfried Rohr, re-Solutions Software Test Engineering
#Highlight every other row in openoffice calc code#
I hope the source is well documented to let you find the color definitions, if you like to change them -)Ĭopy the code to a module in your STANDARD library of Basic code, to be available to all CALC documetns. I've written a macro in StarBasic back in 2004, which applies alternating colors to used cells (still working with LO 5.2.2.2 i use as of today).