You probably know the quickest way to select a column of data in Excel is with the shortcut CTRL + Shift + ⯆. But what do you do if that column includes blank cells and you’d like to highlight the entire column of data? CTRL + Shift + down arrow key will stop the moment it comes across a blank cell. This is often a very annoying problem especially if it’s a large data set or there are a lot of blank cells. In this video I’m going to show you a trick which EASILY gets this done. A shortcut which is often used is CTRL + End which jumps to the end of the data set. However, that may not always work if there is some additional input in other cells outside of the data set. Here’s the Excel Keyboard Shortcut(s) to Select Column with Blank Cells: A better alternative is to use the Name Box in Excel. Just put in the range you want and use a random, very high “TO” value where you know you will not have any data anymore, e.g. B1:B10000. Press Enter. This will highlight the entire range. Then use the short cut CTRL + SHIFT + ⯅. This will highlight the data set including the blank cells. The same thing can also be done with just the keyboard, no mouse. Press CTRL + G to get to the Name Manager. In the reference field type in the range, e.g. B1:B10000 and press Enter. Then use the short cut CTRL + SHIFT + ⯅. This will highlight the data set including the blank cells. Course Length: 6:02 minutes Source: Leila Gharani
Most frequent questions and answers
Co-operative education is a three-way partnership between the university, students and employers. Students apply their classroom knowledge in a series of four-month work experiences. You, the employer, enhance a student’s education, while reaping the unique benefits of CO-OP employees.
- Year-round access to well-motivated, qualified employees.
- Access to potential full-time staff in a controlled environment, reducing your costs and risks.
- Access to a cost-effective source of temporary employees for peak periods or special projects.
- A say in what students learn by working with the university.
- Promotion of your organization as one that believes in developing the potential of young people.
- Access to a great pool of French-speaking, English-speaking and bilingual students.
Most work terms run at least 15 weeks, or four months. They can be no shorter than 13 weeks. Some master’s students, as well as some science and engineering students, are available for 8 or 12 months’ work terms.
All jobs are reviewed by a CO-OP Program Coordinator, and only those providing students with work experience related to their professional development are approved. Administrative activities involved in a job should be less than 10% of the entire workload.
When you first contact SSC, you are assigned one of our Program Coordinators, depending on your discipline of interest. This person is your main contact in our office. As you move through the recruitment process, you also work with a representative from CO-OP Administrative Services, who assists with job posting and interview scheduling.