Did you know there are hundreds of shortcut buttons in Excel that you can place on the ribbon? These shortcut buttons can save you countless clicks in Excel! Today, I would like to tell you about the “Delete Rows” button. I find myself using this button nearly every day and it saves me so much time.
To use the button, you must first add it to your ribbon in Excel (This is the bar at the very top of the page – it typically has the “Save” icon, the “Undo” icon, or the “Print” icon.) On the far right, you will see a down arrow that offers more options. Click this arrow and select “More Commands….”.
Under the “choose commands from” box, select “All Commands”. Find the command called, “Delete Sheet Rows” and select it. Click the Add >>> button. Click OK. When you click OK, you will notice a new icon in your ribbon. It looks like some brackets with an “X” beside them.
Now comes the fun part – the official test! Key in some rows of data into your spreadsheet. Assume you have two rows you don’t want. Simply select any field within the row and hit the new “Delete Sheet Rows” icon. I like using this button because it saves time by not highlighting the entire row, right clicking, and then deleting. It’s as easy as the click of a button!
Watch Out: If you have hidden rows and they are selected, they will be deleted, too.
If you are an Advocate Capital customer and need help preparing or manipulating data in the Excel application, feel free to contact me at [email protected].
Advocate Capital, Inc. offers more than case expense tracking. We pride ourselves on being the state-of-the-art resource for our clients in many technology fields. Contact us for help with Excel, QuickBooks, AdvoTrac® and many other applications!
Photo Credit: Hongqi Zhang