![]() To select multiple non contiguous sheets: Any actions that you perform will now affect all highlighted sheets. Hold down the Shift key and click on the sheet tab.Īll the tabs between these two sheets will turn white.Move the mouse pointer over the last sheet tab.Click on the sheet tab for the first sheet.It can be advantageous to select multiple sheets at times when you want to make changes to many sheets at once.Ĭlick on the sheet tab for the sheet you want to select. You can select either one or multiple sheets. You can also use the keyboard to select the entire sheet by pressing Control+A. To select the entire sheet, click on the small box between the column A header and the 1 row header. Click on the headers for all of the subsequent columns or rows.To select multiple columns or rows that are not contiguous: Click on the header for the last column or row in the group.Click on the header for the first column or row in the group.To select multiple columns or rows that are contiguous: To select a single row, click on the row header. To select a single column, click on the column header. If you use this method, be sure to change EXT back to STD or you may find yourself extending the selection unintentionally.Įntire columns and rows can be selected very quickly in Calc. This method works best when adding single cells to a range. You can also select a noncontiguous range of cells by first clicking twice in the STD field on the status bar to change it to ADD, before clicking on a cell that you want to add to the range of cells in step 3 above. Move the mouse pointer to the opposite corner of the range of cells.Click in the cell which is to be one corner of the range of cells.To select a range of cells without dragging the mouse: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |