If additional data is added to the Source table, right-click the Results table, select Refresh and the table is updated instantly with the new data and required rows. The AddRows column is no longer required and can be deleted.
You can also split on both a row and a column.
Select the column to the right of the column where you want to place the split, and use the Split command. You can also split a worksheet on the columns. You can remove the split simply by clicking the Split button again. To split this worksheet as shown above, you select below the row where you want the split – selecting row 13 splits the worksheet below row 12.
Would you like to know how to see his result together with the top 10 finishers at the top of the worksheet?īy splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. You found his name down in row 180 of your spreadsheet. Your friend Tomas finished a 5-K run last weekend, and you want to see the times of the top 10 finishers to compare his time with theirs. Right-click and select Copy from the popup menu, or simply press CTRL+C on the keyboard.This will copy all the visible rows only. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More. Select all the rows in view (except the header row) and press Alt+ (Cmd+Shift+Z on a Mac) so that only the visible rows are selected.