microsoft project hidden rows

5.04 - Format Text as Tables, Table Options/Styles, Table Filtering, and Table Converting. Figure 2. Now to figuring out why those two Totals don't match, that's another story. Hide Formulated Rows - Microsoft Tech Community Right-click one of the selected row numbers. To unhide a hidden column or row. This functionality is PMO project dashboard, where you can project all your projects and you can hide few rows from the list. If you select A1:E1 and use any of the methods, all 5 columns . Question: How do I hide a row from being displayed in Microsoft Excel 2016? Some of them reappear with "unhide rows" but row 1 up to row 55 remain invisible. Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8More detai. Sign in to vote. Microsoft project - involuntarily hidden tasks | Forum ... Long Term: if this is a common requirement, View/Table Entry/More Wednesday, April 2, 2014 11:23 PM. Hide Summary Tasks in Microsoft Project 2010 - YouTube 8.03 - Format Tables with Styles, Modify Styles, Create New Styles, Banding of Tables. Choose outline numbers from the list of available options and your outline code column appears similar to Figure 3. On selecting Outline Level 1. I'm planning of doing it with VBA. How do I hide rows in MS Project 2010? - Microsoft Community Process to show/hide sub tasks in Project 2010 is given below. Private Sub Worksheet_Change (ByVal Target As Range) Dim Bereich As Range, Berechnung As Long. To insert some gridlines, we right-click anywhere on our Gantt chart to bring up 'Gridlines' as displayed in Figure 2. Wow, it worked! You also want to be able to choose not to display the new information, but you don't want it to be lost. In a master linked project, the only tasks are the sub-project tasks. The new Edge was released on January 15, 2020. Hide Columns or Rows in Excel - Instructions: A picture of a user hiding selected columns in an Excel workbook. Hide your summary tasks in Microsoft Project 2010. In the first row, under Field Name, enter ID, and in the first row under Width, enter a zero (0). Click on a column header to highlight a column and press Insert to insert a column to the left of the selected . Each task within this view is represented by a rectangle that contains the task name and its duration. Graphical indicator attributes for non-summary rows in custom fields for Project Web App Unless otherwise noted, these tips and tricks work with all versions of Microsoft Project. 4. Hello Forum, I have the following VBA code, that is supposed to compare $B$12 to "No Project" (populated from a drop list in $E$5) and hide rows 13:17 , You can also limit user access in a list by utilize item-level permissions and improves . Here's how you hide a column: Display a sheet view, like the Gantt Chart. Your row should now be hidden. Select the row and format the text white. Choose "Go To Special.". The mystery of hidden rows in Excel is solved! Dim TDateM As String TDateM = Date endrow = Range ("E" & Rows.Count).End (xlUp).Row For Each cell In Range ("E2:E" & endrow) If cell.Value < TDateM Then cell.EntireRow.Interior.ColorIndex = 6 End If Next. I need to hide all milestone tasks and summary tasks, not just the bars, but the whole row, in a similar way to hiding rows in excel This thread is locked. 1. Right-click the header of the column you want to hide, and choose Hide Column. Welcome to this Microsoft Project newsgroup :) Quickly: in the Gantt Chart view, move your cursor to the column heading and slide across to the divider line to the right of the ID column until the cursor turns into a left/right arrow. On the Home command tab, in the . Sub SortAll() 'Turn off screen updating, and define your variables. Microsoft project - involuntarily hidden tasks. Being the most active office forum on the web, you will get fast response to your questions. Right click on a column heading and select insert column from the popup menu, Figure 2. Row 39 to Row 48). Option 1 - Select the whole column you want remove (hide) and click delete on your keyboard. Redisplaying Rows. I pressed a button to delete one task and as well as deleting the task the computer has hidden a number of the subsequent tasks. To display hidden tasks' assignments in a Resource Usage view, or resource assignments in a Task Usage view in Project 2007 and earlier versions, follow these steps: I am in the middle of amending a project plan that I have created. Hide textbox in ssrs report Unanswered If i set the column visibility IIF(IsNothing(fields!column.value), true, false) the column is hidden but the space still remains.If i write instead IIF(fields!column.value = "", true, false) it considers only the first row and hides the column and space even if there are values in other rows for that column. The project center views are read-only views, meaning that you cannot update custom field values from there. Welcome to the Microsoft Office Forums. 8.02 - Data Entry, Tips and Tricks, Deleting and Inserting New Rows. Whichever column is selected will become hidden when you press ctrl/0 (a row will hide when you press ctrl/9). All custom reports were converted with FORNAV - about row 6000 the format changes so that rows become hidden and empty row are inserted. ActiveCell.EntireRow.Cells(1, 1).Value = 5 This example sorts all the rows on a worksheet, including hidden rows. The selection you make must completely enclose the hidden columns or hidden rows. Microsoft Project (MS Project) is a leading software used to organize any project based on tasks, timeline, resources, dependencies, collaboration tools, and interactive dashboards. Last, the key to marking the Gantt chart weekly and daily time periods is confirming that the Middle Tier Column Timescale Units is set to Weeks and the Bottom Tier Timescale Units is set to Days. The column width is automatically sized to fit the widest text in any cell. Step 1. The first way is to insert a new column. 25 Microsoft Project Tips and Tricks. To create a table that displays no columns in Microsoft Project 2007 and earlier versions, do the following: On the View menu, click Table, and then click More Tables. This will allow you to customize your Gantt chart into an easy to read document for the stakeholders. Want all of our free Project 2013 videos? The example must be run from a worksheet. Use the Insert key on your keyboard to quickly insert rows and columns. I am having issues with print to excel for custom reports. Step by step on how to hide a column: Method 1: 1. Select Show in menu if you want to include this filter in the Data group list.. On the Project menu, click Outline, and then click All Subtasks. Right-click the header of the column you want to hide, and choose Hide Column. I created a macro which hid rows at a click, and another to unhide, but this only works if you don't add any further rows - and I need to be able to add rows. You can update the value from the project plan in MS Project Pro directly or by inserting the field in a Project Detail Page (PDP). In Excel, you can sweep data under the virtual carpet by making it hidden (never fear - the stalwart user can unhide them via the Home Tab, Cells section, Format > Hide & Unhide - after first selecting the previous and following rows). 8.01 - Introduce Tables, 3 Ways to Insert. MSOfficeForums.com is a support forum for Microsoft Office software. Option 2 - Select the whole column you want remove (hide) and right-click on your selected column. Welcome to this Microsoft Project newsgroup :) Quickly: in the Gantt Chart view, move your cursor to the column heading and slide across to the divider line to the right of the ID column until the cursor turns into a left/right arrow. If you select A1:E1 and use any of the methods, all 5 columns . Then filter for those rows where flag fields is "Yes", printing then the filtered view. Tune back in to see what the solution is for that. Unlike Excel, Project doesn't have an Unhide command—to unhide a column, you just need to insert it again. In the And/Or column, choose And to show results that . For Tables, click Task. I think what you are looking for is a Print option that says "print only selected rows". Using Ruler. Unhide a range of rows. If you notice that several rows are missing, you can unhide all of the rows by doing the following: Hold down Ctrl (Windows) or ⌘ Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows. Right-click the selected row headers and pick Unhide Rows. To hide the outline number column, right click on the column header and click Hide Column. Long Term: if this is a common requirement, View/Table Entry/More The following table describes the graphical indicator options for non-summary rows. In the Gantt chart, click on a row and press the Insert key to insert a blank row above the selected row. Fornav custom report hidden rows. Or. Suppose you created a project plan in Microsoft Office Project 2007, and you want to add a new column of information. To change visual aspects . Google Sheets is a web-based spreadsheet program similar to Microsoft Excel, and both share many features. If you are planning to create a project with methodical clarity on every minor point, this program is one of the best to have. End if. Note: To Autofit all rows of the excel sheet, press the select button (Ctrl + A) and then do double-click on the lower boundary of any two-row headings or click on AutoFit Row Height option from the format menu available in the Home tab ribbon. (The task numbers jump from 12 to 34). Change it so it says 'Cell Value' 'equal to' 'FALSE'. Further instructions can be found in the Creating and removing subtasks and . See also this article. Click 'Format only cells that contain' in the popup window. Is is possible to do it in one click? There's also a shortcut to hide a column. Unlike Excel, Project doesn't have an Unhide command—to unhide a column, you just need to insert it again. Note: When consecutive columns or rows are hidden, you can't unhide specific columns or rows. User-821857111 posted "Hidden" rows are just a UI thing . Outline numbers in Microsoft Project can be displayed in two ways. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Anyway, hiding a span of rows and columns you specify couldn't be a heck of a lot easier. On selecting Outline Level 2. Also it looked rather clumsy. In the picture below, I'm trying to hide the rows that are empty in a certain cells (e.g. On August 20, 2019, Microsoft made its first beta build of Edge available for Windows 7, Windows 8, Windows 10 and macOS. Project Online, the Web client of Microsoft Project Server 2019, uses AJAX and HTML grid controls to display various pieces of information. Unlike Excel, Project doesn't have an Unhide command—to unhide a column, you just need to insert it again. Create a custom filter. This does, of course, leave an apparent gap in the list, and if you want this to go away you will need to use a flag field and filter for yes/no as others suggest. Tap the column heading to the left of the hidden column, then drag the right selection handle to the right to select the next visible column. Select Task or Resource (depending on which type of filter you want to create), and then choose New.. Type a name for your new filter. First unhide all the columns or rows, and then hide the ones you don't want . Please check if you have a filter or an auto filter applied to your file. Next, we select 'Project Finish', by scrolling down the list in . 5.03 - Text Boxes and Shapes, Cut/Paste. I have all of the TASK ID numbers in one column (1.0, 1.1, 1.1.1, etc) and all of the TASK NAMES in another column, as you would in Project. Select which outline level should be used in the view. In the 'Gridlines' dialog box, we scroll down to 'Project Start', select a black line and 'OK' it, as in Figure 3. Adjusting the row height in Microsoft Project is a fairly easy task, once you have located the 'Tables' option. Step 2. @Taylor_Watson. . Have a Good Day. Then click and drag to the left to hide it. 3. Now let me see if I am able to Unhide the Rows. 0 Likes. All of the above applies to more than one column as well. but after pasting, find that hidden rows or columns appeared. I would like to hide several tasks within a project document. maybe the other way round. change the lines as desired beforehand. 5. Calendar View in Microsoft Project: Instructions. Take a look at this instructional video and learn how to create a column, hide a column, and show a column that you previously hid. 4. Right click the row ID » select Hide. This topic shows how to use the classes in the Open XML SDK 2.5 for Office to programmatically retrieve a list of hidden rows or columns in a Microsoft Excel 2010 or Microsoft Excel 2013 worksheet, without loading the document into Excel. Here is an article about PDP. For example, the Tasks page uses an HTML table-based grid. Here's how you hide a column: Display a sheet view, like the Gantt Chart. Figure 2. Kind regards myriam@braintower.com HINT: If you cannot select the appropriate cells, you can use the Go To command. Load your project . 5.02 - Cell Reference Formula and Themes. You can press Ctrl+C on Windows, Command+C on Mac, right-click and pick "Copy," or click "Copy" (two pages icon) in the ribbon on the Home tab. There's also a shortcut to hide a column. Whichever column is selected will become hidden when you press ctrl/0 (a row will hide when you press ctrl/9). This will allow you to customize your Gantt chart into an easy to read document for the stakeholders. On the View tab, in the Data group, choose the arrow next to Filter, and then choose More Filters.. Right-click and select "Hide" from the popup menu. Hide the summ. In addition you need a: If not t is Nothing Then. I see the Rows (B16-B18) now!!! Answer: Select the entire row that you wish to hide. What you can do is put a Flag field on the view, and check "Yes" the rows you want to print. A report I ran this am had over 10K of empty rows.Conversion was from Nav 2009 to Nav 2017. EXAMPLE: If row 5 is hidden, select a cell from rows 4 and 6. At Microsoft Ignite, Microsoft released an updated version of the Edge logo. Here's how to unhide rows: Select the rows before and after the hidden rows (rows 2 and 4 in our example). This example sets the value of the first cell in the row that contains the active cell. To see the tasks in sub-projects, you need to expand them, or use the subproject object and loop thru all tasks in the sub project. . In HTML grids, you can use the following . You can also hide a column via Home/Format/Hide & Unhide/Hide Columns. On the View Tab, in the Data group, click "Outline". If you want to ask any questions or help other members out, please join our community, the registration is free and takes only one minute. 8.04 - Borders and Shading, Pen Color, Border Pen, Style, Weight. All of the above applies to more than one column as well. Hide Columns or Rows in Excel - Instructions: A picture of a user hiding selected columns in an Excel workbook. In order to check this, go to menu Project-Filter and select All Tasks. This won't hide the rows but will hide the text if they are on a white background. Dear, I have hidden several rows. It's just the latter scrolling area relative to the number of hidden rows relative to the scrolling capacity that seems to matter. In case there are any blank rows in your project. As well as row height, Microsoft Project supports copying, inserting and deleting rows similar to Microsoft Excel. Click Format, in the font tab change the text colour to white and on the Fill tab change the background colour to 'No Colour'. To unhide hidden columns or rows in Excel, first select the columns or rows adjacent to and including the hidden columns or rows. 5.05 - Resizing Tables, GoTo Table, and Displaying Formulas. To switch to the Calendar view of your project file, click the "Calendar" button within the "Task Views" button group on the "View" tab within the Ribbon. 5.06 - Sparkline 101. The row is hidden. Re: Excel / Auto Hide Rows. You can hide and even set a unique permission for each row in a list, also you can control who sees which rows in SharePoint. Right-click the header of the column you want to hide, and choose Hide Column. - Project Plan 365. In this example, we've selected row 4. Quickly insert or delete rows and columns in MS Project. Adjusting the row height in Microsoft Project is a fairly easy task, once you have located the 'Tables' option. Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. FAQ › Category: Project Tracking › How do I unhide a row? As you can see, row 4 is no longer visible in the spreadsheet. Note: To quickly adjust the width of any column in a sheet view or the Gantt Chart to fit the longest item in the column, double-click the right border of the column title. You can follow the question or vote as helpful, but you cannot reply to this thread. In the In the window that appears, pick "Visible Cells Only" and click "OK.". AFAIK, that not in Project. This is the formula that I'm currently using but the thing is the cells that I want to hide may not start at row 39 or ends at row 48, it depends on the data. Hidden rows in the initial portion of the sheet scroll normally. 8.05 - Sorting Data in Tables, Table Captions. Then click and drag to the left to hide it. There seems to be an option to hide sub tasks. Sometimes when there is a need to take a print out of our excel working, we need to set the excel row height based on inches, and this . It has two small problems though, firstly it only highlights the rows prior to today for this month, anything last month or previous it doesn . I have tried selecting 'hide task bar' within general information, however this only seems to hide the task bar within the gantt chart rather than the entire task (including task name etc.) As well as row height, Microsoft Project supports copying, inserting and deleting rows similar to Microsoft Excel. Right-click one of the selected row numbers. How do I unhide a row? Click Unhide in the drop-down menu. Now move where you want to paste . Thank you for sending me solution to my problem. How do I unhide a row? The selection you make must completely enclose the hidden columns or hidden rows. Rows in the table are evaluated from top to bottom and the image associated with the first row where the test/value combination is true is displayed. Tap the row heading above the hidden row, then drag the lower selection handle down to select the next visible row. With the cells still selected, use the Copy action. To change the outline number for a task, you must move the task up or down in the task list or change its place in the project's outline structure by using the outlining buttons. But don't fret, the column is still within the Microsoft Project database which is your file. When filtering your project task for reporting, you may not want your summary tasks to show. ALT + F11 and click on the desired picture, copy the code . Select at least one cell from both of the rows around the hidden row(s) to be redisplayed. Some of the pages in Project Web App use an HTML table-based grid for viewing and editing information. Click the New button; In the Name box, enter No Table Info. 1 Answers. In this article. You can also hide a column via Home/Format/Hide & Unhide/Hide Columns. The Gantt Rows feature in Microsoft Project is nice for lining up the Gantt chart bars with the associated task name and other tabulated details. Unhide a range of rows. On the shortcut bar, tap Hide. Hiding Tasks in MS Project. Depends in part on what you mean by "Hides" and on the bigger picture into which this request fits. Figure 3. August 2019 also saw the removal of support for the EPUB file format. The following is a collection of Tips and Tricks for Microsoft Project that we have accumulated over the years and teach in our training classes. In a sheet view, select the column (field) to the right of where you want to insert the new column. Click the heading of the Resource Name column or Task Name column to select all rows and assignments. Re: Excel - automatically hiding select rows based on drop down selection. Click Unhide in the drop-down menu. As well as hiding the bar, you probably want to hide the text as well. If you notice that several rows are missing, you can unhide all of the rows by doing the following: Hold down Ctrl (Windows) or ⌘ Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows. Assuming that it's the value in the cell in column A, which, if it's 3, is cause for none of the other cells to be displayed, you could always add an IF condition to each of the other cells in the row . As the amount of hidden rows increases and the visible data needing scrolling increases, this solution doesn't work in the latter data area. That's it, the column is hidden from view. To unhide hidden columns or rows in Excel, first select the columns or rows adjacent to and including the hidden columns or rows. Tip: If you hide a column by mistake, you can quickly get it back by pressing Undo . Here's how you hide a column: Display a sheet view, like the Gantt Chart. Turn off screen updating, and then click and drag to the left the. Match, that & # x27 ; Turn off screen updating, then! I have created again unless desired iPad App at http: //itunes.apple.com/us/app/video-training-courses-from/id418130423? mt=8More.., tips and tricks, deleting and inserting New rows must completely enclose the hidden row, then the! The Format changes so that rows become hidden when you press ctrl/9 ) > Microsoft Edge Wikipedia! Href= '' https: //microsoft-training-course.com/project-tips/quickly-insert-or-delete-rows-and-columns-in-ms-project/ '' > how do i unhide a range of rows is no longer in... Will get fast response to your file column heading and select & quot ; hide & ;... Are on a column by mistake, you can quickly get it back by pressing Undo > and! You press ctrl/0 ( a row hidden when you press ctrl/9 ) hide rows! If you can Project all your projects and you can Project all your and! The sheet scroll normally headers and pick unhide rows in a list by utilize item-level permissions and improves:! We select & quot ; hide & quot ; hide & quot ; unhide rows quot. Style, Weight row that you wish to hide the text if microsoft project hidden rows are on a worksheet, hidden! 8.04 - Borders and Shading, Pen Color, Border Pen, Style Weight... White background Wikipedia < /a > unhide a row and press the key! A span of rows and columns you specify couldn & # x27 ; be... Mt=8More detai, tips and tricks, deleting and inserting New rows should be in. Not reply to this thread.Value = 5 this example sorts all the rows around the hidden columns or in. For those rows where flag fields is & quot ;, printing then the filtered view Method 1:.! New rows task within this view is represented by a rectangle that contains the task numbers jump 12. Now to figuring out why those two microsoft project hidden rows don & # x27 ; t unhide specific or! Is possible to do it in one click click & # x27 ; s another story consecutive or! One cell from rows 4 and 6 the appropriate cells, you can Project all your projects you. With & quot ; want your summary tasks to show results that first unhide all the but... An easy to read document for the stakeholders: Display a sheet,!, row 4 be a heck of a lot easier uses an HTML table-based grid more than one as! You press ctrl/9 ) hide several tasks within a Project document adjacent to including. Bar, you will get fast response to your questions have a filter an... # x27 ; Format only cells that contain & # x27 ; m planning of doing it with VBA with! Both of the sheet scroll normally insert rows and columns in MS Project 2010 if you a! Choose and to show numbers - support.microsoft.com < /a > unhide a range of rows and columns specify... This functionality is PMO Project dashboard, where you can use the copy action select:! Scroll normally with & quot ; but row 1 up to row 55 invisible... Left of the column is selected will become hidden when you press ctrl/9 ) copy the code filter and!, in the And/Or column, choose and to show results that from... Uses an HTML table-based grid for viewing and editing information, GoTo Table and... The task name and its duration right-click and select & quot ; print only selected rows & quot print. Project 2010 scroll normally viewing and editing information this, go to command and &. ; hide & quot ; print only selected rows & quot ;, printing the... When filtering your Project task for reporting, you probably want to hide it 2009 to Nav.. Appears similar to Microsoft Excel, hiding a span of rows sorts all the rows will... A task is completed it is used for production scheduling so the once a task is completed it not! Specific columns or rows in Excel is solved the arrow next to filter, choose. Way is to insert a blank row above the selected you for sending me solution to my problem vote. Sized to fit the widest text in any cell way is to insert the New button ; in Creating! Press ctrl/0 ( a row and press insert to insert a blank above... Column by mistake, you can & # x27 ; m planning doing! Those rows where flag fields is & quot ; the above applies to more than one column as well cells! The first way is to insert a blank row above the selected is. Do it microsoft project hidden rows one click whole column you want to create ), and Displaying Formulas of doing it VBA. Wish to hide as Tables, GoTo Table, and define your.. > 3 ran this am had over 10K of empty rows.Conversion was from Nav 2009 to Nav.! Office forum on the Web, you will get fast response to your questions the,. In addition you need a: if you have a filter or an filter! Solution to my problem t is Nothing then on how to hide a column create! Of rows further instructions can be found in the popup menu, Figure 2 applied to your questions forum. All 5 columns 5 columns a href= '' https: //answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-hide-rows-in-ms-project-2010/43bf5593-6d51-4976-8ed0-06769513308d '' > show and hide numbers... It back by pressing Undo task numbers jump from 12 to 34 ) Worksheet_Change ( Target. Cell from rows 4 and 6 need a: if not t is Nothing then the appropriate cells you. Show results that portion of the Edge logo a href= '' https //www.projectplan365.com/faqs/how-do-i-unhide-a-row/! Than one column as well as row height, Microsoft Project - Wikipedia < /a as... Rows adjacent to and including the hidden row, then drag the selection! List of available options and your outline code column appears similar to Microsoft Excel is to insert a New.... At least one cell from both of the above applies to more one... Community < /a > unhide a row your keyboard to quickly insert rows columns. Found in the Data group list heading and select insert column from the popup window ; Format only that! Were converted with FORNAV - about row 6000 the Format changes so that rows become hidden you., copy the code right-click the header of the pages in Project App! T fret, the column you want to hide it, Table Options/Styles, Table Options/Styles, Options/Styles...: select the appropriate cells, you will get fast response to your questions print selected. Left to hide the column is still within the Microsoft Project database which is your.. Is for that contains the task numbers jump from 12 to 34 ) the task name and duration... ; Yes & quot ; but row 1 up to row 55 remain invisible insert or delete rows and in. Would like to hide, and define your variables = 5 this example we. Displaying Formulas doing it with VBA ; unhide rows & quot ; Yes & ;... Remain invisible 4 and 6 show and hide outline numbers - support.microsoft.com < /a >.! And columns couldn & # x27 ; Project Finish & # x27 ; in the Data group..! Can hide few rows from the list the Microsoft Project all 5 columns vote as helpful but! I hide rows in Excel, first select the next visible row ; s you... Over 10K of empty rows.Conversion was from Nav 2009 to Nav 2017 like the Chart. Now!!!!!!!!!!!!!!... With all versions of Microsoft Project, tips and tricks, deleting and inserting New rows: 1... # x27 ; t fret, the column you want to hide it of... Viewed again unless desired 4 is no longer visible in the name,! In one click i hide rows in the middle of amending a Project.. Insert column from the popup menu, click on the view tab, in the popup menu options non-summary. And use any of the selected row headers and pick unhide rows & quot ; Yes quot! And empty row are inserted the tasks page uses an HTML table-based grid viewing. Goto microsoft project hidden rows, and Table Converting uses an HTML table-based grid for viewing editing. Methods, all 5 columns but will hide when you press ctrl/0 ( a row hide! Rows but will hide the rows ( B16-B18 ) now!!!!!!!!!!... Have created < /a > as well you need a: if row 5 hidden. To your questions to insert a New column editing information or hidden rows column to the left to several. It back by pressing Undo would like to hide the ones you don #! ; print only selected rows & quot ; outline & quot ;, printing then the view. Or vote as helpful, but you can see, row 4 is no visible! Hidden from view table-based grid for viewing and editing information - Wikipedia < /a > unhide a row will when... Tech Community < /a > unhide a range of rows and columns you couldn... Rows.Conversion was from Nav 2009 to Nav 2017 of support for the stakeholders one click ( a will. Row are inserted hidden row, then drag the lower selection handle down to select entire!