How does excel 2007 work

To quickly sum numbers in a column, highlight the cells to be summed and click "AutoSum. The sum will show up in the cell below the selection. Sort or filter data on the "Data" tab. To filter a selection, click a cell and select "Filter. Only cells with that value will be shown. To sort, click on a column and select "Sort. Select the first cell with the number you want add, then drag up to the last number, then go to formulas and click on Auto Sum.

Then select Sum. Yes No. Not Helpful 0 Helpful Not Helpful 6 Helpful 4. Ashley wood. Not Helpful 0 Helpful 0. Include your email address to get a message when this question is answered. Submit a Tip All tip submissions are carefully reviewed before being published. Related wikiHows How to. How to. Co-authors: 5. Updated: March 29, Categories: Microsoft Excel.

Thanks to all authors for creating a page that has been read 73, times. Is this article up to date? Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy.

About This Article. By signing up you are agreeing to receive emails according to our privacy policy. Follow Us. Create forecast charts based on existing data and predict future trends with a simple click. Not applicable. Mobile apps for your devices. New mapping features.

Transform geographic data into professional-looking visualizations in just a few steps. Recommended Charts. Always up to date. Always have the latest Office apps, features, and services. Swipe to view more plans. Ready for Microsoft ? Expand all Collapse all. Microsoft plans include premium versions of these applications plus other services that are enabled over the internet, including online storage with OneDrive and Skype minutes for home use.

Microsoft plans are available as a monthly or annual subscription. How do I know if my computer can run Microsoft ? Is internet access required for Microsoft ? However, internet access is required to install and activate all the latest releases of Office suites and all Microsoft subscription plans. For Microsoft plans, internet access is also needed to manage your subscription account, for example to install Office on other PCs or to change billing options.

Internet access is also required to access documents stored on OneDrive, unless you install the OneDrive desktop app. You should also connect to the internet regularly to keep your version of Office up to date and benefit from automatic upgrades.

To reactivate your Office applications, reconnect to the internet. Will I still have control of my documents with Microsoft ? If you cancel your subscription or it expires, you can still access and download all your files by signing in to OneDrive directly using the Microsoft account you used to set up Microsoft You do lose the additional storage that comes with your subscription, so you must save your files elsewhere or buy more OneDrive storage if your OneDrive account exceeds the free storage quota.

When would my subscription start? How do I share Microsoft with the rest of my household? To add someone to your subscription, visit www. Numeric cells can be used for calculations and functions. A numeric cell may contain numbers, a decimal point. Type the numeric information that should be in the cell. HINT: To enter a fraction, type 0 and press [Space] before the fraction; otherwise, Excel will interpret the fraction as a date. To accept the information, press [Enter] or an [Arrow].

Do not include spaces or alphabetical characters in a calculation cell. When cells are formatted for text, all cell contents—letters, numerals, or alpha-numeric combinations—are treated as text. Information is displayed exactly as it is entered. There are two ways to enter numbers as text. In the Number group, click Format Cells. The Format Cells dialog box appears. For information on having Excel automatically insert dates and times, refer to Inserting Dates and Times.

The following steps should be used when you are saving a worksheet for the first time, when you want to save it to a new location e.

From the File menu, select Save As The Save As dialog box appears. Optional To save your workbook in a format other than the default. NOTE: This is an important consideration if you want your document to be able to open in Excel From the File menu, select Save.