Position your active cell pointer at the upper-left. Copy the 6 rows and paste 6 more so that 12 rows are highlighted. To select a large range of cells using the keyboard, follow these steps: 1. The next step could be to us this in a conditional format formula. select Formula is put the following formula into the form: MOD (ROW ()+1,21. Right-click on the fourth row and select Paste Special. Then in Menu>Format>Conditional Formatting>Condition> click the Cell value is button and. (There are ways to do as you asked for using a filter and a. Or an option in the menus for doing that Without such an option, manually selecting each two rows is a very rudimentary approach. Optionally you can select multiple rows or columns. After selecting all the rows in the table, maybe a keyboard shortcut, a hotkey for selecting only the odd rows (or, well, for de-selecting the even rows). Cell A1, then use the format paintbrush to copy the format down. Rightclick the column or row header and a popup menu will appear. Maybe not as nice (and smooth) as in Excel, but it highlights, duplicates. Then, select the first three rows and copy. The next step could be to us this in a conditional format formula. First, manually select and highlight the first three rows. Then right-click on any selected row number and select Insert. You can therefore have up to four portions of the spreadsheet in view at any one time. Here are instructions for a three-row pattern two rows would be similar. Select as many rows as youd like to insert by dragging over the row numbers on the left. The screen can be split horizontally, vertically, or both. The check mark by Freeze will vanish.Īnother way to change the view is by splitting the window-also known as splitting the screen. To unfreeze rows or columns, select Window > Freeze. Now as you scroll around the screen, everything above and to the left of these lines will remain in view. Two lines appear, a horizontal line above this cell and a vertical line to the left of this cell.
0 Comments
Leave a Reply. |