Microsoft Excel Training From Your MS Computer Trainer
February 22nd, 2010 — format worksheets
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. Continue reading →
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.
February 4th, 2010 — format worksheets
You have three worksheets that will have the same column headings and/or the same row headings/labels. The only thing that will change are the numbers. So make it easy for yourself. Make the column headings and row labels of all three worksheets at the same time.
Open Excel. The three worksheets are displayed and labeled as Sheet1, Sheet2, and Sheet3. The active worksheet is Sheet1. Inactive worksheets are displayed as tan-colored tabs. Hold down the Ctrl key and click on Sheet2 and Sheet3.
In column A, type the numbers 1 through 5 in each cell of that column. In cells B2, C2, D3, E3, and F3, type the first 5 letters of the alphabet (A B C D E). Now, click on Sheet2 and Sheet3. You’ve typed into three different worksheets at the same time, with the same information.
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.
October 31st, 2009 — format worksheets
Over the course of a semester, several students in my Excel class print their first Excel exercise for me to correct and ask how to print the Gridlines, column headings (not headers) for each page, and the row numbers and column letters that are not automatically printed with the spreadsheet. Continue reading →
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.
September 16th, 2009 — format worksheets
Why are pound symbols (#####) in my cells? Continue reading →
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.
June 25th, 2009 — format worksheets
Open Microsoft Excel and you see worksheet gridlines, and labels that identify each row and column. Print Microsoft Excel and you may see nothing but the numbers themselves. No gridlines. No row and column headings. What happened? Continue reading →
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.
June 25th, 2009 — format worksheets
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? Continue reading →
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.
May 11th, 2009 — format worksheets
The Currency toolbar button ( $ ) in Excel 2003 and 2007 will not display a number the same way as the Currency category in the Format Cells dialog box. Continue reading →
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.
April 11th, 2009 — format worksheets
Typing a number and clicking the % toolbar button is the same as multiplying that number by 100 and adding a percent symbol behind it.
Enter the number 10, and then click the % toolbar button on that cell. The number turns into 1000%.
In another cell, type the number .10 (decimal in front of the 10). Click the % toolbar button on that cell. The number quickly turns into 10%, not 1000%.
Keep in mind the results when converting whole and decimal numbers to percent numbers with the % toolbar button .
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.
March 9th, 2009 — format worksheets
I am a teacher with an assignment that is a 5 week, once a week course. Figuring the date for each meeting is simple by adding 7 days between each date. But if the class starts in the middle of the month, a 30 or 31 day presents a problem, including February’s 28 or 29 days. Continue reading →
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.
March 1st, 2009 — format worksheets
A Dollar is a Dollar? Not with Excel.
Type the following numbers in a column: 1000, 2000, 3000.
Format -> Cells -> Currency -> OK
Format -> Cells -> Accounting -> OK
Now, change the column width to 12:
Format -> Columns -> Width -> 12 -> OK
Notice the $ symbol before the number 1000 is next to the first number, while the $ symbol before the number 2000 is not next to the first number, but next to the left-cell border.
Now, here is the twist. The Currency format category in the Format Cells dialog box is not the same as the Currency Style on the Formatting Toolbar.
Click on the number 3000, then click the $ symbol on the Formatting Toolbar. The $ symbol is next to the left border of the cell, which is the Accounting format. Go figure. Kind of like finding the Shutdown command in the Start button.
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.