In other situations, however, you may want to highlight other data, and for this, you will need to remove the current format first. When working with large Excel worksheets, it's a common practice to apply different formatting options to make data relevant to a particular situation stand out. Click the arrow next to one of the selected row numbers or column letters, then choose Add Rows Above or Add Rows Below (or Add Columns Before or Add Columns After).ĭelete multiple rows or columns at once: Command-click the rows or columns, click the arrow, then select Delete Selected Rows or Delete Selected Columns.This short tutorial shows a couple of quick ways to remove formatting in Excel worksheets. Insert multiple rows or columns at once: Anywhere in the table, select a number of rows or columns equal to the number of rows or columns you want to insert. You can also move the pointer over the number or letter, for the row or column you want to delete, click the down arrow, then select Delete Row or Delete Column. You can also move the pointer over the number or letter, for the row or column next to where you want to add, click the down arrow, then select where to add the row or column.ĭelete a row or column anywhere in the table: Control-click a cell in the row or column you want to delete, then select Delete Row or Delete Column. Insert a row or column anywhere in the table: Control-click a cell, then select where you want to add the row or column (above, below, before or after the selected cell).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |