In the Find and Replace window, you can find the special cells.Click the Home tab, in the Editing group, click Find & Select, then click Find.Type the cell/range address in the Name Box and press Enter.With Go To Command, you can select special cells: click Special button, then select one of the radio options: Comments, Constants, Formulas, Blanks, Current region, Current array, Objects, Row differences, Column differences, Precedents, Dependents, Last cell, Visible cells only, Conditional formats, Data validation.Then all cells or ranges of your enter will be selected in the workbook. In the Go To dialog box, type the cell/range address in the Reference box (such as A1:C4,E3:G6).or press Keyboard shortcut: CTRL+G or F5. Click the Home tab, in the Editing group, click Find & Select, then click Go to.Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns) to select the first or last cell in a row or column.Select the first column heading or range of column headings, and then hold down CTRL while you select the other column heading or range of column headings to select Non-continuous columns.Select the first row heading or range of row headings, and then hold down CTRL while you select the other row heading or range of row headings to select Non-continuous rows.Click the first column heading, and then drag to the last column heading to select continuous columns. or click the first column heading, and then hold down SHIFT while you click the last column heading.or click the first row heading, and then hold down SHIFT while you click the last row heading. Click the first row heading, and then drag to the last row heading to select continuous rows.
Drag across multiple row headings to select multiple rows.
Right-click on the group and select the Delete option. To delete multiple spreadsheets at a go, ensure that they are all grouped. You can do this by grouping the worksheets before you print your task, as usual. Printing grouped spreadsheets is much simpler than printing them individually. Note that you can click on the Create a Copy option if you want to duplicate rather than only move the spreadsheets. To do so, take the following steps Ĭreate a group using the methods listed above. Grouping your spreadsheets allow you to easily move them in case they are not in the proper logical order that you would want them to be. Understanding how your spreadsheets work is essential.
Select data in excel for mac how to#
It's not just enough to know how to group and ungroup your spreadsheets. By getting accustomed to the shortcuts, it will be easier to create, edit and even store your workbooks. The first step to owning your workbooks is to learn all the key shortcuts that exist. Apart from grouping and ungrouping your spreadsheets, there are plenty of other things you should learn to help you navigate your workbook and get the best out of them.