Continue scrolling down till you find 'Go To Special.' and add that. No you have the available options for adding to your custom menu.Ĭhange the Choose Commands from drop down list to 'All Commands' then scroll down to the 'Delete Sheet Rows' and add it to the list. Then click Customize (the 5th item down the menu list). Click the Excel Options button in the lower right side of the dialog box. To create a custom toolbar click on the Excel ball in the upper left side of the menu.
PHD can cover this in more detail (he probably already has). I use Excel 2007 so these instructions only apply to that version. By creating a custom toolbar with icons that activate these same commands. So, I created another way by making a custom toolbar. This is a nice trick, but I'm too old to remember function keys and ctrl minus key combinations.
