![]() Mostly we will be using the number pad for inserting numbers. Select everything in your spreadsheet except column and row headings. Press Shift + Spacebar to select the entire row. (keyboard shortcut: k, Enter) Delete the entire row. To unhide a column, select the column and press ‘Ctrl + Shift + 0’ (‘^ + Shift + 0’ for Mac). ![]() Then (2) right-click anywhere in the selected area and (3) click Delete Row. Right-click on any selected cell and select “ Delete row ”From the context menu or … Right click ➜ Delete Home tab ➜ Delete ➜ Delete Sheet Rows Ctrl + – keyboard shortcutRight click ➜ DeleteHome tab ➜ Delete ➜ Delete Sheet RowsCtrl + – keyboard shortcut Select the Blanks radio button on the Go To Special window. ![]() Once done, the selected row gets deleted & now we can get it over with. ![]() Highlight all the cells you want to filter. I'm sure you'll find many of them useful. Double-click the sheet name on the Sheet tab to quickly rename it. Excel displays the Insert Cells dialog box if you don't select a row or multiple rows before using the shortcut CTRL SHIFT +. Right-click and choose Insert from the shortcut menu. If you have not selected entire rows/columns, the Delete Cells dialog box will prompt you for clarification. But in VBA, we have done it by writing a code for it.
0 Comments
Leave a Reply. |