Insert Multiple Rows Excel For Mac

Inserting multiple rows 'the Excel way' If you want to insert multiple rows at once the standard procedure is to first select multiple rows and then use the 'Insert' command. Macos high sierra. For example if you want to insert 10 rows between A1 and A2, you first have to select rows 2:11 and then insert the rows. Inserting multiple rows 'the easy way' The above solution works for small amount of rows.

However if you need to insert for example 800 rows this is not a workable solution. Therefore I have written the following macro which lets you choose the amount of rows to insert. Sub sbInsertMultipleRows() ' Insert multiple rows at once. Rows are inserted above the ' currently selected row/cell Dim lNewRows As Long Dim lCurrentRow As Long ' detect if current selection is a row or cell If UCase(TypeName(Selection)) 'RANGE' Then MsgBox 'Please select an initial row or cell to insert rows above.' , _ vbInformation Exit Sub End If ' Let user choose an amount of rows to insert: lNewRows = Application.InputBox('Number of rows to insert', _ 'Insert multiple rows', 1,,,,, 1) ' Cancel if amount is 0 or user choose to cancel: If lNewRows. • Search • • Recent entries • • • • Categories • (218) • (5) • (1) • (12) • (1) • (44) • (12) • (88) • (47) • (15) • Archives • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • ASAP Utilities • • • • Excel blogs • • Excel Discussions • • • Excel sites • • • • • • • • • • • • • • • • Interesting sites • • Other Excel Add-ins • • • • • • • Troubleshooting • • • Meta • • • •.

Note: In Mac 2016, this shortcut was changed to Control Shift + (same as Windows), and now control + I changes text to italic. In previous Mac Excel versions, Control + I inserts a row (when a row is selected) or brings up the Insert Cells dialog when the selection does not include an entire row. Portable monitor for mac mini.