Formula results are shown in worksheet cells, while formulas are visible in the formula bar only so that they won’t appear when you print. Showing formulas in the cells makes it easy to find cells that contain formulas, or to check for errors. With a quick key combination you can see formulas instead of formula results in a worksheet.
To show formulas in all cells press CTRL+` (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would. To switch back to showing formula results in all cells, press CTRL+` again.
Tip: If you’re having trouble finding the grave accent mark key (`), it is often located in the upper left corner on keyboards, but not always. If it’s difficult to find on your keyboard, you can also show and hide formulas by going to the Formulas tab and then clicking Show Formulas. To switch back to the standard view, click the button again.
The formula only appears in the formula bar while the results appear in the workbook cells in Excel for the web. But you can do a screen capture or copy and paste the formulas to an application like Notepad and then print them.
The first step of learning about spreadsheets is understanding the terminology you will encounter as you work through this lesson. The glossary below lists terms that are specific to spreadsheet applications. Terminology that we learned when we looked at wordprocessing (such as copy, paste, clipboard, etc.) also apply to spreadsheet applications.
Page 2We have looked at the basic terminology associated with spreadsheets and are now ready to look at more specific how-to's. Below are links to step-by-step tutorials from the Microsoft Website that explain common spreadsheet tasks and provide instructions and tips for performing these functions in the most efficient manner. The links below will take you through the basics of creating a spreadsheet, working with the types of data that can be input and give you an introduction to formulas and functions. The tutorials are either text or video based and all demonstrate tasks in Microsoft Excel 2010 -- our campus standard at Broome Community College. Note: The tutorials and documents listed below are only a small percentage of the complete set of the complete series available on the Microsoft site. To access all available Microsoft Office training materials please visit Microsoft's site at: http://office.microsoft.com/en-us/support/training-FX101782702.aspx Links to Microsoft Excel 2010 Tutorials and Documents Get to know Excel 2010: Create your first spreadsheet If you are new to Microsoft Excel and to the creating of spreadsheets, this is where you should begin! This tutorial will give you examples of the types of spreadsheets that can be created, an overview of the Excel environment, and the basics of creating a new spreadsheet. The tutorial then moves on to performing basic math calculations, navigating within Excel and printing. It concludes with a practice and self test. Basic Tasks in Excel 2010 The above link to the document will walk you through some of the basic tasks you will need to know in Microsoft Excel. In addition to entering data, this document will show you the basic formatting option , and methods of sorting and filtering your data. In addition, this document will also provide you with links to more detailed information. When reading the documents below, be sure to also click on the links contained within them. There are some great videos and Quick Start Guides that will help in your journey of learning Excel.
Excel 2010 Keyboard Shortcuts (CTRL Key Shortcuts) Using the keyboard rather than menus or toolbars can be a real time-saver. This course will introduce you to the shortcut keyboard combinations (using the CTRL Key) that you can use to carry out commonly performed tasks. Excel 2010 Keyboard Shortcuts (ALT Key Shortcuts) Using the keyboard rather than menus or toolbars can be a real time-saver. This course will introduce you to the shortcut keyboard combinations (using the ALT Key) that you can use to carry out commonly performed tasks. Additional Training Courses and information can also be found on the "Training courses for Excel 2010" page. |