EXCEL: How to Turn the Heading Row “On” or “Off”

When we work in Excel (Spreadsheets) whether for numbers or data management, it's always best to be sure that we've typed in a heading row, so that when we sort a column - it will be easier to understand the meaning of the data. By default, the value in the heading is not included in the sort operation.

<div>

&nbsp;</div>

Occasionally, you may need to turn on or off the heading so that the value in the heading is or is not included in the sort operation. Do one of the following:

<ul>

<li>To exclude the first row of data from the sort because it is a column heading, on the Home tab, in the Editing group, click Sort &amp; Filter, click Custom Sort, and then select My data has headers. </li>

<li>To include the first row of data in the sort because it is not a column heading, on the Home tab, in the Editing group, click Sort &amp; Filter, click Custom Sort, and then clear My data has headers.</li>

</ul>

Sorting Data in Excel

Excel makes it very easy to sort data that is entered in multiple columns, by using the SORT buttons (A-Z or Z-A)… So be sure when you are entering your data, to put information in as many individual columns as possible – In my opinion you can never have too many columns to sort data with..

Make sure before you give the command to SORT that you have highlighted the active sheet, so that all information in the columns and rows will then “move” when the information is sorted…

Excel Sort Data by One Column:

• Select all the cells in the list
• Choose Data>Sort
• When the Sort Dialog Box opens, be sure to check off that your list has a “header row” so you will see the data – not the column ID letter
• From the Sort by dropdown, select the column you want to sort. Note: If the dropdown is showing Column letters instead of headings, change the setting for My list has, from No header row to Header row.
• Select to sort in Ascending or Descending order

Excel Sort Data by multiple Columns:

Such as when we are entering data for our contacts to prepare a mailing list – we might want to sort by Last Name, First Name and then Spouses Name which are in 3 three columns. So we will sort it all at once, but giving different levels 1 would be Last Name; 2 would be First Name and then last the Spouses Name…starting with the most important sort.

• Select all the cells in the list.
• Choose Data>Sort
• When the Sort Dialog Box opens, be sure to check off that your list has a “header row” so you will see the data – not the column ID letter
• From the Sort by dropdown, select Last Name.
• From the Then by dropdown, select First Name.
• From the Then by dropdown, select Spouses Name.
• Click OK

Note about Excel 2007 and 2010

• The SORT BUTTON is on the HOME TAB to the far right in the Editing quadron and also in the DATA TAB in the Sort & Filter quadron
• When the Sort Dialog Box Opens you will see one SORT field, but you can add as many levels for sorting as you would like.…

Working With Bookmarks/Favorites In Chrome by Google

FOR THOSE OF US WHO USE “CHROME" GOOGLE'S WEB BROWSER, use the bookmark manager to organize your bookmarks and folders. Remember "Website Favorites" are called "Bookmarks" in Chrome & other browsers.. To open the manager, follow these steps:

1. Click the wrench icon (in the upper right hand corner of your chrome web page screen) on the browser toolbar. Mac users: If you don't see the wrench icon, go to the menu bar at the top of your screen and click Bookmarks.
2. Select Bookmark manager.

Here are a few tips for using the manager:

• Move bookmarks or folders around
  Simply click the item you want to move and drag it to its new destination within the folder list on the left.
• Edit the name or web address of a bookmark, or a folder name
  Select the item you'd like to edit, click the Organize menu, then select Edit. You can also easily edit bookmarks and folders from the bookmarks bar by right-clicking the item in question and selecting Rename.
• Search bookmarks
  Use the search box at the top to quickly find a bookmark within the manager.
• Add a new bookmark folder
  In the folder list on the left, right-click the location where you want the new folder to reside and select Add folder
• Delete a bookmark or folder
  Right-click the item and select Delete.

WORKING WITH FAVORITES IN INTERNET EXPLORER:

To organize your list of Favorite Websites:

If you have added to your list and didn’t put addresses into specific topic related folders you can do it anytime to make it easier to find items of similar interest… To do so…

• Left Click on FAVORITES
• Left Click on ORGANIZE and your list will appear
• To move a web address to a folder, left click on the site which highlights it
• Then left click on “MOVE TO FOLDER”; then left click on the FOLDER to put it in, OR
• CREATE NEW FOLDER” and then repeat the process and “MOVE TO FOLDER”.
• When you are finished left click OK

To alphabetize your Favorite List:

• Left click on FAVORITES on the menu bar (not the toolbar icon)
• Point to and highlight any item on the list – then RIGHT CLICK on that item
• A menu will appear – toward the bottom of the menu – choose “SORT BY NAME”
• Left Click “SORT BY NAME” - all items in your Favorite List are alphabetized
• Addresses not put in specific folders are always at the bottom of the list