Remove blank cells from data sheet

1. Select the range for which you’ll delete blank cells and shift data left.
2. Press Ctrl+G.
3. Click Special… (lower left of dialog)
4. Choose the Blanks radio button
5. Click OK.
6. All blank cells in the selected range remain highlighted. Now right-click any of the selected blank cells.
7. Choose Delete.
8. Select Shift cells left.
9. Click OK.

• Related Articles

• Deleting a false or dulplicate record via the web application

  If you need to delete a result or record you can do this via the web application. Use the following guide to follow the step by step instructions: Deleting results and records user guide

• Getting started with the desktop application

  The desktop application is installed on your laptop and once you have sync'd your data you can use the application without an internet application. The following guide will show you how to login and the homepage functionality. Getting started with ...

• Editing a child's details

  You can edit a child's details using the desktop and web application. Use the following guides to help you: Editing a child's details on the desktop application Editing a child's details on the web application

• User Guide - Automatic Hearing Test

  The following user guide gives you step by step instructions on how to carry out the hearing screening using the Automatic test. The automatic test is designed to remove screener bias and for those screener's who have limited access to audiological ...

• User guide for the desktop functionality

  Here you can find out how to use the off line desktop application. The guide will show you how to: Login Download and sync data How to select a child How to view tests Where you need to look to see if your audiometer is connected How to locate the ...