Monthly Archives: February 2012

Numbers Entered as Fractions

February 20, 2012
By

The first time a new student enters a fraction in a cell, the number changes into a date. If you know you will be entering a series of fractions in a worksheet that will be used in calculations, change the cell format to recognize those values as fractions instead of text. Here is how to make that change. Read more »

Related Articles:

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter

Zeroes Entered after Decimals

February 19, 2012
By

Entering numbers followed by a decimal with trailing zeros will not immediately display the zeros. The default format for a number is the category called Number that does not display decimal. Here’s how to display zeros in a cell. Read more »

Related Articles:

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter

Page Break Preview

February 18, 2012
By

A common question I receive about Microsoft Excel is “How do I know when I am near the bottom of the spreadsheet, and where is the right margin of the spreadsheet? Read more »

Related Articles:

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.

Originally posted 2010-02-24 06:00:10. Republished by Blog Post Promoter

Archives

Tags

accounting format AutoAum AutoFill AutoFit Columns close Excel column border columns not wide enough Context menu copy cells currency format currency style cursor cut and paste cells date dates Drag and Drop edit Edit menu fill series format numbers formulas fractions Functions Keyboard shortcuts mouse pointer move sheet tab move worksheet normal view numbers open Excel page break view pound symbol print active worksheet print entire workbook print list print row and column headings print selection print titles randbetween random numbers save Excel set print area sum function the " # " symbol turn on gridlines