08:16
Faizan
Google Docs are a set of productivity programs including a word processor, spreadsheet program and presentation program, that are available online for free. Google allows multiple people to work on a document at the same time, sending the changes to each person in real-time. The original spreadsheet program did not include a way to filter the spreadsheet, which just narrows down the visible data on the spreadsheet, but the feature was added in later versions.
Visit the Google Docs website and log in with your email address and password, if necessary. Click on your desired spreadsheet from the list in the middle of the screen or click "Create new" and choose "Spreadsheet."
Click on any cell within your data field. The filter option will not become available until your worksheet has data in it, so you will need to add data to the sheet if it is blank. If you just want to filter a small section of your worksheet click and hold the mouse button on the top-left cell in your desired section. Move your mouse to the bottom-right cell and release the button.
Click the "Data" menu at the top of the spreadsheet. Select "Filter" from the list of options in the drop-down menu. A small drop-down arrow will appear in the first selected cell in each column.
Click the drop-down arrow over the column that you want to use the filter on. Click an individual item from the list that appears to remove that item from the spreadsheet. You will see the check mark next to the item disappear, signifying that it is filtered out. You can quickly select or deselect multiple items by clicking "Select All" or "Clear," respectively. The filter menu also has options that will sort your information. Be aware that when you click one of the sort options the window will close without applying any of your changes to the filter.
Click "OK" to close the window and show your changes on the worksheet.
Visit the Google Docs website and log in with your email address and password, if necessary. Click on your desired spreadsheet from the list in the middle of the screen or click "Create new" and choose "Spreadsheet."Click on any cell within your data field. The filter option will not become available until your worksheet has data in it, so you will need to add data to the sheet if it is blank. If you just want to filter a small section of your worksheet click and hold the mouse button on the top-left cell in your desired section. Move your mouse to the bottom-right cell and release the button.
Click the "Data" menu at the top of the spreadsheet. Select "Filter" from the list of options in the drop-down menu. A small drop-down arrow will appear in the first selected cell in each column.
Click the drop-down arrow over the column that you want to use the filter on. Click an individual item from the list that appears to remove that item from the spreadsheet. You will see the check mark next to the item disappear, signifying that it is filtered out. You can quickly select or deselect multiple items by clicking "Select All" or "Clear," respectively. The filter menu also has options that will sort your information. Be aware that when you click one of the sort options the window will close without applying any of your changes to the filter.
Click "OK" to close the window and show your changes on the worksheet.
Posted in: google
